Post is getting cliped before the end
-
- Posts: 2
- Joined: Wed Jan 13, 2010 5:15 am
Post is getting cliped before the end
My first post is real long and I can't get the text posted all the way to the end.
Is there some kind of a limit on how long a post can be?
The site is: uncorrectable government databases.com (without the spaces)
Thanks in advance
Norm
Is there some kind of a limit on how long a post can be?
The site is: uncorrectable government databases.com (without the spaces)
Thanks in advance
Norm
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Post is getting cliped before the end
Hi!
Serendipity's database table has a cap of around 65kb. If you use MySQL, you could use a tool like phpMyAdmin to change the columns "body" and "extended" in the database table "serendipity_entries" vom "text" to "Longtext".
HTH,
Garvin
Serendipity's database table has a cap of around 65kb. If you use MySQL, you could use a tool like phpMyAdmin to change the columns "body" and "extended" in the database table "serendipity_entries" vom "text" to "Longtext".
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/
# 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/
-
- Regular
- Posts: 3652
- Joined: Mon Feb 13, 2006 2:40 am
- Location: Chicago, IL, USA
- Contact:
Re: Post is getting cliped before the end
You might want to consider using the event plugin "Split long entries" (serendipity_event_entrysplit), the description of which is:
I do not know if this plugin increases the 65kb limit Garvin mentioned - I have never used it.Enables you to split longer entries into several subpages and provides you with an auto-generated table of contents
=Don=
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Post is getting cliped before the end
Hi Don!
Actually, sadly this plugin wouldn't help, because the DB storage limit is 65kb.
I now changed s9y 1.6 for new installations to use LONGTEXT by default...
Best regards,
Garvin
Actually, sadly this plugin wouldn't help, because the DB storage limit is 65kb.
I now changed s9y 1.6 for new installations to use LONGTEXT by default...
Best regards,
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/
# 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/
-
- Regular
- Posts: 3652
- Joined: Mon Feb 13, 2006 2:40 am
- Location: Chicago, IL, USA
- Contact:
Re: Post is getting cliped before the end
Can an existing database be modified to use LONGTEXT without upgrading to 1.6 beta? What implications, if any, come with this switch to LONGTEXT? Any search implications?garvinhicking wrote:Hi Don!
Actually, sadly this plugin wouldn't help, because the DB storage limit is 65kb.
I now changed s9y 1.6 for new installations to use LONGTEXT by default...
Best regards,
Garvin
=Don=
-
- Regular
- Posts: 765
- Joined: Tue Oct 17, 2006 2:36 pm
- Location: Vienna/Austria
- Contact:
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Post is getting cliped before the end
Hi!
The database only gets a little bit bigger, other than that, no problems are to be expected.
Regards,
Garvin
The database only gets a little bit bigger, other than that, no problems are to be expected.
Regards,
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/
# 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/
-
- Regular
- Posts: 765
- Joined: Tue Oct 17, 2006 2:36 pm
- Location: Vienna/Austria
- Contact:
Re: Post is getting cliped before the end
2x2bytes per post. i think thats nearly nothing
-
- Regular
- Posts: 3652
- Joined: Mon Feb 13, 2006 2:40 am
- Location: Chicago, IL, USA
- Contact:
Re: Post is getting cliped before the end
Finally found the time to tinker with this today.
Perhaps the upgrade should change body and extended to longtext? I had to do it manually for an existing site that I upgraded to 1.6 beta.
Testing in 2 different templates (one of my complex ones, and also Serendipity 3.0 by Carl)... These templates display the extended body as {$entry.extended}. Despite the change of body and extended to longtext, this smarty variable is still limited to approx 62k characters. However, if directly editing the entry, or viewing the record via phpMyAdmin - the entire entry does exist in the database with the new longtext column type.
Perhaps the upgrade should change body and extended to longtext? I had to do it manually for an existing site that I upgraded to 1.6 beta.
Testing in 2 different templates (one of my complex ones, and also Serendipity 3.0 by Carl)... These templates display the extended body as {$entry.extended}. Despite the change of body and extended to longtext, this smarty variable is still limited to approx 62k characters. However, if directly editing the entry, or viewing the record via phpMyAdmin - the entire entry does exist in the database with the new longtext column type.
=Don=
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Post is getting cliped before the end
Hi!
Your problem might be related to other plugins, like maybe the Caching plugin. The sizes of entrpyoperties still have TEXT columns. For those, changing it to LONGTEXT might be a more considerable size increase, because this field can hold much more entries. I would need to do some research on that before switching it...
Regards,
Garvin
Your problem might be related to other plugins, like maybe the Caching plugin. The sizes of entrpyoperties still have TEXT columns. For those, changing it to LONGTEXT might be a more considerable size increase, because this field can hold much more entries. I would need to do some research on that before switching it...
Regards,
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/
# 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/
-
- Regular
- Posts: 3652
- Joined: Mon Feb 13, 2006 2:40 am
- Location: Chicago, IL, USA
- Contact:
Re: Post is getting cliped before the end
I do believe it is the caching of entries via the extended properties plugin that is causing it to be clipped. If disabled, extended body is no longer truncated. My concern, however, is the performance impact of not using the cached body and extended body.
Let me know what, specifically, you might want to try or test.
Let me know what, specifically, you might want to try or test.
=Don=
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Post is getting cliped before the end
Hi!
Simply set your serendipity_entryproperties DB table to have "value" be also "longtext". (and then re-cache)
Regards,
Garvin
Simply set your serendipity_entryproperties DB table to have "value" be also "longtext". (and then re-cache)
Regards,
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/
# 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/
-
- Regular
- Posts: 3652
- Joined: Mon Feb 13, 2006 2:40 am
- Location: Chicago, IL, USA
- Contact:
Re: Post is getting cliped before the end
That's what my instinct said to do, but you made me nervous with your comment above:garvinhicking wrote:Hi!
Simply set your serendipity_entryproperties DB table to have "value" be also "longtext". (and then re-cache)
Regards,
Garvin
You think it will have much impact?garvinhicking wrote:For those, changing it to LONGTEXT might be a more considerable size increase, because this field can hold much more entries. I would need to do some research on that before switching it...
=Don=
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Post is getting cliped before the end
Hi!
Say you have 2000 blog articles, each one usually has about 4-5 entryproperties. That means you have 10.000 entries inside entryproperties, this would mean an increase of 20kb in your database. That shouldn't be too hard, but before putting it in the official s9y release, we should test it
Regards,
Garvin
As onli indicated, you should get a size increase by multiplicating the number of rows in your serendipity_entryproperties, multiplay it by two, and you should get the new bytes.You think it will have much impact?
Say you have 2000 blog articles, each one usually has about 4-5 entryproperties. That means you have 10.000 entries inside entryproperties, this would mean an increase of 20kb in your database. That shouldn't be too hard, but before putting it in the official s9y release, we should test it
Regards,
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/
# 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/
-
- Regular
- Posts: 3652
- Joined: Mon Feb 13, 2006 2:40 am
- Location: Chicago, IL, USA
- Contact:
Re: Post is getting cliped before the end
I didn't do a "before & after" check of the table/db size.... but it does not sound too bad to me.
Oh, and Judebert committed a patch yesterday to the split entries plugin that corrects errors I reported above. I never have been able to communicate consistently with cvs! SVN is no problem, but cvs has always been a headache!
Oh, and Judebert committed a patch yesterday to the split entries plugin that corrects errors I reported above. I never have been able to communicate consistently with cvs! SVN is no problem, but cvs has always been a headache!
=Don=