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 »

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

What's causing it, and how can I fix it?
onli
Regular
Posts: 2825
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

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

Post by onli »

For me that does not ring a bell. Do you have access to the server/php log, does it give a bit more context?
erAck
Regular
Posts: 236
Joined: Mon Feb 16, 2015 1:20 am

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

Post by erAck »

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..
onli
Regular
Posts: 2825
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

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

Post by onli »

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