1

Topic: Error SQL

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.6
- Linux/BSD distribution name and version: Ubuntu 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- Related log if you're reporting an issue:
====

Error: OperationalError(1055, "Expression #21 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vmail.sender_relayhost.relayhost' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by")

----

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

2

Re: Error SQL

Fixed moment ago, a bug. Sorry about this trouble.

I sent you a patched version moment ago, please follow our upgrade tutorial to upgrade it:
http://www.iredmail.org/docs/migrate.or … admin.html

3

Re: Error SQL

I am having this same issue as the original poster... However I do use apache instead of nginx... Could I please get the patched file also...

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.6
- Linux/BSD distribution name and version: Ubuntu 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Yes
- Related log if you're reporting an issue:
====

Error: OperationalError(1055, "Expression #21 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vmail.sender_relayhost.relayhost' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by")

4

Re: Error SQL

Hi jurmb84,

Sorry about my late reply. Sent an email with patched iRedAdmin-Pro download link to you moment ago, contact us if you didn't receive it:
http://www.iredmail.org/contact.html