Upgrading Moodle database from version 1.9.6+ (Build: 20091117) (2007101560) to 1.9.6+ (Build: 20091117) (2007101561)... (mysql): SELECT * FROM mdl_config WHERE name = 'passwordpolicy' AND value = '0' LIMIT 1 (mysql): DELETE FROM mdl_config WHERE name = 'passwordpolicy' Moodle 1.9.7 contains a number of security fixes to user passwords and backups to protect the user information on your site. As a result some of your settings and permissions relating to backups may have changed. Please see the Moodle 1.9.7 release notes for full details. It is also now strongly recommended that you set a password salt to greatly reduce the risk of password theft. Please refer to the password salting documentation for details. (mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1 (mysql): UPDATE mdl_config SET value = '2007101561.01' WHERE name = 'version' (mysql): SELECT DISTINCT u.id, u.firstname, u.lastname, u.picture, u.imagealt, u.email, u.password FROM mdl_role_capabilities rc JOIN mdl_role_assignments ra ON (ra.contextid = rc.contextid AND ra.roleid = rc.roleid) JOIN mdl_user u ON u.id = ra.userid WHERE rc.capability = 'moodle/site:doanything' AND rc.permission = 1 AND u.deleted = 0 AND rc.contextid = 1 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '2' AND name = 'auth_forcepasswordchange' LIMIT 100 (mysql): SELECT * FROM mdl_user_preferences WHERE id = '-1' (mysql): INSERT INTO mdl_user_preferences ( USERID, NAME, VALUE ) VALUES ( 2, 'auth_forcepasswordchange', '1' ) (mysql): SELECT LAST_INSERT_ID() Notice: Undefined property: stdClass::$maildisplay in /var/www/sdcmoodle/lib/moodlelib.php on line 4267 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '2' AND name = 'email_send_count' LIMIT 100 (mysql): SHOW COLUMNS FROM `mdl_user_preferences` (mysql): UPDATE mdl_user_preferences SET userid = '2',name = 'email_send_count',value = '9' WHERE id = 2 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '3' AND name = 'auth_forcepasswordchange' LIMIT 100 (mysql): INSERT INTO mdl_user_preferences ( USERID, NAME, VALUE ) VALUES ( 3, 'auth_forcepasswordchange', '1' ) (mysql): SELECT LAST_INSERT_ID() Notice: Undefined property: stdClass::$maildisplay in /var/www/sdcmoodle/lib/moodlelib.php on line 4267 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '3' AND name = 'email_send_count' LIMIT 100 (mysql): SHOW COLUMNS FROM `mdl_user_preferences` (mysql): UPDATE mdl_user_preferences SET userid = '3',name = 'email_send_count',value = '153' WHERE id = 4 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '505' AND name = 'auth_forcepasswordchange' LIMIT 100 (mysql): INSERT INTO mdl_user_preferences ( USERID, NAME, VALUE ) VALUES ( 505, 'auth_forcepasswordchange', '1' ) (mysql): SELECT LAST_INSERT_ID() Notice: Undefined property: stdClass::$maildisplay in /var/www/sdcmoodle/lib/moodlelib.php on line 4267 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '505' AND name = 'email_send_count' LIMIT 100 (mysql): SHOW COLUMNS FROM `mdl_user_preferences` (mysql): UPDATE mdl_user_preferences SET userid = '505',name = 'email_send_count',value = '40' WHERE id = 222 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '1181' AND name = 'auth_forcepasswordchange' LIMIT 100 (mysql): UPDATE mdl_user_preferences SET value = '1' WHERE id = '9472' Notice: Undefined property: stdClass::$maildisplay in /var/www/sdcmoodle/lib/moodlelib.php on line 4267 ERROR: SMTP Error: The following recipients failed: kevtufc@gmail.com (mysql): INSERT INTO mdl_log (time, userid, course, ip, module, cmid, action, url, info) VALUES ('1258545082', '13385', '1', '172.21.3.114', 'library', '0', 'mailer', 'http://172.21.3.114/sdcmoodle/admin/index.php?confirmupgrade=1&confirmrelease=1&confirmplugincheck=1', 'ERROR: SMTP Error: The following recipients failed: kevtufc@gmail.com') (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '6445' AND name = 'auth_forcepasswordchange' LIMIT 100 (mysql): INSERT INTO mdl_user_preferences ( USERID, NAME, VALUE ) VALUES ( 6445, 'auth_forcepasswordchange', '1' ) (mysql): SELECT LAST_INSERT_ID() Notice: Undefined property: stdClass::$maildisplay in /var/www/sdcmoodle/lib/moodlelib.php on line 4267 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '6445' AND name = 'email_send_count' LIMIT 100 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '12938' AND name = 'auth_forcepasswordchange' LIMIT 100 (mysql): INSERT INTO mdl_user_preferences ( USERID, NAME, VALUE ) VALUES ( 12938, 'auth_forcepasswordchange', '1' ) (mysql): SELECT LAST_INSERT_ID() Notice: Undefined property: stdClass::$maildisplay in /var/www/sdcmoodle/lib/moodlelib.php on line 4267 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '12938' AND name = 'email_send_count' LIMIT 100 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '13385' AND name = 'auth_forcepasswordchange' LIMIT 100 (mysql): UPDATE mdl_user_preferences SET value = '1' WHERE id = '14285' Notice: Undefined property: stdClass::$maildisplay in /var/www/sdcmoodle/lib/moodlelib.php on line 4267 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '13385' AND name = 'email_send_count' LIMIT 100 (mysql): SHOW COLUMNS FROM `mdl_user_preferences` (mysql): UPDATE mdl_user_preferences SET userid = '13385',name = 'email_send_count',value = '20' WHERE id = 14012 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '13730' AND name = 'auth_forcepasswordchange' LIMIT 100 (mysql): UPDATE mdl_user_preferences SET value = '1' WHERE id = '14731' Notice: Undefined property: stdClass::$maildisplay in /var/www/sdcmoodle/lib/moodlelib.php on line 4267 (mysql): SELECT * FROM mdl_user_preferences WHERE userid = '13730' AND name = 'email_send_count' LIMIT 100 (mysql): SHOW COLUMNS FROM `mdl_user_preferences` (mysql): UPDATE mdl_user_preferences SET userid = '13730',name = 'email_send_count',value = '1' WHERE id = 14733 (mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1 (mysql): UPDATE mdl_config SET value = '2007101561.02' WHERE name = 'version' Database was successfully upgraded