This error suddenly popped up when I went to the blog.
What's causing it, and how can I fix it?
ERROR: value too long for type character varying(12)
Re: ERROR: value too long for type character varying(12)
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)
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..
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..
Running s9y at https://erack.net/blog/
Re: ERROR: value too long for type character varying(12)
I just saw https://github.com/s9y/Serendipity/issues/746 again, which could be the same bug?