OMP Upgrade Error

Software Support Open Monograph Press
1

I just attempted an upgrade from OMP 3.1.0.0 to 3.1.1.4.

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 3.1.0.0 version continues to works fine despite the alleged upgrade.
The 3.1.1.4. 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!

2

I have just finished trying to upgrade the versions one by one: 3.1.0.0 to 3.1.1.0 to 3.1.1.1 to 3.1.1.2 to 3.1.1.3 to 3.1.1.4.

The system also broke while upgrading from 3.1.1.3 to 3.1.1.4

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

1 Like
3

hi,
I found a solution with the instructions on this stackoverflow post

bye
alfredo

4

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?

Regards,
Alec Smecher
Public Knowledge Project Team