From e2a7e192a681a2d81070322fb23bbf08e62da624 Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Thu, 23 Feb 2023 16:21:29 +0100 Subject: Fix MySQL bug (#5132) #fix https://github.com/FreshRSS/FreshRSS/issues/5128 MySQL cannot have multiple VARCHAR(x) whose total length is higher than 65535 in the same table. > ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs --- app/SQL/install.sql.mysql.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'app/SQL/install.sql.mysql.php') diff --git a/app/SQL/install.sql.mysql.php b/app/SQL/install.sql.mysql.php index 3648e59d8..b8fff170a 100644 --- a/app/SQL/install.sql.mysql.php +++ b/app/SQL/install.sql.mysql.php @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `_feed` ( `kind` SMALLINT DEFAULT 0, -- 1.20.0 `category` INT DEFAULT 0, -- 1.20.0 `name` VARCHAR(191) NOT NULL, - `website` VARCHAR(32768) CHARACTER SET latin1 COLLATE latin1_bin, + `website` TEXT CHARACTER SET latin1 COLLATE latin1_bin, `description` TEXT, `lastUpdate` INT(11) DEFAULT 0, -- Until year 2038 `priority` TINYINT(2) NOT NULL DEFAULT 10, -- cgit v1.2.3