On 24.04.13 17:01, psychobyte wrote:
in the bayes case, the table is bayes_token and indeed
Mail::SpamAssassin::BayesStore::SQL is INSERTING into the table via
_put_tokens().
my $insertsql = "INSERT INTO bayes_token
(id, token, spam_count, ham_count, atime)
VALUES (?,?,?,?,?)";
so, as you said earlier, INSERT INTO should be a REPLACE INTO.
I don't think so... IIRC the "REPLACE INTO" deletes existing record and
inserts new one, does not update existing. This caused some issues for me
some ~10 years ago, so i switched to the update or insert.
There's possibility for processing the same spam mail to different
recipients in parallel. It could also be problem of case sensitiveness.
Would need to take look into the database...
--
Matus UHLAR - fantomas, uh...@fantomas.sk ; http://www.fantomas.sk/
Warning: I wish NOT to receive e-mail advertising to this address.
Varovanie: na tuto adresu chcem NEDOSTAVAT akukolvek reklamnu postu.
Support bacteria - they're the only culture some people have.
