-------- Original-Nachricht -------- Datum: Tue, 24 Jul 2007 12:54:04 -0700 Von: Dspam User <[EMAIL PROTECTED]> An: [email protected] Betreff: Re: [dspam-users] Dspam query error???
> Hi Steve, > Hallo Alex > Thanks for your reply. > Here are my dspam.conf entries for algorithm, tokenizer and pvalue > > Algorithm graham burton > Tokenizer chain > PValue bcr > This looks okay to me. I am surprised to see this here: '<95>^[tË^?^C^A\0\0\0Ç3Yg2^×á^A\0\0\0ÍÕÆÒ^F^X6 > > ^A\0\0\0^R^FU¨òôB<8b>^A\0\0\0(mö4<9d>&~<89>^A\0\0\06^NG<9a>&ñÎ' This looks ultra strange to me. DSPAM does not write binary data to MySQL. At least not in that way. What do you get if you execute this on your server: mysql --user=root --host=localhost -p -e "show create table dspam.dspam_preferences;show create table dspam.dspam_signature_data;show create table dspam.dspam_stats;show create table dspam.dspam_token_data;show create table dspam.dspam_virtual_uids;show variables where variable_name like '%character%' or variable_name like '%collation%' or variable_name like '%lc_time_names%';" > Thanks in advance for any help. > No problem. > Alex > Steve > > On Tuesday 24 July 2007 12:53, [EMAIL PROTECTED] wrote: > > -------- Original-Nachricht -------- > > Datum: Tue, 24 Jul 2007 11:02:53 -0700 > > Von: Dspam User <[EMAIL PROTECTED]> > > An: [email protected] > > Betreff: [dspam-users] Dspam query error??? > > > > > Hello, > > > > Hello > > > > > I've installed 3.8.0-STABLE Release onto my Linux OpenSUSE 10.2 Mail > > > server. > > > Everything went OK, except this annoying message in dspam.log > > > > > > < quoted> > > > query error: Unknown column '1,46a63dea156844747916253' in 'where > > > clause': see > > > sql.errors for more details > > > query error: You have an error in your SQL syntax; check the manual > that > > > corresponds to your MySQL server version for the right syntax; check > the > > > manual that corresponds to your MySQL server version for the right > synta > > > x to use near > '<95>^[tË^?^C^A\0\0\0Ç3Yg2^×á^A\0\0\0ÍÕÆÒ^F^X6 > > > ^A\0\0\0^R^FU¨òôB<8b>^A\0\0\0(mö4<9d>&~<89>^A\0\0\06^NG<9a>&ñÎ' > at > > > line 1: > > > see sql.errors for more de tails > > > _ds_set_signature() failed with error -5 > > > </quoted> > > > > This looks strange. What algorithm, tokenizer and pvalue are you using? > > > > > Could somebody tell me please how to correct this. If it's a Dspam > bug, > > > as I > > > suspect, will it prohibit Dspam from its normal functioning? > > > > > > Thank you in advance, > > > > > > Alex > > > > // SteveB -- Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten Browser-Versionen downloaden: http://www.gmx.net/de/go/browser
