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@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@exim4u.org
To unsubscribe send an email to users-leave@exim4u.org