On Tue, 19 Jul 2011 01:25:02 +0800 Peter Santiago <pet...@psinergybbs.com> wrote:
> 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='peter.santi...@psinergybbs.com'' at line 1: SELECT FROM > >> dspam_virtual_uids WHERE username='peter.santi...@psinergybbs.com' > >> > > 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='pet...@psinergybbs.com'' at line 1: SELECT FROM > >> dspam_virtual_uids WHERE username='pet...@psinergybbs.com' > >> > > 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 > But you have not checked out of GIT that RC1 version? Right? You used the one from Source Forge where you don't need to run autogen.sh. Right? > [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 = > You and Paul are the only one so far that I am aware of having that issue. On my end here I can NOT reproduce that issue. But I run diffrent GCC version and different MySQL version over here. Is there any reason to use "-g" for GCC? Are you debugging on that system? > > -- > Peter Santiago pet...@psinergybbs.com > My website: www.psinergybbs.com > My spamtrap address: r349...@psinergybbs.com > ------------------------------------------------------------------------------ AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
