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