Date Base Error in OJS 3

Software Support
1

I installed version OJS 3.12. All is ok. But the link “Archives” generate this error:

DB Error: ERROR: column “i.journal_id” must appear in the GROUP BY clause or be used in an aggregate function LINE 1: select “i”.* from “issues” as “i” left join “issue_settings”… ^

(The Date Base is PostgreSQL)

Thanks.
C.-

2

Hi @Claudio_Aguero,

Can you try turning on the show_stacktrace option in config.inc.php, reloading the archive page, and posting the resulting stack trace here?

Regards,
Alec Smecher
Public Knowledge Project Team

3

Thanks, This is the problem…

4

Hi @Claudio_Aguero,

What version of PostgreSQL are you using?

Regards,
Alec Smecher
Public Knowledge Project Team