Upgrading Moodle database from version 1.9.5+ (Build: 20090701) (2007101550) to 1.9.7+ (Build: 20100217) (2007101571.04)...


(mysql): SELECT * FROM mdl_log_display WHERE action = 'update' AND module = 'tag' LIMIT 1  

(mysql): SELECT * FROM mdl_log_display WHERE id = '-1'  

(mysql): INSERT INTO mdl_log_display ( MODULE, ACTION, MTABLE, FIELD ) VALUES ( 'tag', 'update', 'tag', 'name' )  

(mysql): SELECT LAST_INSERT_ID()  

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1  

(mysql): UPDATE mdl_config SET value = '2007101551' WHERE name = 'version'  

(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 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 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, u.mailformat 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 AND (u.auth='manual' OR u.auth='email')  

(mysql): SELECT * FROM mdl_user_preferences WHERE userid = '2' AND name = 'auth_forcepasswordchange' LIMIT 1  

(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()  
ERROR: Could not instantiate mail function.
(mysql): INSERT INTO mdl_log (time, userid, course, ip, module, cmid, action, url, info) VALUES ('1266786641', '2', '1', '127.0.0.1', 'library', '0', 'mailer', 'http://localhost/moodle/admin/index.php?confirmupgrade=1&confirmrelease=1&confirmplugincheck=1', 'ERROR: Could not instantiate mail function.')  

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1  

(mysql): UPDATE mdl_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 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 AND u.auth<>'manual' AND u.auth<>'email'  

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1  

(mysql): UPDATE mdl_config SET value = '2007101563.02' WHERE name = 'version'  

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/cas'  

(mysql): UPDATE mdl_user SET password='not cached' WHERE auth='cas'  
Success

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/db'  

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/email'  

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/fc'  

(mysql): UPDATE mdl_user SET password='not cached' WHERE auth='fc'  
Success

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/imap'  

(mysql): UPDATE mdl_user SET password='not cached' WHERE auth='imap'  
Success

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/ldap'  

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/manual'  

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/mnet'  

(mysql): UPDATE mdl_user SET password='not cached' WHERE auth='mnet'  
Success

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/nntp'  

(mysql): UPDATE mdl_user SET password='not cached' WHERE auth='nntp'  
Success

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/none'  

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/pam'  

(mysql): UPDATE mdl_user SET password='not cached' WHERE auth='pam'  
Success

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/pop3'  

(mysql): UPDATE mdl_user SET password='not cached' WHERE auth='pop3'  
Success

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/radius'  

(mysql): UPDATE mdl_user SET password='not cached' WHERE auth='radius'  
Success

(mysql): SELECT name,value FROM mdl_config_plugins WHERE plugin = 'auth/shibboleth'  

(mysql): UPDATE mdl_user SET password='not cached' WHERE auth='shibboleth'  
Success

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1  

(mysql): UPDATE mdl_config SET value = '2007101563.03' WHERE name = 'version'  

(mysql): SELECT id, category, sortorder from mdl_course ORDER BY sortorder ASC;  

(mysql): UPDATE mdl_course SET sortorder = '1000' WHERE id = '1'  

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1  

(mysql): UPDATE mdl_config SET value = '2007101571.01' WHERE name = 'version'  

(mysql): SELECT * FROM mdl_mnet_host WHERE wwwroot = 'http://localhost/moodle' LIMIT 1  

(mysql): SELECT * FROM mdl_mnet_host WHERE (wwwroot = '') LIMIT 1  

(mysql): SELECT id FROM mdl_mnet_application WHERE name = 'moodle' LIMIT 1  

(mysql): SELECT id, id AS id2 FROM mdl_mnet_host  

(mysql): SELECT id FROM mdl_user u1 WHERE u1.mnethostid NOT IN (1, 2) AND NOT EXISTS ( SELECT 'x' FROM mdl_user u2 WHERE u2.username = u1.username AND u2.mnethostid = 1)  

(mysql): UPDATE mdl_mnet_host SET applicationid = '1' WHERE id = 1 or id = 2  

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1  

(mysql): UPDATE mdl_config SET value = '2007101571.02' WHERE name = 'version'  

(mysql): ALTER TABLE mdl_mnet_host MODIFY COLUMN portno MEDIUMINT(5) unsigned NOT NULL DEFAULT 0  
Success

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1  

(mysql): UPDATE mdl_config SET value = '2007101571.03' WHERE name = 'version'  

(mysql): SELECT name FROM mdl_config WHERE name = 'filter_tex_latexpreamble' LIMIT 1  

(mysql): UPDATE mdl_config SET value = '\\usepackage[latin1]{inputenc} \\usepackage{amsmath} \\usepackage{amsfonts} \\RequirePackage{amsmath,amssymb,latexsym} ' WHERE name = 'filter_tex_latexpreamble'  

(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1  

(mysql): UPDATE mdl_config SET value = '2007101571.04' WHERE name = 'version'  
Database was successfully upgraded

resource module needs upgrading


(mysql): UPDATE mdl_resource SET options = 'objectframe' WHERE (UPPER(reference) LIKE '%.PDF' OR UPPER(reference) LIKE '%.FDF' OR UPPER(reference) LIKE '%.XDP' OR UPPER(reference) LIKE '%.XFD' OR UPPER(reference) LIKE '%.XFDF') AND type='file' AND (popup = '') AND ( (options = '') OR options = 'frame')  
Success
resource tables have been set up correctly

workshop module needs upgrading


(mysql): SELECT wa.id FROM mdl_workshop_assessments wa LEFT JOIN mdl_workshop_submissions ws ON wa.submissionid = ws.id WHERE ws.id IS NULL  
workshop tables have been set up correctly

backup

Database was successfully upgraded
Backup version is now 2009111300

New version of Section Links (section_links) exists

Section Links tables have been set up correctly