Benny Pedersen wrote on 3/01/23 2:21 pm:
https://github.com/apache/spamassassin/blob/trunk/sql/awl_pg.sql#L6 https://www.irccloud.com/pastebin/wRkT4AeI/awl.sql how to solve it ?
The sql error means that there is more than one table in the sql statement that has a column named "totscore" and so where the command references "totscore" without using a syntax like tablename.totscore to specify which table it means is ambiguous.
However, I don't see any definition of a table with a column named totscore other than the one in table "awl" that you linked to. And the full SQL query string is not in the snippet in your pastebin, that is truncated
dbg: auto-welcomelist: [...] LINE 1: ...edby, ip) DO UPDATE set msgcount = $6, totscore = totscore +...
If you can get the entire SQL command that is in that dbg output, without truncation, it might be more obvious what is going on. Looking at the source code in SQLBasedAddrList.pm, I don't see how the SQL query that it generates can have any ambiguity as to which table totscore refers to, there is just that one table as far as I can tell.
If you can't get the full dbg line, perhaps someone who actually uses SQL based awl might be able to jump in here, that's the limit of what I can figure out.