MantisBT

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0002914ATutorUpgradingpublic2007-02-13 04:222007-02-13 09:16
Reportergreg 
Assigned Touser2 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version1.5.4 
Summary0002914: upgrade from 1.5.2 to 1.5.3.3pl1 fails
DescriptionThe 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.
Additional InformationThe 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;

TagsNo tags attached.
Affects versionSVN
SVN Revision#
Attached Files

- Relationships

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2007-02-13 04:22 greg New Issue
2007-02-13 04:22 greg Affects version => SVN
2007-02-13 07:26 user2 Status new => resolved
2007-02-13 07:26 user2 Fixed in Version => 1.5.4
2007-02-13 07:26 user2 Resolution open => fixed
2007-02-13 07:26 user2 Assigned To => user2
2007-02-13 09:16 user2 Status resolved => closed


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker