Re: [Dspam-user] dspam GIT: dspam_stats sql error???
Brought to you by:
paulcockings,
sbajic
From: Peter S. <pe...@ps...> - 2011-07-18 17:25:15
|
On 7/19/2011 12:52 AM, Stevan Bajić wrote: [snip] >> Entries in sql.log >> >> [07/18/2011 22:45:28] 478: You have an error in your SQL syntax; check >> the manual that corresponds to your MySQL server version for the right >> syntax to use near ' FROM Ðè WHERE IgnoreHeader='dspam'' at line 1: >> SELECT 8 FROM Ðè WHERE IgnoreHeader='dspam' >> > That is strange. We never query IgnoreHeader from the storage backend. NEVER! > > >> [07/18/2011 22:48:43] 547: You have an error in your SQL syntax; check >> the manual that corresponds to your MySQL server version for the right >> syntax to use near 'FROM dspam_virtual_uids WHERE >> username='pet...@ps...'' at line 1: SELECT FROM >> dspam_virtual_uids WHERE username='pet...@ps...' >> > Well... this one is not okay. There is nothing after SELECT and it should be something there. Looks to me like your compiler has issues with static functions. Can this be? > > >> [07/18/2011 22:48:43] 547: You have an error in your SQL syntax; check >> the manual that corresponds to your MySQL server version for the right >> syntax to use near ' FROM dspam_virtual_uids WHERE >> username='pe...@ps...'' at line 1: SELECT FROM >> dspam_virtual_uids WHERE username='pe...@ps...' >> > Same here as above. After SELECT there should be either '' I compiled DSPAM-3.9.1-RC1, and I didn't encounter the above problems [snip] >> >> Environment: >> >> Centos5.6 >> mysql Ver 14.12 Distrib 5.0.77 >> >> Any other info you need??? >> > Yes: > - Compiler > - Compiler flags/options gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-50) Compiler settings are left to use DSPAM default Makefile. CFLAGS = -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations CPP = gcc -E CPPFLAGS = -- Peter Santiago pe...@ps... My website: www.psinergybbs.com My spamtrap address: r3...@ps... |