Why is the length of a HTML page limited with MojoMojo? #110

Closed
ZENON-FR opened this Issue Nov 24, 2012 · 13 comments

Comments

Projects
None yet
5 participants

Why is the length of the text entered on a HTML page limited (65 535 octects?) with MojoMojo whereas it is not the case with the pages of Wikipedia?

Is the text recorded in a DB column (sql TEXT)?

Is-there an easy and safe way to get rid of this limit?

Thanks to all who know and could help me...

ZENON-FR closed this Nov 24, 2012

ZENON-FR reopened this Nov 24, 2012

Owner

marcusramberg commented Nov 24, 2012

Hi, there really shouldn't be and such limit, content is stored as a sql TEXT column and at least in postgresql TEXT doesn't have a size limitation.

How does this limit manifest itself?

Hi. Thank you for your fast reply! In fact, when I try to record the page, the end is cut, including the {{end}} mark. Thus the page is no more displayed... I tried to evaluate how many characters are accepted. The problem occurs when the length exceeds approximately 65000, even sometimes less.

ZENON-FR closed this Nov 24, 2012

ZENON-FR reopened this Nov 24, 2012

Owner

mateu commented Nov 24, 2012

If you are using a MySQL database then TEXT is limited to what you've discovered, < 65536.
http://stackoverflow.com/questions/6766781/maximum-length-for-mysql-type-text

Sounds like Postgres can handle much larger sizes, up to 1 GB
http://www.postgresql.org/docs/current/interactive/datatype-character.html

I use a SQLite database... Do you think there is a limitation similar to MYSQL?

Owner

mateu commented Nov 25, 2012

Offhand, I don't know what the SQLite limitations are.

Thanks for your help, Marcus and Mateu.
Thus I keep on investigating...

Here is what I found concerning SQLite:
http://www.sqlite.org/limits.html
Unfortunately, I am not precisely a computer specialist, but a user maintaining myself the pages of my Web site...

Owner

dandv commented Nov 26, 2012

This won't help much, but I use SQLite as well, and here's a page I have
that's a bit longer (66,968 bytes source code):
http://wiki.dandascalescu.com/summaries/life_extension_conference_2012

Thank you Dan. You're right. It won't solve my problem. But you are confirming the paradox: on SQLite website it sounds that by default, the limit should be 1Go. But the size of our pages is limited... There must be a parameter somewhere fixing this limit, I suppose. Perhaps the solution is there:
http://www.sqlite.org/limits.html (§3)
Unfortunately, my technical understanding of this matter is not sufficient to take the risk to do it myself, without expert guidance ;-)

Owner

marcusramberg commented May 12, 2013

Closing this as we cannot reproduce, and @dandv has a bigger page on the same backend. Assuming configuration issue. Maybe web frontend?

Contributor

Dabg commented May 12, 2013

hi,

This is a limitation of type TEXT in tables content and precompiled.
you can change this by running these commands.

mysql> ALTER TABLE content CHANGE body body MEDIUMTEXT;
mysql> ALTER TABLE content CHANGE precompiled precompiled MEDIUMTEXT;

dab

Closing this as we cannot reproduce, and @dandv has a bigger page on
the same backend. Assuming configuration issue. Maybe web frontend?


Reply to this email directly or view it on GitHub:
#110 (comment)

Owner

marcusramberg commented May 12, 2013

@Dabg Given SQLite, I don't quite understand how TEXT differs from MEDIUMTEXT. can you eleborate?

edit Guessing you are talking about MySQL, which wasn't the issue here, but still useful if that works.

Contributor

Dabg commented May 12, 2013

Sorry it work with mysql but I have not tested with sqlite.

@Dabg Given SQLite, I don't quite understand how TEXT differs from
MEDIUMTEXT. can you eleborate?


Reply to this email directly or view it on GitHub:
#110 (comment)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment