diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2023-02-23 16:21:29 +0100 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2023-02-23 16:21:29 +0100 |
| commit | e2a7e192a681a2d81070322fb23bbf08e62da624 (patch) | |
| tree | cd50f18fc930e7ee0b483ace1c735b5c9e5b7d3a | |
| parent | f3216b61b9d02531dad0d4244563c0d44cdc89ba (diff) | |
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
| -rw-r--r-- | app/SQL/install.sql.mysql.php | 2 |
1 files changed, 1 insertions, 1 deletions
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, |