[TikiWiki-commits] [Git][tikiwiki/tiki][27.x] [FIX] Avoid invalid secdb primary key on upgrade

ushindi bienvenu pushed to branch 27.x at Tiki Wiki CMS Groupware / Tiki


Commits:
e0451324 by ushindi bienvenu at 2026-05-23T19:16:31+02:00
[FIX] Avoid invalid secdb primary key on upgrade

- - - - -


3 changed files:

- installer/schema/20180921_php_upgrade_fix_from_older_tiki.php
- installer/schema/20180921_sql_upgrade_fix_from_older_tiki.php
- installer/schema/20180923_convert_collation_to_utf8mb4_tiki.php


Changes:

=====================================
installer/schema/20180921_php_upgrade_fix_from_older_tiki.php
=====================================
@@ -9,10 +9,6 @@
  */
 function upgrade_20180921_php_upgrade_fix_from_older_tiki($installer)
 {
-    // Fix upgrade from 9.x
-    $installer->query('ALTER TABLE `tiki_secdb` DROP PRIMARY KEY;'); // it might not be set
-    $installer->query('ALTER TABLE `tiki_secdb` ADD PRIMARY KEY (`filename`(215),`tiki_version`(40));');
-
     // Fix upgrade from 12.x
     $tablesToRename = [
         'metrics_assigned',


=====================================
installer/schema/20180921_sql_upgrade_fix_from_older_tiki.php
=====================================
@@ -14,8 +14,6 @@ function upgrade_20180921_sql_upgrade_fix_from_older_tiki($installer)
 ALTER TABLE `tiki_forums_reported` DROP PRIMARY KEY;
 ALTER TABLE `tiki_forums_reported` ADD PRIMARY KEY (`threadId`, `forumId`, `parentId`, `user`); -- Changed in 20121210_better_forum_reported_index_tiki.sql but never make it to tiki.sql
 DELETE FROM `users_permissions` WHERE `permName` = 'tiki_p_view_poll_choices';
-ALTER TABLE `tiki_secdb` DROP PRIMARY KEY;
-ALTER TABLE `tiki_secdb` ADD PRIMARY KEY (`filename`(215),`tiki_version`(40));
 UPDATE `tiki_modules` SET `position` = '' WHERE `position` IS NULL;
 ALTER TABLE `tiki_modules` CHANGE `position` `position` varchar(20) NOT NULL DEFAULT '';
 ALTER TABLE `tiki_profile_symbols` CHANGE `value` `value` varchar(160) NOT NULL;


=====================================
installer/schema/20180923_convert_collation_to_utf8mb4_tiki.php
=====================================
@@ -296,8 +296,6 @@ ALTER TABLE `tiki_semaphores` DROP PRIMARY KEY;
 ALTER TABLE `tiki_semaphores` ADD PRIMARY KEY (`semName`(191));
 ALTER TABLE `tiki_secdb` DROP INDEX `sdb_fn`;
 ALTER TABLE `tiki_secdb` ADD KEY `sdb_fn` (`filename`(191));
-ALTER TABLE `tiki_secdb` DROP PRIMARY KEY;
-ALTER TABLE `tiki_secdb` ADD PRIMARY KEY (`filename`(171),`tiki_version`(20));
 ALTER TABLE `tiki_score` DROP PRIMARY KEY;
 ALTER TABLE `tiki_score` ADD PRIMARY KEY (`event`(191));
 ALTER TABLE `tiki_rss_items` DROP INDEX `tiki_rss_items_item`;



View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/e04513240e410cafed01ebed658c7909255ca235

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/e04513240e410cafed01ebed658c7909255ca235
You're receiving this email because of your account on gitlab.com. Manage all notifications: https://gitlab.com/-/profile/notifications | Help: https://gitlab.com/help

_______________________________________________
TikiWiki-cvs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-cvs