On Mon, Oct 24, 2011 at 11:11:06PM CEST, Tom Hendrikx <t...@whyscream.net> said: > On 01-10-11 11:53, Stevan Bajic wrote: > > On 29.09.2011 11:14, Erwan David wrote: > >> On 15/09/11 21:57, Erwan David wrote: > >>> 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 ? > >>> > >>> > >> It seems like a monologue, but here are latest news : > >> > >> it is indeed a bug in dspam postgresql driver, but which was not seen > >> before 9.1 because of a different default setting > >> > >> (see > >> http://sourceforge.net/tracker/?func=detail&atid=1126467&aid=3413998&group_id=250683) > >> > >> workaround is to set default setting to former one waiting for new > >> version of postgresql driver. > > > > Could you try the latest GIT version of DSPAM and tell me if the problem > > still exists? > > > > Changes seem to work as intended when used with postgresql 9.0.5 with > standard_conforming_strings=on
Thanks, I still not had time to compile a new dspam (I use debian package) for testing. ------------------------------------------------------------------------------ The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
