Wiki/News/Documents truncate contents to 64K in MYSQL
|Assignee:||Jean-Philippe Lang||% Done:|
I've found wiki posts over 64K get silently truncated. The problem is in the SQL specification of the following databases/fields is TEXT (64K) instead of MEDIUMTEXT (16MB) or LONGTEXT (>16MB):
Perhaps some of these don't need to change but I think most should be MEDIUMTEXT or LARGETEXT (documents for example)?
I have worked around this at my site with using the mysql command:
mysql> ALTER TABLE wiki_contents CHANGE text MEDIUMTEXT ;
but I'm afraid the next db migrate will mess it up, and others will hit it.
I suggest this is urgent priority, since data is lost.
#6 Updated by Thomas Lecavelier over 3 years ago
- File raise_wiki_content_size.patch added
- Assignee set to Jean-Philippe Lang
Rewrite from the patch #1404 : set wiki content and versioned content up to 16MB.
I can eventually add a wiki content truncation detection system, but it'd cost a reload of the modified instance. Is this patch ok or should I add the check?