My issue/archive page return the following error (debug on)
(postgres7): select “i”.* from “issues” as “i” left join “issue_settings” as “is” on “i”.“issue_id” = “is”.“issue_id” left join “custom_issue_orders” as “o” on “o”.“issue_id” = “i”.“issue_id” where “i”.“journal_id” = ? and “i”.“published” = ? group by “i”.“issue_id” order by “o”.“seq” asc LIMIT 25 OFFSET 0 [ (0=>'1') (1=>'1') ] -1: 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” … ^
ADOConnection._Execute(select “i”.* from “issues” as “i” left join “issue_settings” as “is” on “i”.“issue_id” = “is”.“issue_id” left join "custom_issue…, Array[2]) % line 1047, file: [adodb.inc.php](file://var/www/html/pkp/lib/pkp/lib/adodb/adodb.inc.php) ADOConnection.Execute(select “i”.* from “issues” as “i” left join “issue_settings” as “is” on “i”.“issue_id” = “is”.“issue_id” left join "custom_issue…, Array[2]) % line 97, file: [adodb-postgres7.inc.php](file://var/www/html/pkp/lib/pkp/lib/adodb/drivers/adodb-postgres7.inc.php) ADODB_postgres7.SelectLimit(select “i”.* from “issues” as “i” left join “issue_settings” as “is” on “i”.“issue_id” = “is”.“issue_id” left join "custom_issue…, 25, 0, Array[2]) % line 193, file: [DAO.inc.php](file://var/www/html/pkp/lib/pkp/classes/db/DAO.inc.php) DAO.retrieveRange(select “i”.* from “issues” as “i” left join “issue_settings” as “is” on “i”.“issue_id” = “is”.“issue_id” left join "custom_issue…, Array[2], Object:DBResultRange) % line 56, file: [IssueService.inc.php](file://var/www/html/pkp/classes/services/IssueService.inc.php) OJS\Services\IssueService.getIssues(1, Array[5]) % line 137, file: [IssueHandler.inc.php](file://var/www/html/pkp/pages/issue/IssueHandler.inc.php)