Upgrading to OJS 3.0 from 2.4.8 : Postgres text = bigint failure

Hi, I’m running into an issue I’m hoping I might get a little insight.
I’ve setup an instance using version 3.0.1 using the zip file, copied over the files and public folder from our 2.4.8 instance, as well as the 2.4.8 Postgres database.

The new instance (3.0.1) is using PHP 5.5.38 and Postgres 9.1.24

When I run the php tools/upgrade.php upgrade script I get the following error during upgrade to the database:

[code: Installer Installer::setFileUploader]

[code: Installer Installer::setFileName]
[data: dbscripts/xml/upgrade/3.0.0_postupdate.xml]
[data: dbscripts/xml/upgrade/3.0.0_pubId_settings.xml]
[data: dbscripts/xml/upgrade/3.0.0_postupgrade_galley_files.xml]
[data: dbscripts/xml/upgrade/3.0.0_postupgrade_metrics.xml]
ERROR: Upgrade failed: DB: ERROR: operator does not exist: text = bigint
LINE 1: …etting_name = ‘old-supp-id’ AND sfs.setting_value = m.assoc_…
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

What would be the recommended path to deal with this issue?



Hi @darrylc1,

Is there any particular reason you’re using OJS 3.0.1 instead of 3.0.2? I’d suggest using 3.0.2 if possible.

Alec Smecher
Public Knowledge Project Team

Hi Alec. I’ll give it a go with OJS 3.0.2. Thanks for the quick response !



Thanks Alec, I tried with version 3.0.2 and was able to complete the upgrade.

Many thanks for your suggestion.


1 Like