Error in database migration from ojs 2.4.6 to ojs 3.0.0

Hello, my name is Santiago Parini.

I’m working in Prebi-Sedici (University of La Plata - Argentina), and I’m writing you because when I run the command $php tools/upgrade.php upgrade I get this error:

“ERROR: Upgrade failed: DB: Data truncated for column ‘comment_title’ at row 4”

I get the same error when I try to upgrade from the application.

I’m looking foward for your reply.

Best regards.


Hola, mi nombre es Santiago Parini,

Trabajo en Prebi-Sedici (Universidad de La Plata - Argentina) y les escribo porque cuando ejecuto el comando $php tools/upgrade.php upgrade me sale el siguiente error:

“ERROR: Upgrade failed: DB: Data truncated for column ‘comment_title’ at row 4”

El mismo error me sale cuando intento realizar la migración desde la aplicación.

Espero su respuesta.

Saludos cordiales.

Hi @parinisantiago,

Edit lib/pkp/xml/schema/submissions.xml, and find the line:

<field name="comment_title" type="C2" size="90">

Change it to:

 <field name="comment_title" type="X">

This has already been changed in the github repository for release in the next version of OJS.

Regards,
Alec Smecher
Public Knowledge Project Team