Length of text

Found a bug? Tell us!!
Post Reply
User avatar
Fabien
Regular
Posts: 172
Joined: Wed Mar 15, 2006 2:02 pm
Location: Paris (France)
Contact:

Length of text

Post by Fabien » Mon Apr 15, 2019 6:24 am

Hi,

Not really a bug but this morning, I had a very bad surprise. Yesterday, I wrote a long entry, saved it and go to sleep very happy! This morning, I opened the entry to correct it and add some new ideas and… a part of my work of yesterday had disappeared.

I know that the problem is the MySql text field that has a size limited to 64KB. This is small, specially with UTF8.

Is it possible to have S9Y use MEDIUMTEXT for the body and extended fields of table "entries" in a next version? Or is it possible to have S9Y sending an alert when the text exceed the autorised size?
Is there a solution usable now, other than splitting my text in several entries?

Thanks. Have a nice day.
Fabien

Bonbon
Posts: 1
Joined: Thu Jul 25, 2019 1:32 am
Contact:

Re: Length of text

Post by Bonbon » Fri Aug 09, 2019 6:51 am

Let me quote this: "A reliable, secure & extensible PHP blog... Serendipity stands for Reliability We want to provide a blog engine that users can trust"

And then: "This morning, I opened the entry to correct it and add some new ideas and… a part of my work of yesterday had disappeared." Probably you should trust this highly reliable blog engine a little bit less and store your drafts somewhere else (Word, for instance).

thh
Regular
Posts: 321
Joined: Thu Oct 26, 2006 2:38 pm
Location: Stuttgart, Germany
Contact:

Re: Length of text

Post by thh » Fri Aug 09, 2019 8:32 am


thh
Regular
Posts: 321
Joined: Thu Oct 26, 2006 2:38 pm
Location: Stuttgart, Germany
Contact:

Re: Length of text

Post by thh » Fri Aug 09, 2019 9:53 pm

Fabien wrote:
Mon Apr 15, 2019 6:24 am
I know that the problem is the MySql text field that has a size limited to 64KB. This is small, specially with UTF8.

Is it possible to have S9Y use MEDIUMTEXT for the body and extended fields of table "entries" in a next version?
Since version 1.6 (released 2011-10-27), all new installation should already use LONGTEXT.

I'm not sure if there was an upgrade script included to change existing installations ... it's quite long ago.

Perhaps you could just change the column type of "body" and "extended" in the s9y_entries database to LONGTEXT yourself, in your installation? That would be the easiest solutin I can think of ...

User avatar
Fabien
Regular
Posts: 172
Joined: Wed Mar 15, 2006 2:02 pm
Location: Paris (France)
Contact:

Re: Length of text

Post by Fabien » Sat Aug 10, 2019 7:19 am

Hi thh,

I am a happy user of Serendipity since 2003! And I am using V2.3 Beta 1 so I can confirm that the upgrade scripts do not change the size of the entries to LONGTEXT.

In the 2.3 official release?

Thanks for your answer.
Cheers, Fabien
Fabien Chabreuil (blog)

thh
Regular
Posts: 321
Joined: Thu Oct 26, 2006 2:38 pm
Location: Stuttgart, Germany
Contact:

Re: Length of text

Post by thh » Sun Aug 11, 2019 12:23 pm

Fabien wrote:
Sat Aug 10, 2019 7:19 am
I am a happy user of Serendipity since 2003!
Good to hear! :D
Fabien wrote:
Sat Aug 10, 2019 7:19 am
And I am using V2.3 Beta 1 so I can confirm that the upgrade scripts do not change the size of the entries to LONGTEXT.
Yeah, that should have been done about 8 years ago when the change was made ...

I'm not so sure about adding an upgrade job now, as most installations will have been updated (or reinstalled) since then. Wouldn't it be possible for you to change your own database structure by hand?

User avatar
Fabien
Regular
Posts: 172
Joined: Wed Mar 15, 2006 2:02 pm
Location: Paris (France)
Contact:

Re: Length of text

Post by Fabien » Sun Aug 11, 2019 12:59 pm

Yes of course, I will do the change by hand.

Warm regards,
Fabien
Fabien Chabreuil (blog)

thh
Regular
Posts: 321
Joined: Thu Oct 26, 2006 2:38 pm
Location: Stuttgart, Germany
Contact:

Re: Length of text

Post by thh » Sun Aug 11, 2019 4:57 pm

Fabien wrote:
Sun Aug 11, 2019 12:59 pm
Yes of course, I will do the change by hand.
Thanks! :D

Post Reply