[TikiWiki-commits] [Git][tikiwiki/tiki][27.x] [BP][FIX] Prevent tiki_queue entryId overflow: auto-upgrade to BIGINT + actionable errors

Olivier Kango pushed to branch 27.x at Tiki Wiki CMS Groupware / Tiki


Commits:
a8eaffa3 by Olivier Kango at 2026-03-17T12:08:15+02:00
[BP][FIX] Prevent tiki_queue entryId overflow: auto-upgrade to BIGINT + actionable errors
---
* [BP][FIX] Prevent tiki_queue entryId overflow: auto-upgrade to BIGINT + actionable errors
---
* [BP][FIX] Prevent tiki_queue entryId overflow: auto-upgrade to BIGINT + actionable errors
---
* [FIX] Prevent tiki_queue entryId overflow: auto-upgrade to BIGINT + actionable errors
---
* [FIX] Remove runtime guards for tiki_queue entryId overflow

* remove runtime ALTER; add DB migration to BIGINT; improve errors

* [UX] Append actionable guidance for entryId/AUTO_INCREMENT overflow

* [FIX] Prevent tiki_queue entryId overflow: auto-upgrade to BIGINT + actionable errors

See merge request tikiwiki/tiki!8391

(cherry picked from commit 121040094e3e6aabd0c0d91909685de7a7fd052b)

See merge request tikiwiki/tiki!9767

(cherry picked from commit f443cba18472e240ec57d5b6922b9a322301a5f5)

See merge request tikiwiki/tiki!9768

(cherry picked from commit 71ff340b76e455680849d8b2145624dd1579e342)

See merge request tikiwiki/tiki!9769

- - - - -


2 changed files:

- db/tiki.sql
- + installer/schema/20250908_queue_entryid_bigint_tiki.sql


Changes:

=====================================
db/tiki.sql
=====================================
@@ -3956,11 +3956,12 @@ CREATE TABLE `tiki_acct_tax` (
 
 DROP TABLE IF EXISTS `tiki_queue`;
 CREATE TABLE `tiki_queue` (
-    `entryId` INT PRIMARY KEY AUTO_INCREMENT,
+    `entryId` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
     `queue` VARCHAR(25) NOT NULL,
     `timestamp` INT NOT NULL,
     `handler` VARCHAR(64) NULL,
     `message` TEXT NOT NULL,
+    PRIMARY KEY (`entryId`),
     KEY `queue_name_ix` (`queue`),
     KEY `queue_handler_ix` (`handler`)
 ) ENGINE=MyISAM;


=====================================
installer/schema/20250908_queue_entryid_bigint_tiki.sql
=====================================
@@ -0,0 +1,3 @@
+-- Convert tiki_queue.entryId from INT to BIGINT to prevent AUTO_INCREMENT overflow
+ALTER TABLE `tiki_queue`
+  MODIFY COLUMN `entryId` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;



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

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/a8eaffa301224e2339e235c3708ad3296ef44f49
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