Postgres 9.6: "ERROR: type 'serial' does not exist"

When upgrading from OJS 3.0.0 to 3.0.2, I get the following error:

/var/log/postgresql-9.6:ERROR:  type "serial" does not exist

I didn’t have any database problems with pgsql 9.4, so this seems to be something specific to pgsql 9.6.

I was getting similar issues, which I detailed here.

Hi @Geremia,

See e.g. this thread: Upgrade failure (Postgresql)

Alec Smecher
Public Knowledge Project Team