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

Jonny Bradley pushed to branch master at Tiki Wiki CMS Groupware / Tiki


Commits:
12104009 by Olivier Kango at 2025-12-10T10:54:06+00:00
[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

- - - - -


2 changed files:

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


Changes:

=====================================
db/tiki.sql
=====================================
@@ -3958,11 +3958,12 @@ CREATE TABLE `tiki_credits_types` (
 
 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/121040094e3e6aabd0c0d91909685de7a7fd052b

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/121040094e3e6aabd0c0d91909685de7a7fd052b
You're receiving this email because of your account on gitlab.com.

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