OJS upgrade error from to 3.2.1-1


Error while upgrading from yo 3.2.1-1 using MySql this time:

[data: dbscripts/xml/upgrade/3.2.0_versioning.xml]
ERROR: Upgrade failed: DB: Data too long for column ‘setting_value’ at row 1

Tarcisio Pereira


Solved by editing the type in the descriptor. Find the table description in “lib/pkp/xml/schema/submissions.xml”:

table name=“publication_settings”>

field name=“setting_value” type=“XL”/>


Hi @Tarcisio_Pereira,

That’ll resolve the issue for the moment, but I’d recommend reviewing what data in the publication_settings column exceeds your size limits – it may be a spam attempt or something.

Alec Smecher
Public Knowledge Project Team

1 Like