Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Blocker
-
Resolution: Cannot Reproduce
-
Affects Version/s: 4.0 RC4
-
Fix Version/s: 4.0.0
-
Component/s: Install Scripts
-
Labels:None
-
Environment:Sourcefabric.org backup
-
Originating Party:QA
-
OS:Ubuntu 10.04
-
Browser:Firefox
Description
Error: While upgrading the database: tables.sql (3.5.x) errors on: ALTER TABLE `liveuser_groups` ADD `role_id` int(10) DEFAULT NULL Table 'newscoop.liveuser_groups' doesn't exist ALTER TABLE `liveuser_users` ADD `role_id` int(10) DEFAULT NULL Table 'newscoop.liveuser_users' doesn't exist ALTER TABLE `liveuser_users` ADD `author_id` INT( 10 ) UNSIGNED NULL, ADD INDEX ( `author_id` ) Table 'newscoop.liveuser_users' doesn't exist ALTER TABLE `liveuser_groups` CHANGE `group_id` `group_id` int(11) NOT NULL AUTO_INCREMENT Table 'newscoop.liveuser_groups' doesn't exist ALTER TABLE `Sections` ADD COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST, DROP PRIMARY KEY, ADD PRIMARY KEY USING BTREE(`id`) Table 'newscoop.Sections' doesn't exist ALTER TABLE `Sections` ADD UNIQUE INDEX `section_unique`(`IdPublication`, `NrIssue`, `IdLanguage`, `Number`) Table 'newscoop.Sections' doesn't exist ALTER TABLE `Sections` ADD COLUMN `fk_issue_id` INTEGER UNSIGNED NOT NULL AFTER `id` Table 'newscoop.Sections' doesn't exist ALTER TABLE `SubsSections` MODIFY COLUMN `IdLanguage` INTEGER UNSIGNED DEFAULT NULL, ADD COLUMN `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT FIRST, DROP PRIMARY KEY, ADD PRIMARY KEY (`id`), ADD UNIQUE (`IdSubscription`, `SectionNumber`, `IdLanguage`) Table 'newscoop.SubsSections' doesn't exist ALTER TABLE `liveuser_users` ADD `last_name` varchar(80) DEFAULT NULL Table 'newscoop.liveuser_users' doesn't exist ALTER TABLE `liveuser_users` ADD `status` tinyint(1) NOT NULL DEFAULT '0' Table 'newscoop.liveuser_users' doesn't exist ALTER TABLE `liveuser_users` ADD `is_admin` boolean NOT NULL DEFAULT '0' Table 'newscoop.liveuser_users' doesn't exist ALTER TABLE `liveuser_users` ADD `is_public` boolean NOT NULL DEFAULT '0' Table 'newscoop.liveuser_users' doesn't exist ALTER TABLE `liveuser_users` ADD `points` int(10) DEFAULT '0' Table 'newscoop.liveuser_users' doesn't exist ALTER TABLE `liveuser_users` CHANGE `time_created` `time_created` datetime NOT NULL Table 'newscoop.liveuser_users' doesn't exist ALTER TABLE `liveuser_users` CHANGE `time_updated` `time_updated` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP Table 'newscoop.liveuser_users' doesn't exist ALTER TABLE `liveuser_users` ADD `image` varchar(255) DEFAULT NULL Table 'newscoop.liveuser_users' doesn't exist ALTER TABLE `liveuser_users` ADD `subscriber` int(10) DEFAULT NULL Table 'newscoop.liveuser_users' doesn't exist UPDATE `liveuser_users` SET `status` = 1, `is_admin` = 1, `is_public` = 1 Table 'newscoop.liveuser_users' doesn't exist