Upgrading Moodle database from version 1.9.5 (Build: 20090515) (2007101550) to 1.9.7+ (Build: 20091202) (2007101570)...

----- (mysql): SELECT * FROM md_log_display WHERE action = 'update' AND module = 'tag' LIMIT 1 ----- ----- (mysql): SELECT * FROM md_log_display WHERE id = '-1' ----- ----- (mysql): INSERT INTO md_log_display ( MODULE, ACTION, MTABLE, FIELD ) VALUES ( 'tag', 'update', 'tag', 'name' ) ----- ----- (mysql): SELECT LAST_INSERT_ID() ----- ----- (mysql): SELECT name FROM md_config WHERE name = 'version' LIMIT 1 ----- ----- (mysql): UPDATE md_config SET value = '2007101551' WHERE name = 'version' ----- ----- (mysql): SELECT * FROM md_config WHERE name = 'passwordpolicy' AND value = '0' LIMIT 1 ----- ----- (mysql): DELETE FROM md_config WHERE name = 'passwordpolicy' -----

Moodle 1.9.7 contains a number of security fixes to user passwords and backups to protect the user data on your site. As a result some of your settings and permissions relating to backups may have changed.
See the Moodle 1.9.7 release notes for full details.

To reduce the risk of password theft, you are strongly recommended to set a password salt.
See the password salting documentation for details.
----- (mysql): SELECT name FROM md_config WHERE name = 'version' LIMIT 1 ----- ----- (mysql): UPDATE md_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, u.mailformat FROM md_role_capabilities rc JOIN md_role_assignments ra ON (ra.contextid = rc.contextid AND ra.roleid = rc.roleid) JOIN md_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 AND (u.auth='manual' OR u.auth='email') ----- ----- (mysql): SELECT * FROM md_user_preferences WHERE userid = '2' AND name = 'auth_forcepasswordchange' LIMIT 1 ----- ----- (mysql): UPDATE md_user_preferences SET value = '1' WHERE id = '1' ----- ERROR: SMTP Error: Data not accepted. ----- (mysql): INSERT INTO md_log (time, userid, course, ip, module, cmid, action, url, info) VALUES ('1262217123', '0', '1', '67.222.37.11', 'library', '0', 'mailer', 'http://www.faithccf.com/bibleschool/admin/index.php?confirmupgrade=1&confirmrelease=1&confirmplug...', 'ERROR: SMTP Error: Data not accepted.') ----- ----- (mysql): SELECT name FROM md_config WHERE name = 'version' LIMIT 1 ----- ----- (mysql): UPDATE md_config SET value = '2007101561.02' WHERE name = 'version' ----- ----- (mysql): SELECT DISTINCT u.id, u.firstname, u.lastname, u.picture, u.imagealt, u.email, u.password FROM md_role_capabilities rc JOIN md_role_assignments ra ON (ra.contextid = rc.contextid AND ra.roleid = rc.roleid) JOIN md_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 AND u.auth<>'manual' AND u.auth<>'email' ----- ----- (mysql): SELECT name FROM md_config WHERE name = 'version' LIMIT 1 ----- ----- (mysql): UPDATE md_config SET value = '2007101563.02' WHERE name = 'version' ----- ----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/cas' ----- ----- (mysql): UPDATE md_user SET password='not cached' WHERE auth='cas' -----
Success
----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/db' ----- ----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/email' ----- ----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/fc' ----- ----- (mysql): UPDATE md_user SET password='not cached' WHERE auth='fc' -----
Success
----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/imap' ----- ----- (mysql): UPDATE md_user SET password='not cached' WHERE auth='imap' -----
Success
----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/ldap' ----- ----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/manual' ----- ----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/mnet' ----- ----- (mysql): UPDATE md_user SET password='not cached' WHERE auth='mnet' -----
Success
----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/nntp' ----- ----- (mysql): UPDATE md_user SET password='not cached' WHERE auth='nntp' -----
Success
----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/none' ----- ----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/pam' ----- ----- (mysql): UPDATE md_user SET password='not cached' WHERE auth='pam' -----
Success
----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/pop3' ----- ----- (mysql): UPDATE md_user SET password='not cached' WHERE auth='pop3' -----
Success
----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/radius' ----- ----- (mysql): UPDATE md_user SET password='not cached' WHERE auth='radius' -----
Success
----- (mysql): SELECT name,value FROM md_config_plugins WHERE plugin = 'auth/shibboleth' ----- ----- (mysql): UPDATE md_user SET password='not cached' WHERE auth='shibboleth' -----
Success
----- (mysql): SELECT name FROM md_config WHERE name = 'version' LIMIT 1 ----- ----- (mysql): UPDATE md_config SET value = '2007101563.03' WHERE name = 'version' -----
Database was successfully upgraded