OMP Upgrade Error

I just attempted an upgrade from OMP to

The messages in the DB upgrade script were fine but when I try to access the catalog I get the following error:
“DB Error: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘DBNAME.psf.seq’ which is not in SELECT list; this is incompatible with DISTINCT”.

The version continues to works fine despite the alleged upgrade.
The version returns the error above on the catalog page.

I can provide additional information from error logs privately if someone can help me with this.

Thank you!

I have just finished trying to upgrade the versions one by one: to to to to to

The system also broke while upgrading from to

I’m pretty happy to be running but there’s definitely something wrong with the latest version.

1 Like

I found a solution with the instructions on this stackoverflow post


Hi all,

This may well have been fixed with OMP 3.1.2-1 – can someone confirm whether they are still encountering the issue there?

Alec Smecher
Public Knowledge Project Team