ERROR: value too long for type character varying(12)

Found a bug? Tell us!!
Post Reply
ps123
Posts: 1
Joined: Thu Mar 11, 2021 12:50 pm

ERROR: value too long for type character varying(12)

Post by ps123 » Thu Mar 11, 2021 12:54 pm

This error suddenly popped up when I went to the blog.

What's causing it, and how can I fix it?

User avatar
onli
Regular
Posts: 2495
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

Re: ERROR: value too long for type character varying(12)

Post by onli » Thu Mar 11, 2021 9:42 pm

For me that does not ring a bell. Do you have access to the server/php log, does it give a bit more context?

User avatar
erAck
Regular
Posts: 171
Joined: Mon Feb 16, 2015 1:20 am

Re: ERROR: value too long for type character varying(12)

Post by erAck » Fri Mar 12, 2021 12:08 am

sql/db.sql lists only two fields with varchar(12), both in table {PREFIX}pluginlist:
version
upgrade_version

Something may be trying to write a record without specifying an explicit column/field list and gives values shifted / out of order so a longer content is attempted to be written there. Though I don't see why merely visiting the blog would write to pluginlist at all, unless available upgrades are written there on any occasion, in which case also an upgrade_version string could trigger that.

Just a quick idea..

User avatar
onli
Regular
Posts: 2495
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

Re: ERROR: value too long for type character varying(12)

Post by onli » Sun Mar 14, 2021 9:54 pm

I just saw https://github.com/s9y/Serendipity/issues/746 again, which could be the same bug?

Post Reply