Hi Holger, Sorry but I have not yet upgraded to Exim 4.95 or MySql 8. Nevertheless, I am sure that I will be upgrading within a few months. Please let us know what you finally determine is the problem and how that you fix it so that the rest of us can benefit from your experience. Thanks! Gordon Dickens On 4/13/23 00:46, Holger Glaess wrote:
hi
i get the error bellow since the update to exim 4.95 and mysql8.
i remove just the orginal names and ips from log.
everthing was fine befor the update ( i had to move to mysql 8 due the old mysql version was outdated. )
any hint for me to fix this ?
Holger
2023-04-13 05:17:16 failed to expand "${if eq{Y}{${lookup mysql{select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = '${quote_mysql:$domain}' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = '${quote_mysql:$local_part}'}}} {$sender_address} {${lookup mysql{select u.username from domains d, groups g, group_contents c, users u where d.enabled = '1' and d.domain = '${quote_mysql:$domain}' and d.domain_id = g.domain_id and g.name = '${quote_mysql:$local_part}' and g.enabled = '1' and g.is_public = 'N' and c.member_id = u.user_id and d.domain_id = u.domain_id and u.enabled = '1' and u.username = '${quote_mysql:$sender_address}' }}}}" while checking a list: lookup of "select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = 'oneworlddapp.de' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = 'r.maehnhoefer'" gave DEFER: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g, domains d where d.enabled = '1' and d.domain = 'xxxxxx.de' and d' at line 1
2023-04-13 05:17:16 H=xx-xx.xx.de [xx.xx.xx.xx] X=TLS1.3:TLS_AES_256_GCM_SHA384:256 CV=no F=<> temporarily rejected RCPT <yyyyy(a)xxxxxxx.de>: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g, domains d where d.enabled = '1' and d.domain = 'xxxxxxxxx.de' and d' at line 1
_______________________________________________ users mailing list -- users(a)exim4u.org To unsubscribe send an email to users-leave(a)exim4u.org