[TikiWiki-commits] [Git][tikiwiki/tiki][29.x] [FIX] Secdb: Change filename to TEXT to prevent Data too long

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


Commits:
09c6f77a by ushindi bienvenu at 2026-08-25T03:54:50+02:00
[FIX] Secdb: Change filename to TEXT to prevent Data too long

- - - - -


2 changed files:

- db/tiki.sql
- installer/schema/20260825_increase_filename_len_in_pk_tiki.php


Changes:

=====================================
db/tiki.sql
=====================================
@@ -2214,7 +2214,7 @@ CREATE TABLE `tiki_search_stats` (
 DROP TABLE IF EXISTS `tiki_secdb`;
 CREATE TABLE tiki_secdb(
   `md5_value` varchar(32) NOT NULL,
-  `filename` varchar(250) NOT NULL,
+  `filename` TEXT NOT NULL,
   `filename_hash` char(32) NOT NULL DEFAULT '',
   `tiki_version` varchar(60) NOT NULL,
   `severity` int(4) NOT NULL default '0',


=====================================
installer/schema/20260825_increase_filename_len_in_pk_tiki.php
=====================================
@@ -29,6 +29,11 @@ function upgrade_20260825_increase_filename_len_in_pk_tiki(Installer $installer)
             AND TABLE_NAME = 'tiki_secdb'"
     );
 
+    $installer->query(
+        "ALTER TABLE `tiki_secdb`
+        MODIFY COLUMN `filename` TEXT NOT NULL"
+    );
+
     if (! boolval($exists)) {
         $installer->query("
             ALTER TABLE `tiki_secdb`



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

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