Error when click sub-menu archives

hello,
i have problem with my archives.
when i click, i got message like this :

DB Error: ERROR: column “o.seq” must appear in the GROUP BY clause or be used in an aggregate function LINE 1: …published" = $2 group by “i”.“issue_id” order by “o”.“seq” … ^

can u help me, please ?
i installed on DB Postgres 10.

Thank you.

Hi @Vi_gates,

Can you specify what OJS version you are using?
Particularly this issue was fixed a while ago and should be applied for new OJS release: [OJS] Fix for #3705 breaks archives with PostgreSQL · Issue #4097 · pkp/pkp-lib · GitHub
Can you confirm that you are sugin OJS 3.1.2 and this issue persists?

I’m trying in OJS 3.1.2, the same error in a clean installation, but the fix works…

1 Like