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
