Problem with migrating to 3.0 (database error when upgrading)
Hello,
When i try to migrate the database to 3.0 (from 2.3) i get Failed Operations failed: 51 SQL queries. Display details, and when i continue the wiki just dont work (tells me to re run the installer)
Here is my log.
- 2008-09-16 lphuberdeau
CREATE TABLE tiki_webservice (
service VARCHAR(25) NOT NULL PRIMARY KEY,
url VARCHAR(250),
schema_version VARCHAR(5),
schema_documentation VARCHAR(250)
) ENGINE=MyISAM
Table 'tiki_webservice' already exists
CREATE TABLE tiki_webservice_template (
service VARCHAR(25) NOT NULL,
template VARCHAR(25) NOT NULL,
engine VARCHAR(15) NOT NULL,
output VARCHAR(15) NOT NULL,
content TEXT NOT NULL,
last_modif INT,
PRIMARY KEY( service, template )
) ENGINE=MyISAM
Table 'tiki_webservice_template' already exists
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20080916_webservice_registry_t' for key 1
ALTER table tiki_calendars ADD COLUMN customstatus enum('n','y') NOT NULL default 'y'
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_calendars'
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20080922_calendar_customstatus' for key 1
- 2008-10-06 nyloth
ALTER TABLE tiki_comments ADD COLUMN `approved` char(1) default 'y' NOT NULL
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_comments'
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20081006_comments_moderation_t' for key 1
ALTER TABLE tiki_pages_translation_bits MODIFY COLUMN flags SET('critical') NULL
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_pages_translation_bits'
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20081008_bit_flags_nullable_ti' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20081102_application_menu_stru' for key 1
- 2008-11-05 rook1666
ALTER TABLE tiki_calendar_items ADD COLUMN allday tinyint(1) NOT NULL default '0'
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_calendar_items'
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20081105_calendar_items_allday' for key 1
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_tracker_view_comments', 'Can view tracker items comments', 'basic', 'trackers')
Duplicate entry 'tiki_p_tracker_view_comments' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20081112_tiki_p_tracker_view_c' for key 1
- sylvieg
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_export_tracker', 'Can export tracker items', 'registered', 'trackers')
Duplicate entry 'tiki_p_export_tracker' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20081119_tiki_p_export_tracker' for key 1
- 2008-11-20 JohannesMoser
ALTER TABLE `tiki_polls` ADD `anonym` ENUM( 'a', 'u', 'i', 'c' ) NOT NULL DEFAULT 'u'
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_polls'
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20081120_tiki_poll_structures_' for key 1
- bbenamran
- Create recurrence table on calendar items model, adding rules of recurrence
CREATE TABLE tiki_calendar_recurrence (
recurrenceId int(14) NOT NULL auto_increment,
calendarId int(14) NOT NULL default '0',
start int(4) NOT NULL default '0',
end int(4) NOT NULL default '2359',
allday tinyint(1) NOT NULL default '0',
locationId int(14) default NULL,
categoryId int(14) default NULL,
nlId int(12) NOT NULL default '0',
priority enum('1','2','3','4','5','6','7','8','9') NOT NULL default '1',
status enum('0','1','2') NOT NULL default '0',
url varchar(255) default NULL,
lang char(16) NOT NULL default 'en',
name varchar(255) NOT NULL default '',
description blob,
weekly tinyint(1) default '0',
weekday tinyint(1),
monthly tinyint(1) default '0',
dayOfMonth int(2),
yearly tinyint(1) default '0',
dateOfYear int(4),
nbRecurrences int(8),
startPeriod int(14),
endPeriod int(14),
user varchar(200) default '',
created int(14) NOT NULL default '0',
lastmodif int(14) NOT NULL default '0',
PRIMARY KEY (recurrenceId),
KEY calendarId (calendarId)
) ENGINE=MyISAM AUTO_INCREMENT=1
Table 'tiki_calendar_recurrence' already exists
- Add reference to recurrence table in calendar items table
ALTER TABLE `tiki_calendar_items`
ADD recurrenceId int(14)
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_calendar_items'
ALTER TABLE tiki_calendar_items
ADD CONSTRAINT fk_calitems_recurrence
FOREIGN KEY (recurrenceId)
REFERENCES tiki_calendar_recurrence(recurrenceId)
ON UPDATE CASCADE
ON DELETE SET NULL
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_calendar_items'
- Has a recurrent event been manually changed ?
ALTER TABLE `tiki_calendar_items`
ADD changed tinyint(1) DEFAULT '0';
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_calendar_items'
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20081127_calendar_recurrence_t' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20081130_tiki_users_permission' for key 1
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_view_backlinks', 'Can view page backlinks', 'basic', 'wiki')
Duplicate entry 'tiki_p_view_backlinks' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20081212_tiki_p_view_backlinks' for key 1
ALTER TABLE `tiki_comments` ADD COLUMN `locked` char(1) NOT NULL default 'n'
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_comments'
ALTER TABLE `tiki_objects` ADD COLUMN `comments_locked` char(1) NOT NULL default 'n'
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_objects'
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`) VALUES ('tiki_p_forum_lock', 'Can lock forums and threads', 'editors', 'forums')
Duplicate entry 'tiki_p_forum_lock' for key 1
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`) VALUES ('tiki_p_lock_comments', 'Can lock comments', 'editors', 'comments')
Duplicate entry 'tiki_p_lock_comments' for key 1
UPDATE `tiki_comments` SET `locked` = 'y' WHERE `type` = 'l'
Unknown column 'locked' in 'field list'
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20090205_forum_and_comments_lo' for key 1
- sylvieg
update users_permissions set permName='tiki_p_view_backlink' where permName='tiki_p_view_backlinks'
Duplicate entry 'tiki_p_view_backlink' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20090304_tiki_p_view_backlink_' for key 1
- sylvieg
ALTER TABLE `tiki_menu_options` CHANGE `section` `section` text default NULL
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_menu_options'
ALTER TABLE `tiki_menu_options` CHANGE `perm` `perm` text default NULL
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_menu_options'
ALTER TABLE `tiki_menu_options` CHANGE `groupname` `groupname` text default NULL;
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_menu_options'
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20090306_text_for_menu_options' for key 1
- sylvieg
insert into `tiki_preferences` (name, value) values('feature_search_show_object_filter', 'y')
Duplicate entry 'feature_search_show_object_filter' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20090310_feature_search_show_o' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20090311_remove_mod_menu_appli' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20090330_quicktags_renames_tik' for key 1
- nyloth
ALTER TABLE `tiki_newsletter_subscriptions` ADD COLUMN `included` char(1) NOT NULL default 'n'
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_newsletter_subscriptions'
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20090401_newsletters_included_' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20090401_replace_shoutjax_with' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20090401_replace_switch_lang2_' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20090416_quicktags_kil_email_t' for key 1
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20090416_quicktags_plugin_help' for key 1
ALTER TABLE `tiki_file_galleries` ADD COLUMN `show_slideshow` char(1) default NULL
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_file_galleries'
ALTER TABLE `tiki_file_galleries` ADD COLUMN `default_view` varchar(20) default NULL
ALTER command denied to user 'thorworks'@'localhost' for table 'tiki_file_galleries'
INSERT INTO tiki_schema (patch_name, install_date) VALUES(?, NOW())
Duplicate entry '20090427_filegal_optionalize_t' for key 1