Upgrading Moodle database from version 1.9.5 (Build: 20090515) (2007101550) to 1.9.9 (Build: 20100609) (2007101590)...


(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.


(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): UPDATE mdl_user_preferences SET value = '1' WHERE id = '1'  
ERROR: Could not instantiate mail function.
(mysql): INSERT INTO mdl_log (time, userid, course, ip, module, cmid, action, url, info) VALUES ('1281426082', '2', '1', '192.168.0.108', 'library', '0', 'mailer', 'http://www.cultura-antreprenoriala.ro/elearning/admin/index.php?confirmupgrade=1&confirmrelease=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): UPDATE mdl_course SET sortorder = '2001' WHERE id = '2'  

(mysql): UPDATE mdl_course SET sortorder = '3002' WHERE id = '8'  

(mysql): UPDATE mdl_course SET sortorder = '4003' WHERE id = '4'  

(mysql): UPDATE mdl_course SET sortorder = '5004' WHERE id = '5'  

(mysql): UPDATE mdl_course SET sortorder = '6005' WHERE id = '6'  

(mysql): UPDATE mdl_course SET sortorder = '7006' WHERE id = '9'  

(mysql): UPDATE mdl_course SET sortorder = '8007' WHERE id = '10'  

(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://www.cultura-antreprenoriala.ro/elearning' 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 * FROM mdl_mnet_host WHERE id = '-1'  

(mysql): INSERT INTO mdl_mnet_host ( DELETED, WWWROOT, IP_ADDRESS, NAME, PUBLIC_KEY, PUBLIC_KEY_EXPIRES, LAST_CONNECT_TIME, LAST_LOG_ID, APPLICATIONID ) VALUES ( 0, 'http://www.cultura-antreprenoriala.ro/elearning', '81.196.126.194', '', '', 0, 0, 0, 1 )  

(mysql): SELECT LAST_INSERT_ID()  

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

(mysql): UPDATE mdl_config SET value = '3' WHERE name = 'mnet_localhost_id'  

(mysql): DELETE FROM mdl_mnet_host WHERE id = '1'  

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

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

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '1'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '2'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '3'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '4'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '5'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '6'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '7'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '8'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '9'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '10'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '11'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '12'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '13'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '14'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '15'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '16'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '17'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '18'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '19'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '20'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '21'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '22'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '23'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '24'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '25'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '26'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '27'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '28'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '29'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '30'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '34'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '35'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '36'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '37'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '43'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '44'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '46'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '45'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '47'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '48'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '49'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '50'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '52'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '53'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '54'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '55'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '56'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '57'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '58'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '59'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '60'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '61'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '62'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '63'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '64'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '65'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '66'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '67'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '68'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '69'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '70'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '71'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '72'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '73'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '74'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '75'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '76'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '77'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '78'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '79'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '80'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '81'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '82'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '83'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '84'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '85'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '86'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '87'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '88'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '89'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '90'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '91'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '92'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '93'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '94'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '95'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '96'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '97'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '98'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '197'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '99'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '100'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '101'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '102'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '103'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '104'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '105'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '106'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '107'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '108'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '109'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '110'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '111'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '112'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '113'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '114'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '115'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '116'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '117'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '118'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '119'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '120'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '121'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '122'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '123'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '124'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '125'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '126'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '127'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '128'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '129'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '130'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '131'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '132'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '133'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '134'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '135'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '136'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '137'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '138'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '139'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '140'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '141'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '142'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '143'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '144'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '145'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '146'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '147'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '148'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '149'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '150'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '151'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '163'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '152'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '153'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '154'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '155'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '156'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '157'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '158'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '159'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '160'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '161'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '162'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '164'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '165'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '166'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '167'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '168'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '169'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '170'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '171'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '172'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '173'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '174'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '175'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '176'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '177'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '178'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '179'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '180'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '181'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '182'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '183'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '184'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '185'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '186'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '187'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '188'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '189'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '190'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '191'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '192'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '193'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '194'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '195'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '196'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '198'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '199'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '200'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '201'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '202'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '203'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '204'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '205'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '206'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '207'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '208'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '209'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '210'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '211'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '212'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '213'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '214'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '215'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '216'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '217'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '218'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '219'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '220'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '221'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '222'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '223'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '224'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '225'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '226'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '227'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '228'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '229'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '230'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '231'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '232'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '233'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '234'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '235'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '236'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '237'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '238'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '239'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '240'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '241'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '242'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '243'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '244'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '245'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '246'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '247'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '248'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '249'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '250'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '251'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '252'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '253'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '254'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '255'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '256'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '257'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '258'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '259'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '260'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '261'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '262'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '263'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '264'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '265'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '266'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '267'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '268'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '269'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '270'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '271'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '272'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '273'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '274'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '275'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '276'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '277'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '278'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '279'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '280'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '281'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '282'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '283'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '284'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '285'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '286'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '287'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '288'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '289'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '290'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '291'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '292'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '293'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '294'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '295'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '296'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '297'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '298'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '299'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '300'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '301'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '302'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '303'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '304'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '305'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '306'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '307'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '308'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '309'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '310'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '311'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '312'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '313'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '314'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '315'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '316'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '317'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '318'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '319'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '320'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '321'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '322'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '323'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '324'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '325'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '326'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '327'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '328'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '329'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '330'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '331'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '332'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '333'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '334'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '335'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '336'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '337'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '338'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '339'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '340'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '341'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '342'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '343'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '344'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '345'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '346'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '347'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '348'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '349'  

(mysql): UPDATE mdl_user SET mnethostid = '3' WHERE id = '350'  

(mysql): UPDATE mdl_mnet_host SET applicationid = '1' WHERE id = 3 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'  

(mysql): DELETE FROM mdl_config WHERE name = 'regenloginsession'  

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

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