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
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
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>
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