[GH-ISSUE #60] Postgresql statement errors after setup #49

New issue

Closed

opened 2026-02-26 09:35:26 +03:00 by kerem · 0 comments

kerem commented

2026-02-26 09:35:26 +03:00

Owner

Originally created by @barryo on GitHub (Feb 17, 2014).
Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/60

Domains:

2014-02-16 18:17:56 CET ERROR:  column "m1_.delete_pending" must appear in the GROUP BY clause or be used in an aggregate function at character 375
2014-02-16 18:17:56 CET STATEMENT:  SELECT d0_.id AS id0, d0_.domain AS domain1, d0_.alias_count AS alias_count2, d0_.mailbox_count AS mailbox_count3, d0_.max_aliases AS max_aliases4, d0_.max_mailboxes AS max_mailboxes5, SUM(m1_.maildir_size) AS sclr6, d0_.max_quota AS max_quota7, d0_.quota AS quota8, d0_.transport AS transport9, d0_.backupmx AS backupmx10, d0_.active AS active11, d0_.created AS created12, m1_.delete_pending AS delete_pending13 FROM domain d0_ LEFT JOIN mailbox m1_ ON d0_.id = m1_.Domain_id GROUP BY d0_.id ORDER BY d0_.domain ASC

Mailboxes:

2014-02-16 18:18:37 CET ERROR:  operator does not exist: boolean = integer at character 359
2014-02-16 18:18:37 CET HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
2014-02-16 18:18:37 CET STATEMENT:  SELECT m0_.id AS id0, m0_.username AS username1, m0_.name AS name2, m0_.active AS active3, m0_.maildir_size AS maildir_size4, m0_.homedir_size AS homedir_size5, m0_.size_at AS size_at6, m0_.quota AS quota7, d1_.domain AS domain8, m0_.delete_pending AS delete_pending9 FROM mailbox m0_ INNER JOIN domain d1_ ON m0_.Domain_id = d1_.id WHERE m0_.delete_pending = 0

The other pages work only domain and mailbox is doing problems.

Originally created by @barryo on GitHub (Feb 17, 2014). Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/60 Domains: ``` 2014-02-16 18:17:56 CET ERROR: column "m1_.delete_pending" must appear in the GROUP BY clause or be used in an aggregate function at character 375 2014-02-16 18:17:56 CET STATEMENT: SELECT d0_.id AS id0, d0_.domain AS domain1, d0_.alias_count AS alias_count2, d0_.mailbox_count AS mailbox_count3, d0_.max_aliases AS max_aliases4, d0_.max_mailboxes AS max_mailboxes5, SUM(m1_.maildir_size) AS sclr6, d0_.max_quota AS max_quota7, d0_.quota AS quota8, d0_.transport AS transport9, d0_.backupmx AS backupmx10, d0_.active AS active11, d0_.created AS created12, m1_.delete_pending AS delete_pending13 FROM domain d0_ LEFT JOIN mailbox m1_ ON d0_.id = m1_.Domain_id GROUP BY d0_.id ORDER BY d0_.domain ASC ``` Mailboxes: ``` 2014-02-16 18:18:37 CET ERROR: operator does not exist: boolean = integer at character 359 2014-02-16 18:18:37 CET HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. 2014-02-16 18:18:37 CET STATEMENT: SELECT m0_.id AS id0, m0_.username AS username1, m0_.name AS name2, m0_.active AS active3, m0_.maildir_size AS maildir_size4, m0_.homedir_size AS homedir_size5, m0_.size_at AS size_at6, m0_.quota AS quota7, d1_.domain AS domain8, m0_.delete_pending AS delete_pending9 FROM mailbox m0_ INNER JOIN domain d1_ ON m0_.Domain_id = d1_.id WHERE m0_.delete_pending = 0 ``` The other pages work only domain and mailbox is doing problems.