On 09/09/11 18:38, Erwan David wrote: > I use dspam from debian wheezy with a postgresql backend, yesterday I > upgraded postgresql from 9.0 to 9.1, since then I cannot retrain mails. > When I try to do it (from web interface) mail still appears as innocent. > > There where sql errors > [09/09/2011 13:32:34] 2674: : SELECT > coalesce(substring(split_part(split_part(version(),' ',2),'.',3) FROM > E'\\d+')::int2,0) > > untill I restarted dspam and postgresql > > However retraining still seems to not work.
I found this in postgresql log: 2011-09-15 21:55:42 CEST ERROR: duplicate key value violates unique constraint "dspam_token_data_uid_token_key" 2011-09-15 21:55:42 CEST DETAIL: Key (uid, token)=(1, 3908037574888045901) already exists. 2011-09-15 21:55:42 CEST STATEMENT: PREPARE dspam_update_plan (bigint) AS UPDATE dspam_token_data SET last_hit=CURRENT_DATE,innocent_hits=innocent_hits+1 WHERE uid=1 AND token=$1;PREPARE dspam_insert_plan (bigint,int,int) AS INSERT INTO dspam_token_data (uid,token,spam_hits,innocent_hits,last_hit) VALUES (1,$1,$2,$3,CURRENT_DATE); DOes this mean something to someone ? ------------------------------------------------------------------------------ Doing More with Less: The Next Generation Virtual Desktop What are the key obstacles that have prevented many mid-market businesses from deploying virtual desktops? How do next-generation virtual desktops provide companies an easier-to-deploy, easier-to-manage and more affordable virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/ _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
