Keywords: General - Amazon Web Services - Technical issue - Other
A few days ago I posted this issue: https://community.bitnami.com/t/multiple-errors-in-latest-aws-zurmo-3-2-3-image/54943/8
I was suggested to apply a workaround which apparently fixed the issue with MySQL 5.7 settings. Actually this is not the case, because today more errors showed up while using other features of Zurmo. Now I can create an account or an opportunity without errors, but then Zurmo crashes every time I try to access the list of accounts or opportunities.
This is the error I could find in application.log, for example when trying to access the list of opportunities:
2018/02/02 17:58:12 [error] [exception.RedBean_Exception_SQL] [HY000] - SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'bitnami_zurmo.opportunity.name' which is not in SELECT list; this is incompatible with DISTINCT
Please note that everything works fine when using the default user (which has super-user permissions), while it doesn't work with any other user I create in Zurmo.
This is starting to be VERY urgent, so please help as soon as possible.
Side note: I noticed you published a new AWS image (version 3.2.3-1-r02), but it doesn't fix either the new issues and the old ones.