upgrade from 1.0.4 to 1.0.6.3 not easy like the other upgrades.

upgrade from 1.0.4 to 1.0.6.3 not easy like the other upgrades.

by e cowan -
Number of replies: 1
(mysql): CREATE TABLE `quiz` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `intro` text NOT NULL, `timeopen` int(10) unsigned NOT NULL default '0', `timeclose` int(10) unsigned NOT NULL default '0', `attempts` smallint(6) NOT NULL default '0', `feedback` tinyint(4) NOT NULL default '0', `correctanswers` tinyint(4) NOT NULL default '1', `grademethod` tinyint(4) NOT NULL default '1', `questions` text NOT NULL, `sumgrades` int(10) NOT NULL default '0', `grade` int(10) NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM COMMENT='Main information about each quiz' 1: Can't create/write to file './moodle/quiz.frm' (Errcode: 13)

Error
(mysql): CREATE TABLE `quiz_answers` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `answer` varchar(255) NOT NULL default '', `fraction` varchar(10) NOT NULL default '0.0', `feedback` text NOT NULL, PRIMARY KEY (`id`)) TYPE=MyISAM COMMENT='Answers, with a fractional grade (0-1) and feedback' 1: Can't create/write to file './moodle/quiz_answers.frm' (Errcode: 13)

Error
(mysql): CREATE TABLE `quiz_attempts` ( `id` int(10) unsigned NOT NULL auto_increment, `quiz` int(10) unsigned NOT NULL default '0', `user` int(10) unsigned NOT NULL default '0', `attempt` smallint(6) NOT NULL default '0', `sumgrades` varchar(10) NOT NULL default '0.0', `timestart` int(10) unsigned NOT NULL default '0', `timefinish` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM COMMENT='Stores various attempts on a quiz' 1: Can't create/write to file './moodle/quiz_attempts.frm' (Errcode: 13)

Error
(mysql): CREATE TABLE `quiz_categories` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `info` text NOT NULL, `publish` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM COMMENT='Categories are for grouping questions' 1: Can't create/write to file './moodle/quiz_categories.frm' (Errcode: 13)

Error
(mysql): CREATE TABLE `quiz_grades` ( `id` int(10) unsigned NOT NULL auto_increment, `quiz` int(10) unsigned NOT NULL default '0', `user` int(10) unsigned NOT NULL default '0', `grade` varchar(10) NOT NULL default '0.0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM COMMENT='Final quiz grade (may be best of several attempts)' 1: Can't create/write to file './moodle/quiz_grades.frm' (Errcode: 13)

Error
(mysql): CREATE TABLE `quiz_multichoice` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `layout` tinyint(4) NOT NULL default '0', `answers` varchar(255) NOT NULL default '', `single` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), KEY `question` (`question`)) TYPE=MyISAM COMMENT='Options for multiple choice questions' 1: Can't create/write to file './moodle/quiz_multichoice.frm' (Errcode: 13)

Error
(mysql): CREATE TABLE `quiz_question_grades` ( `id` int(10) unsigned NOT NULL auto_increment, `quiz` int(10) unsigned NOT NULL default '0', `question` int(10) unsigned NOT NULL default '0', `grade` smallint(6) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM COMMENT='The grade for a question in a quiz' 1: Can't create/write to file './moodle/quiz_question_grades.frm' (Errcode: 13)

Error
(mysql): CREATE TABLE `quiz_questions` ( `id` int(10) NOT NULL auto_increment, `category` int(10) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `questiontext` text NOT NULL, `image` varchar(255) NOT NULL default '', `type` smallint(6) NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM COMMENT='The quiz questions themselves' 1: Can't create/write to file './moodle/quiz_questions.frm' (Errcode: 13)

Error
(mysql): CREATE TABLE `quiz_responses` ( `id` int(10) unsigned NOT NULL auto_increment, `attempt` int(10) unsigned NOT NULL default '0', `question` int(10) unsigned NOT NULL default '0', `answer` varchar(255) NOT NULL default '', `grade` varchar(10) NOT NULL default '0.0', PRIMARY KEY (`id`)) TYPE=MyISAM COMMENT='Stores user responses to a quiz, and percentage grades' 1: Can't create/write to file './moodle/quiz_responses.frm' (Errcode: 13)

Error
(mysql): CREATE TABLE `quiz_shortanswer` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `answers` varchar(255) NOT NULL default '', `usecase` tinyint(2) NOT NULL default '0', PRIMARY KEY (`id`), KEY `question` (`question`)) TYPE=MyISAM COMMENT='Options for short answer questions' 1: Can't create/write to file './moodle/quiz_shortanswer.frm' (Errcode: 13)

Error
(mysql): CREATE TABLE `quiz_truefalse` ( `id` int(10) unsigned NOT NULL auto_increment, `question` int(10) unsigned NOT NULL default '0', `true` int(10) unsigned NOT NULL default '0', `false` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `question` (`question`)) TYPE=MyISAM COMMENT='Options for True-False questions' 1: Can't create/write to file './moodle/quiz_truefalse.frm' (Errcode: 13)

Error
(mysql): INSERT INTO log_display VALUES ('quiz', 'view', 'quiz', 'name')

Success
(mysql): INSERT INTO log_display VALUES ('quiz', 'report', 'quiz', 'name')

Success
(mysql): INSERT INTO log_display VALUES ('quiz', 'attempt', 'quiz', 'name')

Success
(mysql): INSERT INTO log_display VALUES ('quiz', 'submit', 'quiz', 'name')

Success

quiz tables could NOT be set up successfully!

Continue
Average of ratings: -