MantisBT - ATutor
View Issue Details
0002914ATutorUpgradingpublic2007-02-13 04:222007-02-13 09:16
greg 
user2 
normalmajoralways
closedfixed 
 
1.5.4 
SVN
0002914: upgrade from 1.5.2 to 1.5.3.3pl1 fails
The creation of the assignments table when upgrading from 1.5.2 fails. When comparing the upgrade to the schema, the table definitions differ. When the schema verdsion of the the table replace the upgrade version, upgrade proceeds as it should.
The upgrade was to the LDRC server

upgrade
CREATE TABLE `assignments` (
  `assignment_id` MEDIUMINT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  `course_id` MEDIUMINT UNSIGNED NOT NULL default '',
  `title` VARCHAR(60) NOT NULL default '',
  `assign_to` MEDIUMINT UNSIGNED DEFAULT 0,
  `date_due` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_cutoff` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `multi_submit` TINYINT DEFAULT '0',
  PRIMARY KEY (`assignment_id`),
  INDEX (`course_id`)
) TYPE = MYISAM;


schema

CREATE TABLE `assignments` (
    `assignment_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `course_id` MEDIUMINT UNSIGNED NOT NULL default 0,
    `title` VARCHAR(60) NOT NULL default '',
    `assign_to` MEDIUMINT UNSIGNED default 0,
    `date_due` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    `date_cutoff` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    `multi_submit` TINYINT DEFAULT '0',
    PRIMARY KEY (`assignment_id`),
    INDEX (`course_id`)
) TYPE = MYISAM;

No tags attached.
Issue History
2007-02-13 04:22gregNew Issue
2007-02-13 04:22gregAffects version => SVN
2007-02-13 07:26user2Statusnew => resolved
2007-02-13 07:26user2Fixed in Version => 1.5.4
2007-02-13 07:26user2Resolutionopen => fixed
2007-02-13 07:26user2Assigned To => user2
2007-02-13 09:16user2Statusresolved => closed

There are no notes attached to this issue.