assignment module needs upgrading
(mysql): ALTER TABLE mdl_assignment_submissions MODIFY COLUMN data1 TEXT NULL after numfiles
Success
(mysql): ALTER TABLE mdl_assignment_submissions MODIFY COLUMN data2 TEXT NULL after data1
Success
(mysql): UPDATE mdl_assignment SET var4=1 WHERE assignmenttype='upload'
Success
Processing assignment grades, this may take a while if there are many assignments...
assignment tables have been set up correctly
mod/assignment/type/online plugin needs upgrading
online tables have been set up correctly
chat module needs upgrading
chat tables have been set up correctly
choice module needs upgrading
choice tables have been set up correctly
data module needs upgrading
(mysql): ALTER TABLE mdl_data ADD notification BIGINT(10) DEFAULT NULL after editany
Success
(mysql): SHOW TABLES
(mysql): SHOW INDEX FROM mdl_data_fields
(mysql): CREATE INDEX mdl_datafiel_typdat_ix ON mdl_data_fields (type, dataid)
Success
(mysql): SHOW TABLES
(mysql): SHOW INDEX FROM mdl_data
(mysql): CREATE INDEX mdl_data_cou_ix ON mdl_data (course)
Success
(mysql): ALTER TABLE mdl_data ADD asearchtemplate TEXT after jstemplate
Success
(mysql): SELECT value FROM mdl_config_plugins WHERE plugin = 'data' AND name = 'requiredentriesfixflag' LIMIT 1
(mysql): SELECT id FROM mdl_config_plugins WHERE name = 'requiredentriesfixflag' AND plugin = 'data' LIMIT 1
(mysql): SELECT * FROM mdl_config_plugins WHERE id = '-1'
(mysql): INSERT INTO mdl_config_plugins ( PLUGIN, NAME, VALUE ) VALUES ( 'data', 'requiredentriesfixflag', '1' )
(mysql): SELECT LAST_INSERT_ID()
(mysql): SELECT d.*, c.fullname
FROM mdl_data d, mdl_course c
WHERE d.course = c.id
AND (d.requiredentries > 0 OR d.requiredentriestoview > 0)
ORDER BY c.fullname, d.name
data tables have been set up correctly
forum module needs upgrading
(mysql): ALTER TABLE mdl_forum_queue ADD timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0 after postid
Success
Processing forum grades, this may take a while if there are many forums...
Removing stale forum subscriptions
(mysql): SELECT r.*
FROM mdl_role r,
mdl_role_capabilities rc
WHERE rc.capability = 'moodle/course:view'
AND rc.roleid = r.id AND rc.permission = '1'
(mysql): SELECT fs.userid, f.id AS forumid
FROM mdl_forum f
JOIN mdl_course c ON c.id = f.course
JOIN mdl_context ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = 50)
JOIN mdl_forum_subscriptions fs ON fs.forum = f.id
LEFT JOIN mdl_role_assignments ra ON (ra.contextid = ctx.id AND ra.userid = fs.userid AND ra.roleid IN (1,3,4,5,6))
WHERE ra.id IS NULL
forum tables have been set up correctly
glossary module needs upgrading
glossary tables have been set up correctly
hotpot module needs upgrading
Processing hotpot grades, this may take a while if there are many hotpots...
hotpot tables have been set up correctly
journal module needs upgrading
journal tables have been set up correctly
label module needs upgrading
(mysql): UPDATE mdl_log_display SET mtable = 'label' WHERE module = 'label'
Success
label tables have been set up correctly
lams module needs upgrading
lams tables have been set up correctly
lesson module needs upgrading
lesson tables have been set up correctly
quiz module needs upgrading
(mysql): SELECT value FROM mdl_config_plugins WHERE plugin = 'qtype_random' AND name = 'selectmanual' LIMIT 1
(mysql): SELECT value FROM mdl_config_plugins WHERE plugin = 'qtype_random' AND name = 'selectmanual' LIMIT 1
(mysql): SELECT id FROM mdl_question_numerical_units WHERE id > (SELECT MIN(iqnu.id)
FROM mdl_question_numerical_units iqnu
WHERE iqnu.question = mdl_question_numerical_units.question AND
iqnu.unit = mdl_question_numerical_units.unit)
(mysql): SHOW TABLES
(mysql): SHOW INDEX FROM mdl_question_numerical_units
(mysql): CREATE UNIQUE INDEX mdl_quesnumeunit_queuni_uix ON mdl_question_numerical_units (question, unit)
Success
(mysql): ALTER TABLE mdl_quiz MODIFY COLUMN timelimit BIGINT(10) unsigned NOT NULL DEFAULT 0 after timemodified
Success
(mysql): UPDATE mdl_quiz SET review = ((((review) & ((~(71565312))))) | (((((review) & (4)) * 65536) | (((((review) & (256)) * 16384) | (((review) & (16384)) * 4096))))))
Success
(mysql): SELECT name FROM mdl_config WHERE name = 'quiz_review' LIMIT 1
(mysql): UPDATE mdl_config SET value = '83886079' WHERE name = 'quiz_review'
quiz tables have been set up correctly
resource module needs upgrading
resource tables have been set up correctly
scorm module needs upgrading
(mysql): ALTER TABLE mdl_scorm ADD whatgrade BIGINT(10) unsigned NOT NULL DEFAULT 0 after grademethod
Success
scorm tables have been set up correctly
survey module needs upgrading
survey tables have been set up correctly
wiki module needs upgrading
wiki tables have been set up correctly
workshop module needs upgrading
workshop tables have been set up correctly
question/type/multianswer plugin needs upgrading
(mysql): SELECT q.id, q.category, qma.sequence FROM mdl_question q JOIN mdl_question_multianswer qma ON q.id = qma.question
multianswer tables have been set up correctly
question/type/multichoice plugin needs upgrading
(mysql): ALTER TABLE mdl_question_multichoice ADD answernumbering VARCHAR(10) NOT NULL DEFAULT 'abc' after incorrectfeedback
Success
(mysql): SELECT value FROM mdl_config_plugins WHERE plugin = 'qtype_random' AND name = 'selectmanual' LIMIT 1
(mysql): SELECT value FROM mdl_config_plugins WHERE plugin = 'qtype_random' AND name = 'selectmanual' LIMIT 1
(mysql): UPDATE mdl_question SET defaultgrade = '0' WHERE qtype = 'description' AND defaultgrade = '1'
(mysql): UPDATE mdl_question_multichoice SET answernumbering = 'ABCD' WHERE answernumbering = 'ABC'
multichoice tables have been set up correctly
backup
Database was successfully upgraded
Backup version is now 2008030301
blocks
(mysql): ALTER TABLE mdl_block_instance MODIFY COLUMN configdata TEXT NULL after visible
Success
Database was successfully upgraded
Blocks version is now 2007081300
New version of Activities (activity_modules) exists
Activities tables have been set up correctly
New version of Administration (admin) exists
Administration tables have been set up correctly
New version of Admin bookmarks (admin_bookmarks) exists
Admin bookmarks tables have been set up correctly
New version of Site Administration (admin_tree) exists
Site Administration tables have been set up correctly
New version of Blog Menu (blog_menu) exists
Blog Menu tables have been set up correctly
New version of Blog Tags (blog_tags) exists
Blog Tags tables have been set up correctly
New version of Calendar (calendar_month) exists
Calendar tables have been set up correctly
New version of Upcoming Events (calendar_upcoming) exists
Upcoming Events tables have been set up correctly
New version of Courses (course_list) exists
Courses tables have been set up correctly
New version of Course/Site Description (course_summary) exists
Course/Site Description tables have been set up correctly
New version of Random Glossary Entry (glossary_random) exists
Random Glossary Entry tables have been set up correctly
New version of HTML (html) exists
HTML tables have been set up correctly
New version of Loan calculator (loancalc) exists
Loan calculator tables have been set up correctly
New version of Login (login) exists
Login tables have been set up correctly
New version of Mentees (mentees) exists
Mentees tables have been set up correctly
New version of Messages (messages) exists
Messages tables have been set up correctly
New version of Network Servers (mnet_hosts) exists
Network Servers tables have been set up correctly
New version of Latest News (news_items) exists
Latest News tables have been set up correctly
New version of Online Users (online_users) exists
Online Users tables have been set up correctly
New version of People (participants) exists
People tables have been set up correctly
New version of Quiz Results (quiz_results) exists
Quiz Results tables have been set up correctly
New version of Recent Activity (recent_activity) exists
Recent Activity tables have been set up correctly
New version of Remote RSS Feeds (rss_client) exists
(mysql): UPDATE mdl_config SET name = 'block_rss_client_timeout' WHERE name = 'block_rss_timeout'
Remote RSS Feeds tables have been set up correctly
New version of Global Search (search) exists
(mysql): ALTER TABLE mdl_block_search_documents DROP COLUMN docdate
Success
(mysql): ALTER TABLE mdl_block_search_documents DROP COLUMN updated
Success
(mysql): ALTER TABLE mdl_block_search_documents ADD docdate BIGINT(10) unsigned NOT NULL DEFAULT 0 after url
Success
(mysql): ALTER TABLE mdl_block_search_documents ADD updated BIGINT(10) unsigned NOT NULL DEFAULT 0 after docdate
Success
Global Search tables have been set up correctly
New version of Search Forums (search_forums) exists
Search Forums tables have been set up correctly
New version of Section Links (section_links) exists
Section Links tables have been set up correctly
New version of Main Menu (site_main_menu) exists
Main Menu tables have been set up correctly
New version of Social Activities (social_activities) exists
Social Activities tables have been set up correctly
tag_flickr
Flickr tables have been set up correctly
tag_youtube
Youtube tables have been set up correctly
tags
Tags tables have been set up correctly
enrol/authorize plugin needs upgrading
(mysql): ALTER TABLE mdl_enrol_authorize DROP INDEX transid
Success
(mysql): ALTER TABLE mdl_enrol_authorize MODIFY COLUMN transid BIGINT(20) unsigned NOT NULL DEFAULT 0 after userid
Success
(mysql): SHOW TABLES
(mysql): SHOW INDEX FROM mdl_enrol_authorize
(mysql): CREATE INDEX mdl_enroauth_tra_ix ON mdl_enrol_authorize (transid)
Success
(mysql): ALTER TABLE mdl_enrol_authorize_refunds DROP INDEX transid
Success
(mysql): ALTER TABLE mdl_enrol_authorize_refunds MODIFY COLUMN transid BIGINT(20) unsigned NULL DEFAULT 0 after amount
Success
(mysql): SHOW TABLES
(mysql): SHOW INDEX FROM mdl_enrol_authorize_refunds
(mysql): CREATE INDEX mdl_enroauthrefu_tra_ix ON mdl_enrol_authorize_refunds (transid)
Success
authorize tables have been set up correctly
grade/export/ods plugin needs upgrading
ods tables have been set up correctly
grade/export/txt plugin needs upgrading
txt tables have been set up correctly
grade/export/xls plugin needs upgrading
xls tables have been set up correctly
grade/export/xml plugin needs upgrading
xml tables have been set up correctly
grade/import/csv plugin needs upgrading
csv tables have been set up correctly
grade/import/xml plugin needs upgrading
xml tables have been set up correctly
grade/report/grader plugin needs upgrading
grader tables have been set up correctly
grade/report/outcomes plugin needs upgrading
outcomes tables have been set up correctly
grade/report/overview plugin needs upgrading
overview tables have been set up correctly
grade/report/user plugin needs upgrading
user tables have been set up correctly
course/report/log plugin needs upgrading
log tables have been set up correctly
course/report/outline plugin needs upgrading
outline tables have been set up correctly
course/report/participation plugin needs upgrading
participation tables have been set up correctly
course/report/stats plugin needs upgrading
stats tables have been set up correctly