OJS upgrade error from 2.4.8.2 to 3.2.1-1

Software Support
1

Hi.

Error while upgrading from 2.4.8.2 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

Regards,
Tarcisio Pereira

2

Hi,

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”/>
…
/table>

3

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.

Regards,
Alec Smecher
Public Knowledge Project Team

1 Like