3.4.0.9 to 3.5.0.0 SQL Syntax Error During OJS Upgrade – `email_templates_default_data` Table (MariaDB)

Software Support
1

Describe the issue or problem
3.4.0.9 to 3.5.0.0
SQL Syntax Error During OJS Upgrade – email_templates_default_data Table (MariaDB)

What application are you using?
For example, OJS 3.4.0-9 to 3.5.0.0

Additional information
Dear PKP Support Team,

We are experiencing a database error during the upgrade process of OJS via Softaculous. The upgrade fails with the following SQL syntax error:

A database error has occurred: SQLSTATE[42000]: Syntax error or access violation: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '''' at line 1 
(Connection: mysql, SQL: alter table `email_templates_default_data` modify `locale` varchar(28) not null default ''en'')

This appears to be an issue with the SQL statement generated for altering the locale column in the email_templates_default_data table. Our environment uses MariaDB, and this error is blocking the upgrade process.

2

Hi @Nive,

It looks like you’re encountering this known issue:

https://github.com/pkp/pkp-lib/issues/11529

There’s a patch there to resolve it, and a fix will be released in the next build (3.5.0-1).

Regards,
Alec Smecher
Public Knowledge Project Team

4

thanks for the update