Maximum length of posts

[Mickeybyte]

Hi,

I'm experiencing a problem with the length of my posts. I'm using version Serendipity 1.1 and when I post more than 15.000 characters, it is automatically broken at 15.000 characters. Is this a limit in s9y of mysql?

Strange thing is I copy the text from a Word document (only basic formatting, nothing exotic) to the extended post entry window and it appears completely (did the test with 80.000 chars). When I save the post, and look again in the extended entry window, it is still completely there. When I look at the post through the weblog, it is broken at 15.000 chars. When I then edit the post, the extended entry window also only shows the first 15.0000 chars.

I have not yet been ablo to check the mysql database contents itself, but I hope to do so still today. If I have more information, I'll let you know.

Anyone who has experienced this behaviour or knows a solution?

Thanks a lot!
Mickeybyte

[garvinhicking]

Hi!

S9y uses a HTML Textarea form field. For HTTP requests, a single field cannot hold more than 65535 Bytes, so this should be the limit.

15.000 characters should be fine, though. But you need to pay attention if you use the WYSIWYG editor and paste text, it might have 3-4 times the size because of HTML tags that are hidden from you.

HTH,
Garvin

[mkljun]

I had this issue and for 2 days now.
I thought it has something to do with the long HTML I'm posting into the textarea as the plain text. I understand the 65k limit but I'm still not exceeding it. The text still got truncated. I cgecked and rechecked the HTML to find maybe a missing tag.

I finally realised that the issue is in the database.

I set the "serendipity_entries" "body" filed to "longtext" (text originally) and it works.

lp mk

[Timbalu]

Just to mention this here:
This already is the default for new installations since 1.6
http://board.s9y.org/viewtopic.php?f=2& ... ext#p93025
and can be manually altered as such

Code: Select all

ALTER TABLE serendipity_entries
CHANGE `body` `body` LONGTEXT,
CHANGE `extended` `extended` LONGTEXT;

[mkljun]

I had to change the 'value' column in 'serendipity_entryproperties' to LONGTEXT as well. The frontend was grabbing the content from this cache table instead from the 'serendipity_entries'.

In the later the 'body' column was set to LONGTEXT and it did not get cut. When I changed the content directly in the table, the changes did not show up on the page. Then I realised it must have some cache somewhere. I found the above mentioned table and change its 'value' to LONGTEXT. Now it shows everything properly.

Code: Select all

ALTER TABLE serendipity_entryproperties
CHANGE `value` `value` LONGTEXT;

[Timbalu]

Yes, right! Thanks for mentioning!

Again, this only may be a need, if you come up from a very old Serendipity install and the upgrades did not already touch it.