Sidney Markowitz skrev den 2023-01-03 22:24:
Benny Pedersen wrote on 4/01/23 3:19 am:
https://github.com/apache/spamassassin/blob/trunk/lib/Mail/SpamAssassin/SQLBasedAddrList.pm#L310
imho this line
I agree, but I don't see from looking at that line how the SQL query
can have more than one table involved, and from the description of
what "column reference is ambiguous" means I don't see how a query
with one table in it can get a column reference is ambiguous error.
https://github.com/apache/spamassassin/blob/trunk/lib/Mail/SpamAssassin/SQLBasedAddrList.pm#L289
$sql .= " ON CONFLICT (username, email, signedby, ip) DO UPDATE set
msgcount = ?, totscore += ?";
confirm is from my side needed it would fix it, i atleast like to think
it does
there is more lines with totscore = totscore that might need fix aswell
