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