Project

General

Profile

Actions
Copy link

Defect #1071

closed

Wiki/News/Documents truncate contents to 64K in MYSQL

Added by W Snyder almost 16 years ago. Updated almost 12 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
Jean-Philippe Lang
Category:
Database
Target version:
0.9.0
Start date:
2008-04-17
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:
0.8.7

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

raise_wiki_content_size.patch (1.5 KB) raise_wiki_content_size.patch Rewritten patch from #1404 against r3182 Thomas Lecavelier, 2009-12-18 23:52

Related issues

Related to Redmine - Patch #1404: Raise wiki content page sizeClosedJean-Philippe Lang2008-06-08

Actions
Has duplicate Redmine - Feature #3669: Wiki page size too smallClosed2009-07-24

Actions
Has duplicate Redmine - Defect #3777: Long wiki pages drop text when editedClosed2009-08-25

Actions
Actions
Copy link

Also available in: Atom PDF