Tweet
Ever since upgrading to 5.7.3 email lookups are not working for me!
When trying to type in to the fields "To", "CC" or "BCC" I see this in the below logs.
[2019-10-17 18:12:00] Espo.DEBUG: API (HY000) SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'bitnami_espocrm.user.first_name' which is not in SELECT list; this is incompatible with DISTINCT; GET /espocrm/api/v1/EmailAddress/action/searchInAddressBook?onlyActual=true&maxSize=20&q=a ; Route pattern: /:controller/action/:action; Route params: Array ( [controller] => EmailAddress [action] => searchInAddressBook ) [] []
[2019-10-17 18:12:00] Espo.ERROR: (HY000) SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'bitnami_espocrm.user.first_name' which is not in SELECT list; this is incompatible with DISTINCT; GET /espocrm/api/v1/EmailAddress/action/searchInAddressBook?onlyActual=true&maxSize=20&q=a ; line: 132, file: /var/www/espocrm/application/Espo/ORM/DB/Mapper.php [] []
When trying to type in to the fields "To", "CC" or "BCC" I see this in the below logs.
[2019-10-17 18:12:00] Espo.DEBUG: API (HY000) SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'bitnami_espocrm.user.first_name' which is not in SELECT list; this is incompatible with DISTINCT; GET /espocrm/api/v1/EmailAddress/action/searchInAddressBook?onlyActual=true&maxSize=20&q=a ; Route pattern: /:controller/action/:action; Route params: Array ( [controller] => EmailAddress [action] => searchInAddressBook ) [] []
[2019-10-17 18:12:00] Espo.ERROR: (HY000) SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'bitnami_espocrm.user.first_name' which is not in SELECT list; this is incompatible with DISTINCT; GET /espocrm/api/v1/EmailAddress/action/searchInAddressBook?onlyActual=true&maxSize=20&q=a ; line: 132, file: /var/www/espocrm/application/Espo/ORM/DB/Mapper.php [] []
Attached Files
Comment