[OJS3.0.1] 'Upgrade' script fails constantly

Software Support
,
1

Hi!

When trying to run the ‘upgrade’ script we get the following error:

root@ojs:/var/www/html# php tools/upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 3.0.1.0]
[schema: lib/pkp/xml/schema/common.xml]
ERROR: Upgrade failed: DB: ERROR: type “serial” does not exist

PS: We are on PostgreSQL 9.5. Might it be safer for us to install MySQL instead?

2

Hi @Ph_We,

There’s a patch linked from this thread that should resolve the issue – but we’re unlikely to merge that change into the distributed codebase because it would represent a modification to third-party code.

We do support both MySQL and PostgreSQL, but if you have the option, I’d recommend using MySQL. It’s a much more common configuration.

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hi @asmecher,

Thanks! That really helped a lot. With MySQL it runs much better.

4

Hi @Ph_We,

Our continuous integration tests run successfully with PostgreSQL, but they don’t provide complete coverage, unfortunately.

Regards,
Alec Smecher
Public Knowledge Project Team