API tools faq
paste
Torsten

DB Versions Problem Tiki 6.1

Torsten
May 25th, 2011
383
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 59.63 KB | None | 0 0
raw download clone embed print report
  1. Upgrade complete.
  2.  
  3. Your database has been configured and Tiki is ready to run! You can now log in into Tiki as user admin and start configuring the application.
  4.  
  5. Success Upgrade operations executed successfully: 5524 SQL queries.
  6.  
  7. Failed Operations failed: 283 SQL queries. Display details.
  8.  
  9.  
  10. During an upgrade, it is normal to have SQL failures resulting with Table already exists messages.
  11.  
  12. 20060116_showlastDownLoad_tiki
  13. # This file says 2006 but this is a mistake. Since renaming a DB schema modification file is more work (because some have already used it), it stayed as is. Should have no impact but a note is added here in case you wondered. http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki?view=revision&revision=24792 ALTER TABLE `tiki_file_galleries` ADD COLUMN `show_lastDownload` char(1) default NULL AFTER `show_hits` Duplicate column name 'show_lastDownload'
  14.  
  15. 20080227_invite_tiki
  16. #sylvieg INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_invite', 'Can invite user in groups', 'editors', 'tiki'); Duplicate entry 'tiki_p_invite' for key 'PRIMARY'
  17.  
  18. 20080809_semlinks_tiki
  19. #2008-08-22 lphuberdeau ALTER TABLE tiki_links ADD COLUMN reltype VARCHAR(50) Duplicate column name 'reltype' CREATE TABLE tiki_semantic_tokens ( token VARCHAR(15) PRIMARY KEY, label VARCHAR(25) NOT NULL, invert_token VARCHAR(15) ) ENGINE=MyISAM Table 'tiki_semantic_tokens' already exists
  20.  
  21. 20080829_pagealiasdata_tiki
  22. #2008-08-29 lphuberdeau INSERT INTO tiki_semantic_tokens (token, label) VALUES('alias', 'Page Alias') Duplicate entry 'alias' for key 'PRIMARY'
  23.  
  24. 20080829_pluginvalidation_tiki
  25. #2008-08-29 lphuberdeau INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_plugin_viewdetail', 'Can view unapproved plugin details', 'editors', 'wiki') Duplicate entry 'tiki_p_plugin_viewdetail' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_plugin_preview', 'Can execute unapproved plugin', 'editors', 'wiki') Duplicate entry 'tiki_p_plugin_preview' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_plugin_approve', 'Can approve plugin execution', 'editors', 'wiki') Duplicate entry 'tiki_p_plugin_approve' for key 'PRIMARY'
  26.  
  27. 20080902_trackerparsedesc_tiki
  28. #2008-09-02 sylvieg ALTER TABLE tiki_tracker_fields ADD COLUMN `descriptionIsParsed` char(1) default 'n' AFTER `editableBy` Duplicate column name 'descriptionIsParsed'
  29.  
  30. 20080905_feature_tip_tiki
  31. #2008-09-05 bitey ALTER TABLE tiki_feature ADD COLUMN `tip` text NULL Duplicate column name 'tip'
  32.  
  33. 20080916_webservice_registry_tiki
  34. #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
  35.  
  36. 20080922_calendar_customstatus_tiki
  37. ALTER table tiki_calendars ADD COLUMN customstatus enum('n','y') NOT NULL default 'y' Duplicate column name 'customstatus'
  38.  
  39. 20080924_webmail_tiki
  40. #2008-09-16 MatWho ALTER TABLE tiki_user_mail_accounts ADD COLUMN `flagsPublic` char(1) default 'n' AFTER `smtpPort` Duplicate column name 'flagsPublic' ALTER TABLE tiki_user_mail_accounts ADD COLUMN `autoRefresh` int(4) NOT NULL default 0 AFTER `flagsPublic` Duplicate column name 'autoRefresh' ALTER TABLE tiki_webmail_messages ADD COLUMN `flaggedMsg` varchar(50) default '' AFTER `isFlagged` Duplicate column name 'flaggedMsg' #2008-09-27 MatWho INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_use_group_webmail', 'Can use group webmail', 'registered', 'webmail') Duplicate entry 'tiki_p_use_group_webmail' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_admin_group_webmail', 'Can administrate group webmail accounts', 'registered', 'webmail') Duplicate entry 'tiki_p_admin_group_webmail' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_use_personal_webmail', 'Can use personal webmail accounts', 'registered', 'webmail') Duplicate entry 'tiki_p_use_personal_webmail' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_admin_personal_webmail', 'Can administrate personal webmail accounts', 'registered', 'webmail') Duplicate entry 'tiki_p_admin_personal_webmail' for key 'PRIMARY'
  41.  
  42. 20080926_bannerindex_tiki
  43. #2008-09-26 sylvieg ALTER TABLE tiki_banners ADD INDEX ban1 (zone,`useDates`,impressions,`maxImpressions`,`hourFrom`,`hourTo`,`fromDate`,`toDate`,mon,tue,wed,thu,fri,sat,sun); Duplicate key name 'ban1'
  44.  
  45. 20081004_mindmap_menu_tiki
  46. # 2008-10-04 lphuberdeau INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (197,42,'o','Mind Map','tiki-mindmap.php',255,'feature_wiki_mindmap','tiki_p_view','',0) Duplicate entry '197' for key 'PRIMARY'
  47.  
  48. 20081006_comments_moderation_tiki
  49. # 2008-10-06 nyloth ALTER TABLE tiki_comments ADD COLUMN `approved` char(1) default 'y' NOT NULL Duplicate column name 'approved'
  50.  
  51. 20081010_filter_perms_tiki
  52. # 2008-10-10 lphuberdeau ALTER TABLE users_permissions ADD COLUMN feature_check VARCHAR(50) NULL Duplicate column name 'feature_check'
  53.  
  54. 20081014_trust_input_perm_tiki
  55. INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_trust_input', 'Trust all user inputs including plugins (no security checks)', 'admin', 'tiki') Duplicate entry 'tiki_p_trust_input' for key 'PRIMARY'
  56.  
  57. 20081027_groupalert_tiki
  58. #gillesm 2008-10-27 #2008_10_26 GillesM CREATE TABLE tiki_groupalert ( `groupName` varchar(255) NOT NULL default '', `objectType` varchar( 20 ) NOT NULL default '', `objectId` varchar(10) NOT NULL default '', `displayEachuser` char( 1 ) default NULL , PRIMARY KEY ( `groupName`,`objectType`,`objectId`) ) ENGINE=MyISAM Table 'tiki_groupalert' already exists
  59.  
  60. 20081027_surveys_tiki
  61. ALTER TABLE `tiki_survey_questions` ADD COLUMN `mandatory` char(1) NOT NULL default 'n' Duplicate column name 'mandatory' ALTER TABLE `tiki_survey_questions` ADD COLUMN `max_answers` int(5) NOT NULL default 0 Duplicate column name 'max_answers' ALTER TABLE `tiki_survey_questions` ADD COLUMN `min_answers` int(5) NOT NULL default 0 Duplicate column name 'min_answers'
  62.  
  63. 20081027_wysiwyg_history_tiki
  64. #2008-10-27 lphuberdeau ALTER TABLE tiki_history ADD COLUMN is_html TINYINT(1) NOT NULL DEFAULT 0 Duplicate column name 'is_html'
  65.  
  66. 20081029_tracker_index_tiki
  67. #sylvieg 2008-10-29 ALTER TABLE `tiki_tracker_items` ADD index `trackerId` (`trackerId`) Duplicate key name 'trackerId' ALTER TABLE `tiki_tracker_fields` ADD index `trackerId` (`trackerId`) Duplicate key name 'trackerId' ALTER TABLE `tiki_tracker_item_attachments` ADD index `itemId` (`itemId`); Duplicate key name 'itemId'
  68.  
  69. 20081105_calendar_items_allday_tiki
  70. #2008-11-05 rook1666 ALTER TABLE tiki_calendar_items ADD COLUMN allday tinyint(1) NOT NULL default '0' Duplicate column name 'allday'
  71.  
  72. 20081107_menu42_tiki
  73. INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Admin','tiki-admin.php',1050,'feature_edit_templates','tiki_p_edit_templates','',0) Duplicate entry '42-Admin-tiki-admin.php-1050-feature_edit_templates-tiki_p_edit_' for key 'uniq_menu' INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Admin','tiki-admin.php',1050,'feature_view_tpl','tiki_p_edit_templates','',0) Duplicate entry '42-Admin-tiki-admin.php-1050-feature_view_tpl-tiki_p_edit_templa' for key 'uniq_menu' INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Admin','tiki-admin.php',1050,'feature_editcss','tiki_p_create_css','',0); Duplicate entry '42-Admin-tiki-admin.php-1050-feature_editcss-tiki_p_create_css-' for key 'uniq_menu'
  74.  
  75. 20081112_tiki_p_tracker_view_comments_tiki
  76. 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 'PRIMARY'
  77.  
  78. 20081114_tiki_banner_tiki
  79. #gillesm ALTER TABLE tiki_banners ADD `maxClicks` int(8) default NULL; Duplicate column name 'maxClicks'
  80.  
  81. 20081119_tiki_p_export_tracker_tiki
  82. #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 'PRIMARY'
  83.  
  84. 20081120_showCategories_tiki
  85. #2008-11-20 aproulx ALTER TABLE tiki_galleries ADD COLUMN showcategories CHAR(1) NOT NULL DEFAULT 'n'; Duplicate column name 'showcategories'
  86.  
  87. 20081127_calendar_recurrence_tiki
  88. #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) Duplicate column name 'recurrenceId' # Has a recurrent event been manually changed ? ALTER TABLE `tiki_calendar_items` ADD changed tinyint(1) DEFAULT '0'; Duplicate column name 'changed'
  89.  
  90. 20081211_newsletter_files_tiki
  91. #2008-12-11 niclone CREATE TABLE `tiki_sent_newsletters_files` ( `id` int(11) NOT NULL auto_increment, `editionId` int(11) NOT NULL, `name` varchar(256) NOT NULL, `type` varchar(64) NOT NULL, `size` int(11) NOT NULL, `filename` varchar(256) NOT NULL, PRIMARY KEY (`id`), KEY `editionId` (`editionId`) ) Table 'tiki_sent_newsletters_files' already exists
  92.  
  93. 20081214_webservice_post_tiki
  94. #2008-12-14 lphuberdeau ALTER TABLE `tiki_webservice` ADD `body` TEXT NULL AFTER `url` Duplicate column name 'body'
  95.  
  96. 20090106_group_watch_tiki
  97. #2008-01-06 lphuberdeau CREATE TABLE tiki_group_watches ( `watchId` int(12) NOT NULL auto_increment, `group` varchar(200) NOT NULL default '', event varchar(40) NOT NULL default '', object varchar(200) NOT NULL default '', title varchar(250) default NULL, type varchar(200) default NULL, url varchar(250) default NULL, KEY `watchId` (`watchId`), PRIMARY KEY (`group`(50),event,object(100)) ) ENGINE=MyISAM Table 'tiki_group_watches' already exists
  98.  
  99. 20090120_sefurl_rules_tiki
  100. #sylvieg CREATE TABLE `tiki_sefurl_regex_out` ( `id` int(11) NOT NULL auto_increment, `left` varchar(256) NOT NULL, `right` varchar(256) NULL default NULL, `type` varchar(32) NULL default NULL, `silent` char(1) NULL default 'n', `feature` varchar(256) NULL default NULL, `comment` varchar(256), `order` int(11) NULL default 0, PRIMARY KEY(`id`), UNIQUE KEY `left`(`left`(256)), INDEX `idx1` (silent, type, feature(30)) ) Table 'tiki_sefurl_regex_out' already exists
  101.  
  102. 20090129_callendar_search_tiki
  103. ALTER TABLE `tiki_calendar_items` ADD FULLTEXT `ft` ( `name` , `description` ) Duplicate key name 'ft'
  104.  
  105. 20090205_forum_and_comments_locking_tiki
  106. ALTER TABLE `tiki_comments` ADD COLUMN `locked` char(1) NOT NULL default 'n' Duplicate column name 'locked' ALTER TABLE `tiki_objects` ADD COLUMN `comments_locked` char(1) NOT NULL default 'n' Duplicate column name 'comments_locked' 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 'PRIMARY' 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 'PRIMARY'
  107.  
  108. 20090205_menus_items_icons_tiki
  109. ALTER TABLE `tiki_menus` ADD COLUMN `use_items_icons` char(1) NOT NULL DEFAULT 'n' Duplicate column name 'use_items_icons' ALTER TABLE `tiki_menu_options` ADD COLUMN `icon` varchar(200) Duplicate column name 'icon'
  110.  
  111. 20090206_poll_tiki
  112. #sylvieg ALTER TABLE tiki_polls DROP COLUMN anonym Can't DROP 'anonym'; check that column/key exists ALTER TABLE tiki_user_votings ADD COLUMN time int(14) not null Duplicate column name 'time' ALTER TABLE tiki_user_votings ADD COLUMN ip varchar(15) default NULL after user Duplicate column name 'ip' ALTER TABLE tiki_user_votings ADD KEY ip (`ip`) Duplicate key name 'ip' ALTER TABLE tiki_user_votings ADD KEY id (`id`) Duplicate key name 'id' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_view_poll_voters', 'Can view poll voters', 'basic', 'polls') Duplicate entry 'tiki_p_view_poll_voters' for key 'PRIMARY' ALTER TABLE tiki_polls ADD COLUMN `voteConsiderationSpan` int(4) default 0; Duplicate column name 'voteConsiderationSpan'
  113.  
  114. 20090211_mailnotification_tiki
  115. #2009-02-12 pkdille #Add new perm tiki_p_admin_notifications which gives the perm to manage the mail notifications (without being admin) INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_admin_notifications', 'Can admin mail notifications', 'editors', 'mail notifications') Duplicate entry 'tiki_p_admin_notifications' for key 'PRIMARY'
  116.  
  117. 20090212_forum_tiki
  118. ALTER TABLE `tiki_forums_queue` ADD tags varchar(255) default NULL Duplicate column name 'tags' ALTER TABLE `tiki_forums_queue` ADD email varchar(255) default NULL; Duplicate column name 'email'
  119.  
  120. 20090304_tiki_p_view_backlink_without_s_tiki
  121. #sylvieg update users_permissions set `permName`='tiki_p_view_backlink' where `permName`='tiki_p_view_backlinks' Duplicate entry 'tiki_p_view_backlink' for key 'PRIMARY'
  122.  
  123. 20090316_index_tiki
  124. #sylvieg alter table `tiki_actionlog` add key `lastModif`(`lastModif`) Duplicate key name 'lastModif' alter table `tiki_actionlog` add key `object`(`object`(100), `objectType`, `action`(100)) Duplicate key name 'object' alter table `tiki_wiki_attachments` add key `page` (`page`); Duplicate key name 'page'
  125.  
  126. 20090323_maxUserImpressions_banners_tiki
  127. #sylvieg alter table `tiki_banners` add column `maxUserImpressions` int(8) default -1 after `impressions`; Duplicate column name 'maxUserImpressions'
  128.  
  129. 20090330_quicktags_renames_tiki
  130. # jonnyb # rename labels to they list more sensibly UPDATE `tiki_quicktags` SET `taglabel` = ' text, bold' WHERE `tiki_quicktags`.`taglabel` = 'text, bold' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taglabel` = ' text, bold' WHERE `tiki_quicktags`.`taglabel` = 'bold' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taglabel` = ' text, italic' WHERE `tiki_quicktags`.`taglabel` = 'text, italic' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taglabel` = ' text, italic' WHERE `tiki_quicktags`.`taglabel` = 'italic' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taglabel` = ' text, underline' WHERE `tiki_quicktags`.`taglabel` = 'text, underline' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taglabel` = ' text, underline' WHERE `tiki_quicktags`.`taglabel` = 'underline' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taglabel` = ' heading1' WHERE `tiki_quicktags`.`taglabel` = 'heading1' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taglabel` = ' heading2' WHERE `tiki_quicktags`.`taglabel` = 'heading2' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taglabel` = ' heading3' WHERE `tiki_quicktags`.`taglabel` = 'heading3' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taglabel` = ' deleted' WHERE `tiki_quicktags`.`taglabel` = 'Deleted' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taglabel` = ' colored text' WHERE `tiki_quicktags`.`taglabel` = 'colored text' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taglabel` = ' horizontal rule' WHERE `tiki_quicktags`.`taglabel` = 'hr' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `tagicon` = 'pics/icons/database_gear.png' WHERE `tiki_quicktags`.`taglabel` = 'dynamic variable' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taginsert` = '||r1c1|r1c2|r1c3\nr2c1|r2c2|r2c3\nr3c1|r3c2|r3c3||' WHERE `tiki_quicktags`.`taglabel` = 'table new' Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('quote','{QUOTE(replyto= )}\ntext\n{QUOTE}\n','pics/icons/quotes.png','wiki') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('code','{CODE( caption= wrap= colors= ln= wiki= rtl= ishtml=)}\ntext\n{CODE}\n','pics/icons/page_white_code.png','wiki') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('flash','{flash movie= width= height= quality= }\n','pics/icons/page_white_actionscript.png','wiki') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('quote','{QUOTE(replyto= )}\ntext\n{QUOTE}\n','pics/icons/quotes.png','blogs') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('code','{CODE( caption= wrap= colors= ln= wiki= rtl= ishtml=)}\ntext\n{CODE}\n','pics/icons/page_white_code.png','blogs') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('flash','{flash movie= width= height= quality= }\n','pics/icons/page_white_actionscript.png','blogs') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('quote','{QUOTE(replyto= )}\ntext\n{QUOTE}\n','pics/icons/quotes.png','articles') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('code','{CODE( caption= wrap= colors= ln= wiki= rtl= ishtml=)}\ntext\n{CODE}\n','pics/icons/page_white_code.png','articles') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('flash','{flash movie= width= height= quality= }\n','pics/icons/page_white_actionscript.png','articles') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('quote','{QUOTE(replyto= )}\ntext\n{QUOTE}\n','pics/icons/quotes.png','forums') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('code','{CODE( caption= wrap= colors= ln= wiki= rtl= ishtml=)}\ntext\n{CODE}\n','pics/icons/page_white_code.png','forums') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('flash','{flash movie= width= height= quality= }\n','pics/icons/page_white_actionscript.png','forums') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('quote','{QUOTE(replyto= )}\ntext\n{QUOTE}\n','pics/icons/quotes.png','trackers') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('code','{CODE( caption= wrap= colors= ln= wiki= rtl= ishtml=)}\ntext\n{CODE}\n','pics/icons/page_white_code.png','trackers') Table 'd01019d9.tiki_quicktags' doesn't exist INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('flash','{flash movie= width= height= quality= }\n','pics/icons/page_white_actionscript.png','trackers') Table 'd01019d9.tiki_quicktags' doesn't exist
  131.  
  132. 20090401_newsletters_included_tiki
  133. #nyloth ALTER TABLE `tiki_newsletter_subscriptions` ADD COLUMN `included` char(1) NOT NULL default 'n' Duplicate column name 'included'
  134.  
  135. 20090416_plugin_security_tiki
  136. #2009-04-16 lphuberdeau CREATE TABLE tiki_plugin_security ( fingerprint VARCHAR(200) NOT NULL PRIMARY KEY, status VARCHAR(10) NOT NULL, approval_by VARCHAR(200) NULL, last_update TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, last_objectType VARCHAR(20) NOT NULL, last_objectId VARCHAR(200) NOT NULL, KEY last_object (last_objectType, last_objectId) ) Table 'tiki_plugin_security' already exists
  137.  
  138. 20090416_quicktags_kil_email_tiki
  139. DELETE FROM `tiki_quicktags` WHERE `tiki_quicktags`.`taglabel` = 'Email Address' Table 'd01019d9.tiki_quicktags' doesn't exist
  140.  
  141. 20090416_quicktags_plugin_helpers_tiki
  142. UPDATE `tiki_quicktags` SET `taginsert` = 'popup_plugin_form("quote")' WHERE `tiki_quicktags`.`taglabel` = 'quote' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taginsert` = 'popup_plugin_form("code")' WHERE `tiki_quicktags`.`taglabel` = 'code' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taginsert` = 'popup_plugin_form("flash")' WHERE `tiki_quicktags`.`taglabel` = 'flash' Table 'd01019d9.tiki_quicktags' doesn't exist UPDATE `tiki_quicktags` SET `taginsert` = 'popup_plugin_form("img")' WHERE `tiki_quicktags`.`taglabel` = 'image' Table 'd01019d9.tiki_quicktags' doesn't exist
  143.  
  144. 20090427_filegal_optionalize_tiki
  145. ALTER TABLE `tiki_file_galleries` ADD COLUMN `show_slideshow` char(1) default NULL Duplicate column name 'show_slideshow' ALTER TABLE `tiki_file_galleries` ADD COLUMN `default_view` varchar(20) default NULL Duplicate column name 'default_view'
  146.  
  147. 20090429_groupId_tiki
  148. #sylvieg alter table users_groups drop primary key Incorrect table definition; there can be only one auto column and it must be defined as a key alter table users_groups add column id int(11) NOT NULL auto_increment first, add primary key (id), auto_increment = 1 Duplicate column name 'id' alter table users_groups add unique `groupName` (`groupName`) Duplicate key name 'groupName'
  149.  
  150. 20090513_wiki_similar_permission_tiki
  151. INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_wiki_view_similar', 'Can view similar wiki pages', 'registered', 'wiki') Duplicate entry 'tiki_p_wiki_view_similar' for key 'PRIMARY'
  152.  
  153. 20090602_webmail_protocols_tiki
  154. ALTER TABLE `tiki_user_mail_accounts` ADD `imap` VARCHAR( 255 ) NOT NULL , ADD `mbox` VARCHAR( 255 ) NOT NULL , ADD `maildir` VARCHAR( 255 ) NOT NULL , ADD `useSSL` CHAR( 1 ) NOT NULL DEFAULT 'n' Duplicate column name 'imap'
  155.  
  156. 20090605_tiki_p_modify_tracker_items_pending_closed_tiki
  157. INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_modify_tracker_items_pending', 'Can change tracker pending items', 'registered', 'trackers') Duplicate entry 'tiki_p_modify_tracker_items_pending' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_modify_tracker_items_closed', 'Can change tracker closed items', 'registered', 'trackers') Duplicate entry 'tiki_p_modify_tracker_items_closed' for key 'PRIMARY'
  158.  
  159. 20090626_change_pear_auth_preferences_to_ldap_tiki
  160. alter table users_groups add column(`isExternal` char default 'n') Duplicate column name 'isExternal'
  161.  
  162. 20090707_tiki_p_delete_account_tiki
  163. INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_delete_account', 'Can delete his own account', 'admin', 'tiki'); Duplicate entry 'tiki_p_delete_account' for key 'PRIMARY'
  164.  
  165. 20090713_tiki_importer_permission_and_menu_entry_tiki
  166. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`) VALUES ('tiki_p_admin_importer', 'Can use the Tiki Importer', 'admin', 'tiki', 'y') Duplicate entry 'tiki_p_admin_importer' for key 'PRIMARY' INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Tiki Importer','tiki-importer.php',1240,'','tiki_p_admin_importer','',0) Duplicate entry '42-Tiki Importer-tiki-importer.php-1240--tiki_p_admin_importer-' for key 'uniq_menu'
  167.  
  168. 20090720_perspectives_tiki
  169. CREATE TABLE tiki_perspectives ( `perspectiveId` int NOT NULL AUTO_INCREMENT, name varchar(100) NOT NULL, PRIMARY KEY( `perspectiveId` ) ) ENGINE=MyISAM Table 'tiki_perspectives' already exists CREATE TABLE tiki_perspective_preferences ( `perspectiveId` int NOT NULL, pref varchar(40) NOT NULL, value text, PRIMARY KEY( `perspectiveId`, pref ) ) ENGINE=MyISAM Table 'tiki_perspective_preferences' already exists
  170.  
  171. 20090721_webmail_ext_public_tiki
  172. ALTER TABLE `tiki_webmail_contacts_fields` ADD `flagsPublic` CHAR( 1 ) NOT NULL DEFAULT 'n' Duplicate column name 'flagsPublic'
  173.  
  174. 20090727_category_permissions_tiki
  175. # 2009-07-27 lphuberdeau INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_view_category', 'Can see the category in a listing', 'basic', 'category') Duplicate entry 'tiki_p_view_category' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_modify_object_categories', 'Can change the categories on the object', 'editors', 'tiki') Duplicate entry 'tiki_p_modify_object_categories' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_add_object', 'Can add objects in the category', 'editors', 'category') Duplicate entry 'tiki_p_add_object' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_remove_object', 'Can remove objects from the category', 'editors', 'category') Duplicate entry 'tiki_p_remove_object' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_create_category', 'Can create new categories', 'admin', 'category') Duplicate entry 'tiki_p_create_category' for key 'PRIMARY'
  176.  
  177. 20090727_user_votings_index_tiki
  178. ALTER TABLE tiki_user_votings DROP PRIMARY KEY Can't DROP 'PRIMARY'; check that column/key exists
  179.  
  180. 20090730_p_list_newsletters_tiki
  181. INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_list_newsletters', 'Can list newsletters', 'basic', 'newsletters') Duplicate entry 'tiki_p_list_newsletters' for key 'PRIMARY' INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_list_newsletters','',0) Duplicate entry '42-Newsletters-tiki-newsletters.php-900-feature_newsletters-tiki' for key 'uniq_menu' INSERT INTO users_grouppermissions (`groupName`,`permName`) VALUES('Anonymous','tiki_p_list_newsletters') Duplicate entry 'Anonymous-tiki_p_list_newsletters' for key 'PRIMARY'
  182.  
  183. 20090803_perspective_permission_tiki
  184. INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_perspective_view', 'Can view the perspective', 'basic', 'perspective') Duplicate entry 'tiki_p_perspective_view' for key 'PRIMARY'
  185.  
  186. 20090804_kaltura_permissions_tiki
  187. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES ('tiki_p_admin_kaltura', 'Can admin kaltura feature', 'admin', 'kaltura', 'y', 'feature_kaltura'), ('tiki_p_upload_videos', 'Can upload video on kaltura server', 'registered', 'kaltura', NULL, 'feature_kaltura'), ('tiki_p_edit_videos', 'Can edit information of kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura'), ('tiki_p_remix_videos', 'Can create kaltura remix video', 'registered', 'kaltura', NULL, 'feature_kaltura'), ('tiki_p_view_videos', 'Can view kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura'), ('tiki_p_list_videos', 'Can list kaltura entries', 'registered', 'kaltura', NULL, 'feature_kaltura'), ('tiki_p_delete_videos', 'Can delete kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura'), ('tiki_p_download_videos', 'Can download kaltura entry', 'registered', 'kaltura', NULL, 'feature_kaltura') Duplicate entry 'tiki_p_admin_kaltura' for key 'PRIMARY'
  188.  
  189. 20090806_group_permissions_tiki
  190. # 2009-08-06 lphuberdeau INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_group_view', 'Can view the group', 'basic', 'group') Duplicate entry 'tiki_p_group_view' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_group_view_members', 'Can view the group members', 'basic', 'group') Duplicate entry 'tiki_p_group_view_members' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_group_add_member', 'Can add group members', 'admin', 'group') Duplicate entry 'tiki_p_group_add_member' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_group_remove_member', 'Can remove group members', 'admin', 'group') Duplicate entry 'tiki_p_group_remove_member' for key 'PRIMARY' INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_group_join', 'Can join or leave the group', 'admin', 'group') Duplicate entry 'tiki_p_group_join' for key 'PRIMARY'
  191.  
  192. 20090807_transitions_tiki
  193. -- 2009-08-07 lphuberdeau INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_trigger_transition', 'Can trigger the transition between two states', 'admin', 'transition', NULL, 'feature_group_transition,feature_category_transition') Duplicate entry 'tiki_p_trigger_transition' for key 'PRIMARY' CREATE TABLE `tiki_transitions` ( `transitionId` int NOT NULL AUTO_INCREMENT, `name` varchar(50), `preserve` int(1) NOT NULL DEFAULT 0, `type` varchar(20) NOT NULL, `from` varchar(255) NOT NULL, `to` varchar(255) NOT NULL, PRIMARY KEY(`transitionId`), KEY `transition_lookup` (`type`, `from`) ) ENGINE=MyISAM Table 'tiki_transitions' already exists
  194.  
  195. 20090808_add_wiki_minor_edits_tiki
  196. ALTER TABLE `tiki_pages` ADD `version_minor` int(8) NOT NULL default '0' AFTER `version`; Duplicate column name 'version_minor'
  197.  
  198. 20090811_filegals_container_tiki
  199. INSERT INTO `tiki_preferences` (`name`, `value`) VALUES ('fgal_root_id', (SELECT `galleryId` from `tiki_file_galleries` WHERE `type` = 'system') ) Subquery returns more than 1 row
  200.  
  201. 20090811_quizzes_tiki
  202. ALTER TABLE tiki_quizzes DROP COLUMN `nVersion` Can't DROP 'nVersion'; check that column/key exists
  203.  
  204. 20090823_kaltura_menu_options_tiki
  205. INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42, 's', 'Kaltura', 'tiki-list_kaltura_entries.php', 950, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', '', 0) Duplicate entry '42-Kaltura-tiki-list_kaltura_entries.php-950-feature_kaltura-tik' for key 'uniq_menu' INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42, 'o', 'List Entries', 'tiki-list_kaltura_entries.php', 952, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', '', 0) Duplicate entry '42-List Entries-tiki-list_kaltura_entries.php-952-feature_kaltur' for key 'uniq_menu' INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42, 'o', 'Upload Media', 'tiki-kaltura_video.php', 954, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_upload_videos', '', 0) Duplicate entry '42-Upload Media-tiki-kaltura_video.php-954-feature_kaltura-tiki_' for key 'uniq_menu'
  206.  
  207. 20090826_group_expiration_tiki
  208. ALTER TABLE `users_groups` ADD COLUMN `expireAfter` int(14) default 0 Duplicate column name 'expireAfter' ALTER TABLE `users_usergroups` ADD COLUMN `created` int(14) default NULL Duplicate column name 'created' ALTER TABLE `users_groups` ADD KEY `expireAfter` (`expireAfter`) Duplicate key name 'expireAfter'
  209.  
  210. 20090904_wysiwyg_newsletters_tiki
  211. ALTER TABLE `tiki_sent_newsletters` ADD COLUMN `wysiwyg` char(1) default NULL; Duplicate column name 'wysiwyg'
  212.  
  213. 20090911_tracker_item_change_user_tiki
  214. ALTER TABLE `tiki_tracker_items` ADD COLUMN `createdBy` varchar(200) default NULL Duplicate column name 'createdBy' ALTER TABLE `tiki_tracker_items` ADD COLUMN `lastModifBy` varchar(200) default NULL Duplicate column name 'lastModifBy'
  215.  
  216. 20090913_plugin_security_addedby_tiki
  217. #ricks99 ALTER TABLE tiki_plugin_security ADD added_by VARCHAR( 200 ) NULL AFTER status; Duplicate column name 'added_by'
  218.  
  219. 20090921_workspaces_tiki
  220. ALTER TABLE `tiki_categories` ADD COLUMN `rootCategId` int(12) default NULL Duplicate column name 'rootCategId' INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Workspaces','tiki-workspaces-index.php',920,'feature_workspaces','tiki_p_view_ws','',0) Duplicate entry '42-Workspaces-tiki-workspaces-index.php-920-feature_workspaces-t' for key 'uniq_menu' INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Workspaces Home','tiki-workspaces-index.php',925,'feature_workspaces','tiki_p_view_ws','',0) Duplicate entry '42-Workspaces Home-tiki-workspaces-index.php-925-feature_workspa' for key 'uniq_menu' INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','My Workspaces','tiki-my-workspaces.php',930,'feature_workspaces','tiki_p_view_ws','',0) Duplicate entry '42-My Workspaces-tiki-my-workspaces.php-930-feature_workspaces-t' for key 'uniq_menu' INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Manage Workspaces','tiki-manage-workspaces.php',935,'feature_workspaces','tiki_p_admin_ws.php','',0) Duplicate entry '42-Manage Workspaces-tiki-manage-workspaces.php-935-feature_work' for key 'uniq_menu'
  221.  
  222. 20090928_transition_guards_text_tiki
  223. -- 2009-09-18 lphuberdeau ALTER TABLE `tiki_transitions` ADD COLUMN guards TEXT Duplicate column name 'guards'
  224.  
  225. 20091020_faq_created_tiki
  226. alter table `tiki_faq_questions` add column `created` int(14) default NULL Duplicate column name 'created' alter table `tiki_faq_questions` add key `created` (`created`); Duplicate key name 'created'
  227.  
  228. 20091020_kaltura_tiki
  229. UPDATE tiki_menu_options set url = 'tiki-kaltura_upload.php' where name = 'Upload Media' and section = 'feature_kaltura' Duplicate entry '42-Upload Media-tiki-kaltura_upload.php-954-feature_kaltura-tiki' for key 'uniq_menu'
  230.  
  231. 20091028_quota_tiki
  232. alter table `tiki_file_galleries` add column `quota` int(8) default 0; Duplicate column name 'quota'
  233.  
  234. 20091105_auth_tokens_tiki
  235. -- 2009-11-05 lphuberdeau CREATE TABLE `tiki_auth_tokens` ( `tokenId` INT NOT NULL AUTO_INCREMENT, `creation` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `timeout` INT NOT NULL DEFAULT 0, `token` CHAR(32), `entry` VARCHAR(50), `parameters` VARCHAR(255), `groups` VARCHAR(255), PRIMARY KEY( `tokenId` ), KEY `tiki_auth_tokens_token` (`token`) ) Table 'tiki_auth_tokens' already exists
  236.  
  237. 20091111_fgal_size_tiki
  238. alter table `tiki_file_galleries` add column `size` int(14) default NULL; Duplicate column name 'size'
  239.  
  240. 20091112_template_type_tiki
  241. -- 2009-11-12 lphuberdeau : Add a field to indicate the type of template ALTER TABLE tiki_content_templates ADD COLUMN template_type VARCHAR( 20 ) NOT NULL DEFAULT 'static' AFTER templateId Duplicate column name 'template_type'
  242.  
  243. 20091120_poll_lookup_index_tiki
  244. ALTER TABLE tiki_polls ADD INDEX tiki_poll_lookup ( active , title ) Duplicate key name 'tiki_poll_lookup'
  245.  
  246. 20091123_dns_permission_tiki
  247. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_dsn_query', 'Can execute arbitrary queries on a given DSN', 'admin', 'dsn', NULL, NULL) Duplicate entry 'tiki_p_dsn_query' for key 'PRIMARY'
  248.  
  249. 20091124_fgal_backlink_tiki
  250. CREATE TABLE `tiki_file_backlinks` ( `fileId` int(14) NOT NULL, `objectId` int(12) NOT NULL, KEY `objectId` (`objectId`), KEY `fileId` (`fileId`) ); Table 'tiki_file_backlinks' already exists
  251.  
  252. 20091125_wiki_comments_per_page_tiki
  253. #jonnyb ALTER TABLE `tiki_pages` ADD `comments_enabled` CHAR( 1 ) NULL DEFAULT NULL Duplicate column name 'comments_enabled'
  254.  
  255. 20091126_dynamic_variables_i18n_tiki
  256. -- 2009-11-26 mozilla upstream, multilingual dynamic variables ALTER TABLE `tiki_dynamic_variables` ADD COLUMN `lang` VARCHAR(16) NULL Duplicate column name 'lang' ALTER TABLE `tiki_dynamic_variables` DROP PRIMARY KEY Can't DROP 'PRIMARY'; check that column/key exists
  257.  
  258. 20091204_filegal_wiki_syntax_tiki
  259. #jonnyb ALTER TABLE `tiki_file_galleries` ADD `wiki_syntax` VARCHAR( 200 ) NULL Duplicate column name 'wiki_syntax'
  260.  
  261. 20091204_tiki_p_view_newsletter_tiki
  262. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_view_newsletter', 'Can view the archive of a newsletters', 'basic', 'newsletters', NULL, 'feature_newsletters') Duplicate entry 'tiki_p_view_newsletter' for key 'PRIMARY'
  263.  
  264. 20091208_backlink_perms_tiki
  265. AlTER TABLE `tiki_file_galleries` ADD COLUMN `backlinkPerms` char(1) default 'n'; Duplicate column name 'backlinkPerms'
  266.  
  267. 20091210_dcs_type_tiki
  268. ALTER TABLE tiki_programmed_content ADD COLUMN content_type VARCHAR( 20 ) NOT NULL DEFAULT 'static' AFTER contentId Duplicate column name 'content_type'
  269.  
  270. 20091214_perspective_management_tiki
  271. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_perspective_edit', 'Can edit the perspective', 'admin', 'perspective', NULL, 'feature_perspective') Duplicate entry 'tiki_p_perspective_edit' for key 'PRIMARY' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_perspective_create', 'Can create a perspective', 'admin', 'perspective', NULL, 'feature_perspective') Duplicate entry 'tiki_p_perspective_create' for key 'PRIMARY' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_perspective_admin', 'Can admin perspectives', 'admin', 'perspective', 'y', 'feature_perspective') Duplicate entry 'tiki_p_perspective_admin' for key 'PRIMARY'
  272.  
  273. 20091216_show_backlinks_tiki
  274. ALTER TABLE `tiki_file_galleries` ADD COLUMN `show_backlinks` char(1) default NULL; Duplicate column name 'show_backlinks'
  275.  
  276. 20091228_page_keywords_tiki
  277. ALTER TABLE `tiki_pages` ADD COLUMN `keywords` TEXT Duplicate column name 'keywords'
  278.  
  279. 20100104_tiki_p_tracker_revote_ratings_tiki
  280. INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_tracker_revote_ratings', 'Can re-vote a rating for tracker items', 'registered', 'trackers') Duplicate entry 'tiki_p_tracker_revote_ratings' for key 'PRIMARY'
  281.  
  282. 20100106_forum_att_list_nb_tiki
  283. alter table `tiki_forums` add column `att_list_nb` char(1) default NULL after `att_max_size`; Duplicate column name 'att_list_nb'
  284.  
  285. 20100107_payment_tiki
  286. CREATE TABLE `tiki_payment_requests` ( `paymentRequestId` INT NOT NULL AUTO_INCREMENT, `amount` DECIMAL(7,2) NOT NULL, `amount_paid` DECIMAL(7,2) NOT NULL DEFAULT 0.0, `currency` CHAR(3) NOT NULL, `request_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `due_date` TIMESTAMP NOT NULL, `cancel_date` TIMESTAMP NULL, `description` VARCHAR(100) NOT NULL, `actions` TEXT, PRIMARY KEY( `paymentRequestId` ) ) Table 'tiki_payment_requests' already exists CREATE TABLE `tiki_payment_received` ( `paymentReceivedId` INT NOT NULL AUTO_INCREMENT, `paymentRequestId` INT NOT NULL, `payment_date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `amount` DECIMAL(7,2), `type` VARCHAR(15), `details` TEXT, PRIMARY KEY(`paymentReceivedId`), KEY `payment_request_ix` (`paymentRequestId`) ) Table 'tiki_payment_received' already exists INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_admin', 'Can administer payments', 'admin', 'payment', 'y', 'payment_feature') Duplicate entry 'tiki_p_payment_admin' for key 'PRIMARY' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_view', 'Can view payment requests and details', 'admin', 'payment', NULL, 'payment_feature') Duplicate entry 'tiki_p_payment_view' for key 'PRIMARY' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_manual', 'Can enter manual payments', 'admin', 'payment', NULL, 'payment_feature') Duplicate entry 'tiki_p_payment_manual' for key 'PRIMARY' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_request', 'Can request a payment', 'admin', 'payment', NULL, 'payment_feature') Duplicate entry 'tiki_p_payment_request' for key 'PRIMARY'
  287.  
  288. 20100113_forum_display_tiki
  289. alter table `tiki_forums` add column `topics_list_lastpost_title` char(1) default NULL AFTER `topics_list_lastpost` Duplicate column name 'topics_list_lastpost_title'
  290.  
  291. 20100114_tiki_actionlog_merge_tiki
  292. #add client to store USER_AGENT ALTER TABLE `tiki_actionlog` ADD `client` VARCHAR( 200 ) NULL DEFAULT NULL Duplicate column name 'client'
  293.  
  294. 20100115_admin_modules_menu_tiki
  295. INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_modules','',0) Duplicate entry '42-Admin-tiki-admin.php-1050--tiki_p_admin_modules-' for key 'uniq_menu'
  296.  
  297. 20100115_tiki_p_admin_modules_tiki
  298. INSERT INTO users_permissions (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES ('tiki_p_admin_modules', 'User can Administer Modules', 'registered', 'tiki', NULL, NULL) Duplicate entry 'tiki_p_admin_modules' for key 'PRIMARY'
  299.  
  300. 20100118_blog_use_author_tiki
  301. ALTER TABLE tiki_blogs ADD COLUMN `use_author` char(1) default NULL AFTER `use_title` Duplicate column name 'use_author'
  302.  
  303. 20100118_forum_display_tiki
  304. alter table `tiki_forums` add column `topics_list_lastpost_avatar` char(1) default NULL AFTER `topics_list_lastpost_title` Duplicate column name 'topics_list_lastpost_avatar' alter table `tiki_forums` add column `topics_list_author_avatar` char(1) default NULL AFTER `topics_list_author` Duplicate column name 'topics_list_author_avatar'
  305.  
  306. 20100126_file_lastDownload_tiki
  307. alter table `tiki_files` add column `lastDownload` int(14) default NULL after `hits`; Duplicate column name 'lastDownload'
  308.  
  309. 20100128_tiki_p_blog_view_ref_tiki
  310. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_blog_post_view_ref', 'Can view in module and feed the blog posts', 'basic', 'blogs', NULL, 'feature_blogs') Duplicate entry 'tiki_p_blog_post_view_ref' for key 'PRIMARY' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_blog_view_ref', 'Can view in module and feed the blog', 'basic', 'blogs', NULL, 'feature_blogs') Duplicate entry 'tiki_p_blog_view_ref' for key 'PRIMARY'
  311.  
  312. 20100203_payment_detail_tiki
  313. ALTER TABLE tiki_payment_requests ADD COLUMN detail TEXT Duplicate column name 'detail'
  314.  
  315. 20100205_tiki_p_wiki_view_ref_tiki
  316. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_wiki_view_ref', 'Can view in module and feed the wiki pages reference', 'basic', 'wiki', NULL, 'feature_wiki') Duplicate entry 'tiki_p_wiki_view_ref' for key 'PRIMARY'
  317.  
  318. 20100211_rss_items_tiki
  319. CREATE TABLE `tiki_rss_items` ( `rssItemId` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `rssId` INT NOT NULL, `guid` VARCHAR(255) NOT NULL, `url` VARCHAR(255) NOT NULL, `publication_date` INT UNSIGNED NOT NULL, `title` VARCHAR(255) NOT NULL, `author` VARCHAR(255), `description` TEXT, `content` TEXT, KEY `tiki_rss_items_rss` (`rssId`), UNIQUE `tiki_rss_items_item` (`rssId`, `guid`) ) Table 'tiki_rss_items' already exists ALTER TABLE `tiki_rss_modules` DROP COLUMN `content` Can't DROP 'content'; check that column/key exists ALTER TABLE `tiki_rss_modules` ADD COLUMN `sitetitle` VARCHAR(255) Duplicate column name 'sitetitle' ALTER TABLE `tiki_rss_modules` ADD COLUMN `siteurl` VARCHAR(255) Duplicate column name 'siteurl'
  320.  
  321. 20100211_tiki_sheet_add_parseValues_tiki
  322. ALTER TABLE `tiki_sheet_layout` ADD `parseValues` CHAR( 1 ) NOT NULL DEFAULT 'n' Duplicate column name 'parseValues'
  323.  
  324. 20100212_rss_automation_tiki
  325. ALTER TABLE `tiki_rss_modules` ADD `actions` TEXT Duplicate column name 'actions'
  326.  
  327. 20100215_create_tiki_user_login_cookies_tiki
  328. CREATE TABLE `tiki_user_login_cookies` ( `userId` INT NOT NULL, `secret` CHAR(64) NOT NULL, `expiration` TIMESTAMP NOT NULL, PRIMARY KEY (`userId`, `secret`) ) ENGINE=MyISAM AUTO_INCREMENT=1 Table 'tiki_user_login_cookies' already exists
  329.  
  330. 20100215_rating_permissions_tiki
  331. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_rate_article', 'Can rate articles', 'basic', 'cms', NULL, 'feature_articles') Duplicate entry 'tiki_p_rate_article' for key 'PRIMARY'
  332.  
  333. 20100216_attributes_tiki
  334. CREATE TABLE `tiki_object_attributes` ( `attributeId` INT PRIMARY KEY AUTO_INCREMENT, `type` varchar(50) NOT NULL, `itemId` varchar(255) NOT NULL, `attribute` varchar(25) NOT NULL, `value` varchar(100), UNIQUE `item_attribute_uq` ( `type`, `itemId`, `attribute` ), KEY `attribute_lookup_ix` (`attribute`, `value`) ) Table 'tiki_object_attributes' already exists
  335.  
  336. 20100217_rating_config_tiki
  337. CREATE TABLE `tiki_rating_configs` ( `ratingConfigId` INT PRIMARY KEY AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, `expiry` INT NOT NULL DEFAULT 3600, `formula` TEXT NOT NULL, `callbacks` TEXT ) Table 'tiki_rating_configs' already exists CREATE TABLE `tiki_rating_obtained` ( `ratingId` INT PRIMARY KEY AUTO_INCREMENT, `ratingConfigId` INT NOT NULL, `type` VARCHAR(50) NOT NULL, `object` INT NOT NULL, `expire` INT NOT NULL, `value` FLOAT NOT NULL, UNIQUE `tiki_obtained_rating_uq` (`type`, `object`, `ratingConfigId`) ) Table 'tiki_rating_obtained' already exists
  338.  
  339. 20100218_auth_token_reuse_tiki
  340. ALTER TABLE `tiki_auth_tokens` ADD COLUMN `hits` INT NOT NULL DEFAULT 1 AFTER `timeout` Duplicate column name 'hits'
  341.  
  342. 20100222_add_webmail_fromEmail_field_tiki
  343. ALTER TABLE `tiki_user_mail_accounts` ADD `fromEmail` VARCHAR( 255 ) NOT NULL DEFAULT '' Duplicate column name 'fromEmail'
  344.  
  345. 20100223_blog_always_owner_tiki
  346. ALTER TABLE `tiki_blogs` ADD COLUMN `always_owner` char(1); Duplicate column name 'always_owner'
  347.  
  348. 20100224_object_relations_tiki
  349. CREATE TABLE `tiki_object_relations` ( `relationId` INT PRIMARY KEY AUTO_INCREMENT, `relation` varchar(25) NOT NULL, `source_type` varchar(50) NOT NULL, `source_itemId` varchar(255) NOT NULL, `target_type` varchar(50) NOT NULL, `target_itemId` varchar(255) NOT NULL, KEY `relation_source_ix` (`source_type`, `source_itemId`), KEY `relation_target_ix` (`target_type`, `target_itemId`) ) Table 'tiki_object_relations' already exists
  350.  
  351. 20100226_tracker_dump_perm_tiki
  352. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_tracker_dump', 'Can save a CSV backup of entire trackers', 'admin', 'trackers', NULL, 'feature_trackers') Duplicate entry 'tiki_p_tracker_dump' for key 'PRIMARY'
  353.  
  354. 20100302_filegal_images_max_sizes_tiki
  355. # Jyhem ALTER TABLE `tiki_file_galleries` ADD `image_max_size_x` INT( 8 ) NOT NULL DEFAULT '0' Duplicate column name 'image_max_size_x' ALTER TABLE `tiki_file_galleries` ADD `image_max_size_y` INT( 8 ) NOT NULL DEFAULT '0' Duplicate column name 'image_max_size_y'
  356.  
  357. 20100308_file_delete_after_tiki
  358. AlTER TABLE `tiki_files` ADD COLUMN `deleteAfter` int(14) default NULL Duplicate column name 'deleteAfter'
  359.  
  360. 20100309_add_sheet_parent_tiki
  361. ALTER TABLE `tiki_sheets` ADD `parentSheetId` int(8) NULL Duplicate column name 'parentSheetId'
  362.  
  363. 20100312_emailPattern_tiki
  364. ALTER TABLE `users_groups` ADD `emailPattern` varchar(255) default ''; Duplicate column name 'emailPattern'
  365.  
  366. 20100324_newsletters_clippings_tiki
  367. ALTER TABLE `tiki_newsletters` ADD COLUMN `allowArticleClip` char(1) default 'y' Duplicate column name 'allowArticleClip' ALTER TABLE `tiki_newsletters` ADD COLUMN `autoArticleClip` char(1) default 'n' Duplicate column name 'autoArticleClip' ALTER TABLE `tiki_newsletters` ADD COLUMN `articleClipTypes` text Duplicate column name 'articleClipTypes' ALTER TABLE `tiki_newsletters` ADD COLUMN `articleClipRange` int(14) default NULL Duplicate column name 'articleClipRange'
  368.  
  369. 20100409_bigger_module_params_tiki
  370. ALTER TABLE `tiki_modules` DROP PRIMARY KEY Incorrect table definition; there can be only one auto column and it must be defined as a key ALTER TABLE `tiki_modules` DROP INDEX `moduleId`, ADD PRIMARY KEY ( `moduleId` ) Can't DROP 'moduleId'; check that column/key exists ALTER TABLE `tiki_modules` ADD INDEX `namePosOrdParam` ( `name` ( 100 ) , `position` , `ord` , `params` ( 140 ) ) Duplicate key name 'namePosOrdParam'
  371.  
  372. 20100419_bigbluebutton_tiki
  373. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_bigbluebutton_join', 'Can join a meeting', 'basic', 'bigbluebutton', NULL, 'bigbluebutton_feature') Duplicate entry 'tiki_p_bigbluebutton_join' for key 'PRIMARY' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_bigbluebutton_moderate', 'Can moderate a meeting', 'admin', 'bigbluebutton', NULL, 'bigbluebutton_feature') Duplicate entry 'tiki_p_bigbluebutton_moderate' for key 'PRIMARY' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_bigbluebutton_create', 'Can create a meeting', 'admin', 'bigbluebutton', NULL, 'bigbluebutton_feature') Duplicate entry 'tiki_p_bigbluebutton_create' for key 'PRIMARY'
  374.  
  375. 20100422_tracker_log_tiki
  376. CREATE TABLE `tiki_tracker_item_field_logs` ( `version` int(12) NOT NULL, `itemId` int(12) NOT NULL default '0', `fieldId` int(12) NOT NULL default '0', `value` text, `lang` char(16) default NULL, INDEX `version` (`version`), INDEX `itemId` (`itemId`), INDEX `fieldId` (`itemId`) ) ENGINE=MyISAM Table 'tiki_tracker_item_field_logs' already exists
  377.  
  378. 20100525_tracker_validation_message_tiki
  379. #2010-05-25 nkoth ALTER TABLE tiki_tracker_fields ADD COLUMN `validationMessage` varchar(255) default '' Duplicate column name 'validationMessage'
  380.  
  381. 20100525_tracker_validation_tiki
  382. #2010-05-25 nkoth ALTER TABLE tiki_tracker_fields ADD COLUMN `validation` varchar(255) default '' Duplicate column name 'validation' ALTER TABLE tiki_tracker_fields ADD COLUMN `validationParam` varchar(255) default '' Duplicate column name 'validationParam'
  383.  
  384. 20100618_calendar_participation_tiki
  385. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_calendar_add_my_particip', 'Can add own user to the participants', 'registered', 'calendar', NULL, 'feature_calendar') Duplicate entry 'tiki_p_calendar_add_my_particip' for key 'PRIMARY' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_calendar_add_guest_particip', 'Can add guest to the participants', 'registered', 'calendar', NULL, 'feature_calendar'); Duplicate entry 'tiki_p_calendar_add_guest_particip' for key 'PRIMARY'
  386.  
  387. 20100621_pageprefixaliasdata_tiki
  388. INSERT INTO tiki_semantic_tokens (token, label) VALUES('prefixalias', 'Page Prefix Alias') Duplicate entry 'prefixalias' for key 'PRIMARY'
  389.  
  390. 20100622_pageprefixtrackeritemid_tiki
  391. INSERT INTO tiki_semantic_tokens (token, label) VALUES('titlefieldid', 'Field Id for Page Title'),('trackerid', 'Id of Embedded Tracker') Duplicate entry 'titlefieldid' for key 'PRIMARY'
  392.  
  393. 20100624_banning_index_tiki
  394. ALTER TABLE `tiki_banning` ADD INDEX ban(`use_dates`, `date_from`, `date_to`); Duplicate key name 'ban'
  395.  
  396. 20100628_payment_user_tiki
  397. ALTER TABLE `tiki_payment_requests` ADD COLUMN `userId` int(8) Duplicate column name 'userId' ALTER TABLE `tiki_payment_received` ADD COLUMN `userId` int(8) Duplicate column name 'userId'
  398.  
  399. 20100702_discount_tiki
  400. CREATE TABLE `tiki_discount`( `id` INT NOT NULL AUTO_INCREMENT, `code` VARCHAR(255), `value` VARCHAR(255), `max` INT, `comment` TEXT, PRIMARY KEY(`id`), KEY `code` (`code`) ) Table 'tiki_discount' already exists
  401.  
  402. 20100720_tiki_p_view_page_contribution_tiki
  403. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_page_contribution_view', 'Can view contributions to a page', 'basic', 'wiki', NULL, 'feature_wiki'); Duplicate entry 'tiki_p_page_contribution_view' for key 'PRIMARY'
  404.  
  405. 20100721_todo_tiki
  406. CREATE TABLE `tiki_todo` ( `todoId` INT(12) NOT NULL auto_increment, `after` INT(12) NOT NULL, `event` ENUM('creation', 'modification', 'upload'), `objectType` VARCHAR(50), `objectId` VARCHAR(255) default NULL, `from` VARCHAR(255) default NULL, `to` VARCHAR(255) default NULL, PRIMARY KEY (`todoId`), KEY `what` (`objectType`, `objectId`), KEY `after` (`after`) ) Table 'tiki_todo' already exists CREATE TABLE `tiki_todo_notif` ( `todoId` INT(12) NOT NULL, `objectId` VARCHAR(255) default NULL, KEY `todoId` (`todoId`), KEY `objectId` (`objectId`) ) Table 'tiki_todo_notif' already exists
  407.  
  408. 20100721_todonotif_tiki
  409. ALTER TABLE `tiki_todo_notif` ADD COLUMN `objectType` VARCHAR(50) AFTER `todoId`; Duplicate column name 'objectType'
  410.  
  411. 20100730_list_image_article_tiki
  412. ALTER TABLE `tiki_articles` ADD COLUMN `list_image_x` int(4) default NULL AFTER `image_y` Duplicate column name 'list_image_x'
  413.  
  414. 20100802_tiki_p_share_tiki
  415. INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_share', 'Can share a page (email, twitter, facebook, message, forums)', 'Basic', 'tiki', NULL, NULL) Duplicate entry 'tiki_p_share' for key 'PRIMARY'
  416.  
  417. 20100806_blog_posts_header_tiki
  418. # Jyhem ALTER TABLE `tiki_blogs` ADD `post_heading` TEXT NULL AFTER `heading` Duplicate column name 'post_heading'
  419.  
  420. 20100812_blog_control_max_related_content_tiki
  421. ALTER TABLE `tiki_blogs` ADD COLUMN `related_max` int(4) DEFAULT 5 Duplicate column name 'related_max'
  422.  
  423. 20100812_blog_show_related_content_tiki
  424. ALTER TABLE `tiki_blogs` ADD COLUMN `show_related` char(1) DEFAULT NULL Duplicate column name 'show_related'
  425.  
  426. 20100817_add_email_and_website_fields_to_comments_tiki
  427. ALTER TABLE `tiki_comments` ADD COLUMN `email` varchar(200) DEFAULT NULL AFTER `hash` Duplicate column name 'email' ALTER TABLE `tiki_comments` ADD COLUMN `website` varchar(200) DEFAULT NULL AFTER `email` Duplicate column name 'website'
  428.  
  429. 20100818_watch_tiki
  430. ALTER TABLE `tiki_user_watches` DROP INDEX `watchId` Can't DROP 'watchId'; check that column/key exists ALTER TABLE `tiki_group_watches` DROP INDEX `watchId` Can't DROP 'watchId'; check that column/key exists ALTER TABLE `tiki_user_watches` ADD INDEX `event-object-user` ( `event` , `object` ( 100 ) , `user` ( 50 ) ) Duplicate key name 'event-object-user' ALTER TABLE `tiki_group_watches` ADD INDEX `event-object-group` ( `event` , `object` ( 100 ) , `group` ( 50 ) ) Duplicate key name 'event-object-group'
  431.  
  432. 20100820_blog_posts_wysiwyg_tiki
  433. # Jyhem ALTER TABLE `tiki_blog_posts` ADD `wysiwyg` VARCHAR( 1 ) DEFAULT NULL Duplicate column name 'wysiwyg'
  434.  
  435. 20100824_blog_post_excerpt_tiki
  436. ALTER TABLE `tiki_blogs` ADD COLUMN `use_excerpt` char(1) default NULL AFTER `use_author` Duplicate column name 'use_excerpt' ALTER TABLE `tiki_blog_posts` ADD COLUMN `excerpt` text default NULL AFTER `data_size` Duplicate column name 'excerpt'
  437.  
  438. 20100825_add_changed_column_to_tiki_language_table_tiki
  439. ALTER TABLE `tiki_language` DROP PRIMARY KEY Incorrect table definition; there can be only one auto column and it must be defined as a key ALTER TABLE `tiki_language` ADD COLUMN `id` int(14) NOT NULL PRIMARY KEY auto_increment FIRST Duplicate column name 'id' ALTER TABLE `tiki_language` ADD COLUMN `changed` bool DEFAULT 0 Duplicate column name 'changed'
  440.  
  441. 20100830_sheet_add_styles_and_classes_tiki
  442. ALTER TABLE `tiki_sheet_values` ADD `style` VARCHAR( 255 ) DEFAULT '' Duplicate column name 'style' ALTER TABLE `tiki_sheet_values` ADD `class` VARCHAR( 255 ) DEFAULT '' Duplicate column name 'class'
  443.  
  444. 20100901_expire_tiki
  445. ALTER TABLE `users_usergroups` ADD COLUMN `expire` int(14) default NULL; Duplicate column name 'expire'
  446.  
  447. 20100902_invit_tiki
  448. CREATE TABLE `tiki_invit` ( `id` int(11) NOT NULL auto_increment, `inviter` varchar(200) NOT NULL, `groups` varchar(255) default NULL, `ts` int(11) NOT NULL, `emailsubject` varchar(255) NOT NULL, `emailcontent` text NOT NULL, `wikicontent` text, `wikipageafter` varchar(255) default NULL, PRIMARY KEY (`id`) ) Table 'tiki_invit' already exists CREATE TABLE `tiki_invited` ( `id` int(11) NOT NULL auto_increment, `id_invit` int(11) NOT NULL, `email` varchar(255) NOT NULL, `firstname` varchar(24) NOT NULL, `lastname` varchar(24) NOT NULL, `used` enum('no','registered','logged') NOT NULL, `used_on_user` varchar(200) default NULL, PRIMARY KEY (`id`), KEY `id_invit` (`id_invit`), KEY `used_on_user` (`used_on_user`) ) Table 'tiki_invited' already exists INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES ('tiki_p_invit', 'Can invit users by email, and include them in groups', 'registered', 'tiki', NULL, 'feature_invit') Duplicate entry 'tiki_p_invit' for key 'PRIMARY'
  449.  
  450. 20100903_article_ispublished_tiki
  451. ALTER TABLE `tiki_articles` ADD `ispublished` char(1) NOT NULL DEFAULT 'y' Duplicate column name 'ispublished'
  452.  
  453. 20100910_new_fields_for_tiki_blogs_tiki
  454. ALTER TABLE tiki_blogs ADD COLUMN `use_title` char(1) default 'y' AFTER `use_find` Duplicate column name 'use_title' ALTER TABLE tiki_blogs ADD COLUMN `use_title_in_post` char(1) default 'y' AFTER `use_title` Duplicate column name 'use_title_in_post' ALTER TABLE tiki_blogs ADD COLUMN `use_description` char(1) default 'y' AFTER `use_title_in_post` Duplicate column name 'use_description' ALTER TABLE tiki_blogs ADD COLUMN `use_breadcrumbs` char(1) default 'n' AFTER `use_description` Duplicate column name 'use_breadcrumbs'
  455.  
  456. 20100915_add_edit_languages_menu_option_tiki
  457. INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Edit languages','tiki-edit_languages.php',1098,'lang_use_db','tiki_p_edit_languages','',0) Duplicate entry '42-Edit languages-tiki-edit_languages.php-1098-lang_use_db-tiki_' for key 'uniq_menu'
  458.  
  459. 20101027_rename_invit_to_invite_tiki
  460. ALTER TABLE `tiki_invit` RENAME TO `tiki_invite` Table 'tiki_invite' already exists ALTER TABLE `tiki_invited` DROP KEY `id_invit` Can't DROP 'id_invit'; check that column/key exists ALTER TABLE `tiki_invited` CHANGE `id_invit` `id_invite` int(11) NOT NULL Unknown column 'id_invit' in 'tiki_invited' ALTER TABLE `tiki_invited` ADD KEY `id_invite` (`id_invite`) Duplicate key name 'id_invite' UPDATE users_permissions SET feature_check="feature_invite", permName='tiki_p_invite_to_my_groups' where permName="tiki_p_invit" Duplicate entry 'tiki_p_invite_to_my_groups' for key 'PRIMARY'
  461.  
  462. 20101028_p_invit_tiki
  463. UPDATE `users_permissions` SET `permName`='tiki_p_invite' WHERE `permName`='tiki_p_invite_to_my_groups' Duplicate entry 'tiki_p_invite' for key 'PRIMARY'
  464.  
  465. If you think that the errors of a patch can be ignored, please check the checkbox associated to it before clicking on continue.
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!