OJS 3.4 to 3.5 upgrade error

Software Support
1

After the news of OJS 3.5 release, we attempted an upgrade in a few machines.

We ran the traditional upgrade process.

We are attempting to upgrade from 3.4.0.9 to 35.

Here’s the error message:
ERROR: Upgrade failed: DB: 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’’)

Also, there’s a PHP Module requested that is no longer available in later PHP version. We are currently on PHP 8 and the required module stopped being shipped in 7.something version…

2

Hi @ramon,

What DBMS are you using? It sounds like you might be encountering this issue:

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

What is the PHP module that you’re asking about?

Regards,
Alec Smecher
Public Knowledge Project Team

4

A post was split to a new topic: Error on upgrade to OJS 3.5

5

Hello all,
This has been fixed in the upgrade.
We’re using MariaDB.

We are running into bcmath.php issue.
How important is the module. This is not available in PHP 8.3.
To be able to upgrade Alexandre had to comment line 12 of lib/pkp/lib/vendor/composer/platform_check.php

We are also experiencing this issue when trying to open the upload plugin page.
Not sure if it’s related.

image
image1920×1050 93.8 KB

6

Hi @ramon,

The bcmath extension is available for PHP8.3 – for example, in my Debian-based system, there’s a php8.3-bcmath package available to install it.

It’s required by the Paypal payment plugin, but if you don’t use that, you shouldn’t run into problems.

For your other question about plugins, could you post that as a new topic (along with the PHP error logs)? That’ll help keep the forum organized.

Regards,
Alec Smecher
Public Knowledge Project Team

7

Hello @asmecher
Unfortunately, that extension is not available for Ubuntu.
We’ve tried multiple reported solutions, but no library shows that version, only previous ones.

8

In Ubuntu 24.04, there is the php-bcmath package:
https://packages.ubuntu.com/noble/php-bcmath

It requires the Universe repository to be active in your APT.

1 Like