Sidney Markowitz wrote on 4/01/23 8:47 pm:
There's a typo, which must just be in your email since postgres won't
accept it, that should be =+ not +=
I am not expert it SQL :)
Further testing reveals that there is no auto-increment operator in
postgres or SQLite SQL, neither += nor =+
The
Benny Pedersen wrote on 4/01/23 11:00 am:
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
Ángel wrote on 4/01/23 2:59 pm:
On 2023-01-04 at 10:24 +1300, Sidney Markowitz wrote:
If anyone else reading this is using 4.0.0 and postgres for AWL, are
you seeing or not seeing this problem?
I can easily reproduce this with a quick install and manually providing
the SQL from the code
On 2023-01-03 at 23:00 +0100, Benny Pedersen wrote:
> 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
On 2023-01-04 at 10:24 +1300, Sidney Markowitz wrote:
> If anyone else reading this is using 4.0.0 and postgres for AWL, are
> you seeing or not seeing this problem?
I can easily reproduce this with a quick install and manually providing
the SQL from the code (output included below). Postgresql
On Wed, 2023-01-04 at 00:43 +0100, Benny Pedersen wrote:
>
> i have dumped all i have in posgres without data so only structure is
> here
>
> https://usercontent.irccloud-cdn.com/file/WJmDq7xc/spamassassin_dump_tables%20only.txt
>
> dont know what package means on gentoo, its stable versions i
Martin Gregorie skrev den 2023-01-03 23:43:
On Wed, 2023-01-04 at 10:24 +1300, Sidney Markowitz wrote:
Benny Pedersen wrote on 4/01/23 3:19 am:
If anyone else reading this is using 4.0.0 and postgres for AWL, are
you
seeing or not seeing this problem?
I use Postgresql, though not with SA.
I
On Wed, 2023-01-04 at 10:24 +1300, Sidney Markowitz wrote:
> Benny Pedersen wrote on 4/01/23 3:19 am:
>
> If anyone else reading this is using 4.0.0 and postgres for AWL, are
> you
> seeing or not seeing this problem?
>
I use Postgresql, though not with SA.
I agree with your suggestion, but it
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
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
Sidney Markowitz skrev den 2023-01-03 10:53:
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
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"
>
> https://github.com/apache/spamassassin/blob/trunk/sql/awl_pg.sql#L6
>
> https://www.irccloud.com/pastebin/wRkT4AeI/awl.sql
>
> how to solve it ?
https://notepad.ltd/asdf23423asdfasdf ;)
https://github.com/apache/spamassassin/blob/trunk/sql/awl_pg.sql#L6
https://www.irccloud.com/pastebin/wRkT4AeI/awl.sql
how to solve it ?
14 matches
Mail list logo
