1

Topic: Cannot search in latest iredadmin

I'm guessing I missed a step updating something someplace.

When using the "search mail accounts" at the top, I get the following error:

Error: error 'ERROR: column "mailbox.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT mailbox.username, mailbox.name, mailbox.quota, mailbo... ^ ' in 'SELECT mailbox.username, mailbox.name, mailbox.quota, mailbox.employeeid, mailbox.active FROM alias, mailbox WHERE (alias.address LIKE '%%p7%%@%%' OR alias.name LIKE '%%p7%%') AND alias.goto=mailbox.username AND alias.is_alias=1 GROUP BY mailbox.username ORDER BY mailbox.username'


==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.5-1 (admin-pro version 2.4.0)
- Linux/BSD distribution name and version: RHEL6/64
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Yes
- Related log if you're reporting an issue: See above eror
====

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Cannot search in latest iredadmin

Seems a bug of iRedAdmin-Pro PGSQL edition, i will try to reproduce this issue and come back with a patch.