upgrade problem from 1.5 to 1.7

upgrade problem from 1.5 to 1.7

by I chung -
Number of replies: 0

An 19 errors occur during upgrade, any solution for the following?

This script generated 19 warnings - Scroll to the first warning

quiz module needs upgrading


(mysql): CREATE TABLE `mdl_quiz_essay` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `answer` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `question` (`question`) ) TYPE=MyISAM COMMENT='Options for essay questions'  


Success



(mysql): CREATE TABLE `mdl_quiz_essay_states` ( `id` int(10) unsigned NOT NULL auto_increment, `stateid` int(10) unsigned NOT NULL default '0', `graded` tinyint(4) unsigned NOT NULL default '0', `fraction` varchar(10) NOT NULL default '0.0', `response` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='essay question type specific state information'  


Success



(mysql): ALTER TABLE mdl_quiz_attempts ADD uniqueid INTEGER(10) unsigned DEFAULT '0' not null AFTER `id`  


1060: Duplicate column name 'uniqueid'

                          



(mysql): SELECT max(id)+1 AS nextid FROM mdl_quiz_attempts LIMIT 1  



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



(mysql): UPDATE mdl_config SET value = '1' WHERE name = 'attemptuniqueid'  



(mysql): ALTER TABLE mdl_quiz ADD delay1 INTEGER(10) unsigned DEFAULT '0' not null AFTER `popup`  


1060: Duplicate column name 'delay1'

                          



(mysql): ALTER TABLE mdl_quiz ADD delay2 INTEGER(10) unsigned DEFAULT '0' not null AFTER `delay1`  


1060: Duplicate column name 'delay2'

                          



(mysql): ALTER TABLE mdl_quiz_match ADD shuffleanswers tinyint unsigned DEFAULT '1' not null AFTER `subquestions`  


1146: Table 'ic_le4r2.mdl_quiz_match' doesn't exist

                          



(mysql): ALTER TABLE mdl_quiz_multichoice ADD shuffleanswers tinyint unsigned DEFAULT '1' not null AFTER `single`  


1146: Table 'ic_le4r2.mdl_quiz_multichoice' doesn't exist

                          



(mysql): ALTER TABLE mdl_quiz_randomsamatch ADD shuffleanswers tinyint unsigned DEFAULT '1' not null AFTER `choose`  


1146: Table 'ic_le4r2.mdl_quiz_randomsamatch' doesn't exist

                          



(mysql): ALTER TABLE mdl_quiz_question_versions ADD originalquestion int unsigned DEFAULT '0' not null AFTER `newquestion`  


1060: Duplicate column name 'originalquestion'

                          



(mysql): ALTER TABLE mdl_quiz_attempts ADD UNIQUE INDEX uniqueid (uniqueid)  


1061: Duplicate key name 'uniqueid'

                          



(mysql): ALTER TABLE mdl_quiz_match_sub ADD code int unsigned DEFAULT '0' not null AFTER `id`  


1146: Table 'ic_le4r2.mdl_quiz_match_sub' doesn't exist

                          



(mysql): ALTER TABLE mdl_quiz_multianswers CHANGE sequence sequence TEXT DEFAULT '' not null AFTER `question`  


1064: You have an error in your SQL syntax near 'AFTER `question`' at line 1

                          



(mysql): UPDATE mdl_quiz_attempts SET sumgrades = '0' WHERE sumgrades = ''  



(mysql): ALTER TABLE mdl_quiz_attempts CHANGE sumgrades sumgrades float DEFAULT '0' not null  


Success



(mysql): UPDATE mdl_quiz_answers SET fraction = '0' WHERE fraction = ''  


1146: Table 'ic_le4r2.mdl_quiz_answers' doesn't exist

                  

(mysql): ALTER TABLE mdl_quiz_answers CHANGE fraction fraction float DEFAULT '0' not null  


1146: Table 'ic_le4r2.mdl_quiz_answers' doesn't exist

                          



(mysql): UPDATE mdl_quiz_essay_states SET fraction = '0' WHERE fraction = ''  



(mysql): ALTER TABLE mdl_quiz_essay_states CHANGE fraction fraction float DEFAULT '0' not null  


Success



(mysql): UPDATE mdl_quiz_states SET grade = '0' WHERE grade = ''  


1146: Table 'ic_le4r2.mdl_quiz_states' doesn't exist

                  

(mysql): ALTER TABLE mdl_quiz_states CHANGE grade grade float DEFAULT '0' not null  


1146: Table 'ic_le4r2.mdl_quiz_states' doesn't exist

                          



(mysql): UPDATE mdl_quiz_states SET raw_grade = '0' WHERE raw_grade = ''  


1146: Table 'ic_le4r2.mdl_quiz_states' doesn't exist

                  

(mysql): ALTER TABLE mdl_quiz_states CHANGE raw_grade raw_grade float DEFAULT '0' not null  


1146: Table 'ic_le4r2.mdl_quiz_states' doesn't exist

                          



(mysql): UPDATE mdl_quiz_states SET penalty = '0' WHERE penalty = ''  


1146: Table 'ic_le4r2.mdl_quiz_states' doesn't exist

                  

(mysql): ALTER TABLE mdl_quiz_states CHANGE penalty penalty float DEFAULT '0' not null  


1146: Table 'ic_le4r2.mdl_quiz_states' doesn't exist

                          



(mysql): UPDATE mdl_question_sessions SET sumpenalty = '0' WHERE sumpenalty = ''  



(mysql): ALTER TABLE mdl_question_sessions CHANGE sumpenalty sumpenalty float DEFAULT '0' not null  


Success



(mysql): ALTER TABLE mdl_question CHANGE qtype qtype VARCHAR(20) DEFAULT '' not null  


Success



(mysql): UPDATE mdl_question SET qtype = 'shortanswer' WHERE qtype = '1'  



(mysql): UPDATE mdl_question SET qtype = 'truefalse' WHERE qtype = '2'  



(mysql): UPDATE mdl_question SET qtype = 'multichoice' WHERE qtype = '3'  



(mysql): UPDATE mdl_question SET qtype = 'random' WHERE qtype = '4'  



(mysql): UPDATE mdl_question SET qtype = 'match' WHERE qtype = '5'  



(mysql): UPDATE mdl_question SET qtype = 'randomsamatch' WHERE qtype = '6'  



(mysql): UPDATE mdl_question SET qtype = 'description' WHERE qtype = '7'  



(mysql): UPDATE mdl_question SET qtype = 'numerical' WHERE qtype = '8'  



(mysql): UPDATE mdl_question SET qtype = 'multianswer' WHERE qtype = '9'  



(mysql): UPDATE mdl_question SET qtype = 'calculated' WHERE qtype = '10'  



(mysql): UPDATE mdl_question SET qtype = 'rqp' WHERE qtype = '11'  



(mysql): UPDATE mdl_question SET qtype = 'essay' WHERE qtype = '12'  



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



(mysql): UPDATE mdl_config SET value = '2006032100' WHERE name = 'qtype_calculated_version'  



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



(mysql): UPDATE mdl_config SET value = '2006032100' WHERE name = 'qtype_essay_version'  



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



(mysql): UPDATE mdl_config SET value = '2006032100' WHERE name = 'qtype_match_version'  



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



(mysql): UPDATE mdl_config SET value = '2006032100' WHERE name = 'qtype_multianswer_version'  



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



(mysql): UPDATE mdl_config SET value = '2006032100' WHERE name = 'qtype_multichoice_version'  



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



(mysql): UPDATE mdl_config SET value = '2006032100' WHERE name = 'qtype_numerical_version'  



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



(mysql): UPDATE mdl_config SET value = '2006032100' WHERE name = 'qtype_randomsamatch_version'  



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



(mysql): UPDATE mdl_config SET value = '2006032100' WHERE name = 'qtype_rqp_version'  



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



(mysql): UPDATE mdl_config SET value = '2006032100' WHERE name = 'qtype_shortanswer_version'  



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



(mysql): UPDATE mdl_config SET value = '2006032100' WHERE name = 'qtype_truefalse_version'  



(mysql): ALTER TABLE mdl_question_sessions ADD comment TEXT DEFAULT '' not null AFTER `sumpenalty`  


1060: Duplicate column name 'comment'

                          



(mysql): UPDATE mdl_question SET parent = id WHERE qtype ='random'  


Success



(mysql): INSERT INTO mdl_log_display (module, action, mtable, field) VALUES ('quiz', 'continue attempt', 'quiz', 'name')  


1062: Duplicate entry 'quiz-continue attempt' for key 2

                          



(mysql): ALTER TABLE mdl_question CHANGE version version VARCHAR(255) DEFAULT '0' not null  


Success



(mysql): SHOW TABLES  



(mysql): SHOW COLUMNS FROM `mdl_question_randomsamatch`  



(mysql): UPDATE mdl_question_sessions SET newgraded = newest where newgraded = '0'  


Success



(mysql): SHOW TABLES  



(mysql): SELECT a.uniqueid, es.response AS essaycomment, es.graded AS isgraded, qs.id AS stateid, qs.question AS questionid FROM mdl_question_states as qs, mdl_question_essay_states es, mdl_quiz_attempts a WHERE es.stateid = qs.id AND a.uniqueid = qs.attempt  



(mysql): DROP TABLE mdl_question_essay_states  


Success



(mysql): DROP TABLE mdl_question_essay  


Success



(mysql): ALTER TABLE mdl_question ADD commentarytext TEXT DEFAULT '' not null AFTER `image`  


1060: Duplicate column name 'commentarytext'

                          


Scroll to previous warningUpgrade function xmldb_quiz_upgrade was not available in quiz: /var/www/html/ucway/e-learn/mod/quiz/db/upgrade.phpScroll to next warning


Scroll to previous warningUpgrading quiz from 2005060302 to 2006091901 FAILED!Scroll to continue button
Average of ratings: -