diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2023-10-30 20:47:50 +0100 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2023-10-30 20:47:50 +0100 |
| commit | 0324df6f889f18500cc8d201fdc2845f3e4d1acf (patch) | |
| tree | fafa9ab06c7fc7a3d48392cd0fd1ac959cc40a37 /app/Models/FeedDAO.php | |
| parent | 06d00995049db9c7b915f67cfd4a5708aace458f (diff) | |
SQL increase length of VARCHAR fields (#5756)
* SQL increase length of VARCHAR fields
Increase length of all fields, keeping the limits for:
* Unique indexes on UTF-8: 191 bytes for MySQL;
* Unique indexes on ASCII: 767 bytes for MySQL;
* Max URL for external tools: 32768 characters;
* Max VARCHAR: 65535 bytes for MySQL;
Follow-up of https://github.com/FreshRSS/FreshRSS/pull/5038
Fix https://github.com/FreshRSS/FreshRSS/issues/4986
* Fix length test
Diffstat (limited to 'app/Models/FeedDAO.php')
| -rw-r--r-- | app/Models/FeedDAO.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/app/Models/FeedDAO.php b/app/Models/FeedDAO.php index 508d38bfc..127702765 100644 --- a/app/Models/FeedDAO.php +++ b/app/Models/FeedDAO.php @@ -58,10 +58,10 @@ class FreshRSS_FeedDAO extends Minz_ModelPdo { $valuesTmp['category'], mb_strcut(trim($valuesTmp['name']), 0, FreshRSS_DatabaseDAO::LENGTH_INDEX_UNICODE, 'UTF-8'), $valuesTmp['website'], - sanitizeHTML($valuesTmp['description'], '', 1023), + sanitizeHTML($valuesTmp['description'], ''), $valuesTmp['lastUpdate'], isset($valuesTmp['priority']) ? (int)$valuesTmp['priority'] : FreshRSS_Feed::PRIORITY_MAIN_STREAM, - mb_strcut($valuesTmp['pathEntries'], 0, 511, 'UTF-8'), + mb_strcut($valuesTmp['pathEntries'], 0, 65535, 'UTF-8'), base64_encode($valuesTmp['httpAuth']), isset($valuesTmp['error']) ? (int)$valuesTmp['error'] : 0, isset($valuesTmp['ttl']) ? (int)$valuesTmp['ttl'] : FreshRSS_Feed::TTL_DEFAULT, |