Page 1 of 1
ERROR: value too long for type character varying(12)
Posted: Thu Mar 11, 2021 12:54 pm
by ps123
This error suddenly popped up when I went to the blog.
What's causing it, and how can I fix it?
Re: ERROR: value too long for type character varying(12)
Posted: Thu Mar 11, 2021 9:42 pm
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?
Re: ERROR: value too long for type character varying(12)
Posted: Fri Mar 12, 2021 12:08 am
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..
Re: ERROR: value too long for type character varying(12)
Posted: Sun Mar 14, 2021 9:54 pm
by onli
I just saw
https://github.com/s9y/Serendipity/issues/746 again, which could be the same bug?