Actions
Defect #1071
closed
Wiki/News/Documents truncate contents to 64K in MYSQL
Start date:
2008-04-17
Due date:
% Done:
0%
Estimated time:
Resolution:
Fixed
Affected version:
Description
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):
| table changesets | comments |
| table comments | comments |
| table documents | description |
| table issues | description |
| table journals | notes |
| table messages | content |
| table news | description |
| table projects | description |
| table wiki_contents | text |
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.
Files
Related issues
Updated by 
Updated by 
Updated by 
Updated by 
Updated by
Actions