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

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


Commits:
b312f068 by ushindi bienvenu at 2026-08-25T02:39:19+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
=====================================
@@ -2221,7 +2221,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
=====================================
@@ -28,6 +28,11 @@ function upgrade_20260825_increase_filename_len_in_pk_tiki(Installer $installer)
             AND TABLE_SCHEMA = '" . $dbs_tiki . "'
             AND TABLE_NAME = 'tiki_secdb'"
     );
+    
+    $installer->query(
+        "ALTER TABLE `tiki_secdb`
+        MODIFY COLUMN `filename` TEXT NOT NULL"
+    );
 
     if (! boolval($exists)) {
         $installer->query("



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

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