Maximum length of posts

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
Mickeybyte
Posts: 2
Joined: Thu May 25, 2006 10:28 pm

Maximum length of posts

Post by Mickeybyte » Sat Feb 10, 2007 12:52 pm

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

User avatar
garvinhicking
Core Developer
Posts: 30020
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Maximum length of posts

Post by garvinhicking » Sat Feb 10, 2007 1:56 pm

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

mkljun
Regular
Posts: 5
Joined: Wed Nov 24, 2010 1:06 pm

Re: Maximum length of posts

Post by mkljun » Thu Jun 04, 2015 12:17 pm

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

User avatar
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Maximum length of posts

Post by Timbalu » Thu Jun 04, 2015 12:35 pm

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;
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian

mkljun
Regular
Posts: 5
Joined: Wed Nov 24, 2010 1:06 pm

Re: Maximum length of posts

Post by mkljun » Tue Mar 08, 2016 12:32 pm

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;

User avatar
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Maximum length of posts

Post by Timbalu » Tue Mar 08, 2016 6:09 pm

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.
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian

Post Reply