OMP 3.1.1.4 on PHP 7.0.30

Software Support Open Monograph Press
1

Hi,

Is OMP 3.1.1.4 supported on PHP 7.0.30? I have tried to install it and from the first look something is working. But when going on Catalog (in the dashboard) or clicking on a series (I have created) I get the error:

DB Error: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘omp.psf.seq’ which is not in SELECT list; this is incompatible with DISTINCT

Any idea how to fix this?

Regards, Primož

2

Hi @vvucic,

If I found correctly you have some experiences with OJS on PHP 7. Can you help here with OMP as well?

Regards, Primož

3

The issue you experienced is not related to PHP I guess but with database glitch. That is rather issue with version of MySQL.
Please check these links maybe they can help:

Which version of MySQL you use?

1 Like
4

Hi @vvucic,

Thank you for the hint. I am using MySQL 5.7.22-0ubuntu0.16.04.1 and have been so far focused on the PHP version. Will look into your links and let you know the results.

Best regards, Primož