Upgrading Moodle database from version 1.8.4+ (2007101522) to 1.9.3+ (Build: 20090121) (2007101533.02)...
(mysql): ALTER TABLE mdl_user MODIFY COLUMN lang VARCHAR(30) NOT NULL DEFAULT 'en_utf8' after country
Success
(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1
(mysql): UPDATE mdl_config SET value = '2007101526' WHERE name = 'version'
(mysql): SELECT value FROM mdl_config WHERE name = 'statsruntimedays' LIMIT 1
(mysql): SELECT name FROM mdl_config WHERE name = 'statsruntimedays' LIMIT 1
(mysql): SELECT * FROM mdl_config WHERE id = '-1'
(mysql): INSERT INTO mdl_config ( NAME, VALUE ) VALUES ( 'statsruntimedays', '31' )
(mysql): SELECT LAST_INSERT_ID()
(mysql): SELECT r.*
FROM mdl_role r,
mdl_role_capabilities rc
WHERE rc.capability = 'moodle/course:update'
AND rc.roleid = r.id AND (rc.contextid = '1' OR rc.contextid IN (1)) AND rc.permission = '1'
(mysql): SELECT * FROM mdl_role_capabilities WHERE contextid = '1' AND roleid = '1' AND capability = 'moodle/course:visibility' LIMIT 1
(mysql): SELECT * FROM mdl_role_capabilities WHERE contextid = '1' AND roleid = '3' AND capability = 'moodle/course:visibility' LIMIT 1
(mysql): SELECT * FROM mdl_context WHERE id = '1' LIMIT 1
(mysql): SELECT * FROM mdl_role_capabilities WHERE id = '-1'
(mysql): INSERT INTO mdl_role_capabilities ( CONTEXTID, ROLEID, CAPABILITY, PERMISSION, TIMEMODIFIED, MODIFIERID ) VALUES ( 1, 3, 'moodle/course:visibility', 1, 1232683614, 2 )
(mysql): SELECT LAST_INSERT_ID()
(mysql): SELECT * FROM mdl_cache_flags WHERE name = '/1' AND flagtype = 'accesslib/dirtycontexts' LIMIT 1
(mysql): SELECT * FROM mdl_cache_flags WHERE id = '-1'
(mysql): INSERT INTO mdl_cache_flags ( FLAGTYPE, NAME, TIMEMODIFIED, VALUE, EXPIRY ) VALUES ( 'accesslib/dirtycontexts', '/1', 1232683614, '1', 1232690814 )
(mysql): SELECT LAST_INSERT_ID()
(mysql): SELECT name FROM mdl_config WHERE name = 'version' LIMIT 1
(mysql): UPDATE mdl_config SET value = '2007101532.1' WHERE name = 'version'
Database was successfully upgraded