Hi Guillaume, Which MySQL version is this?
On 05/08/11 13:50, Guillaume Hilt wrote: > I have an issue on gentoo with dspam 3.10 (i just got released in portage). > I followed the UPGRADE file and dspam mysql database is up to date but i > have these issues, it looks like the queries are malformed : > > Aug 5 13:37:34 srv1 dspam[24278]: query error: 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 Uk WHERE vmail='vmail'' > at line 1: see sql.errors for more details > > [08/05/2011 13:28:26] 6862: 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 '/lib64/libgcc_s.so.1 FROM À0k WHERE ='ann...@domain1.com'' at line > 1: SELECT /lib64/libgcc_s.so.1 FROM À0k WHERE ='ann...@domain1.com' > [08/05/2011 13:28:26] 6862: 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 '/lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail'' at line 1: > SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail' > [08/05/2011 13:28:26] 6862: 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 '/lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail'' at line 1: > SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail' > [08/05/2011 13:28:26] 6862: 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 '/lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail'' at line 1: > SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail' > [08/05/2011 13:32:56] 6862: 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 '/lib64/libgcc_s.so.1 FROM olpic.net WHERE > ='bdarn...@domaine2.com'' at line 1: SELECT /lib64/libgcc_s.so.1 FROM > olpic.net WHERE ='bdarn...@domain2.com' > [08/05/2011 13:32:56] 6862: 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 '/lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail'' at line 1: > SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail' > [08/05/2011 13:32:56] 6862: 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 '/lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail'' at line 1: > SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail' > [08/05/2011 13:32:56] 6862: 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 '/lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail'' at line 1: > SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail' > [08/05/2011 13:37:34] 24278: 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 ~@Uk WHERE vmail='vmail'' at line 1: SELECT FROM ~@Uk > WHERE vmail='vmail' > [08/05/2011 13:37:34] 24278: 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 ~@Uk WHERE vmail='vmail'' at line 1: SELECT FROM ~@Uk > WHERE vmail='vmail' > [08/05/2011 13:37:34] 24278: 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 ~@Uk WHERE vmail='vmail'' at line 1: SELECT FROM ~@Uk > WHERE vmail='vmail > > Please note that olpic.net is a part of one of our domain, it got > truncted and i don't know why. > > DSPAM has been restarted and i tried to figure if something was broken > with revdep-rebuild but it's good. > > Any idea ? > > Guillaume Hilt > > > Le 04/08/2011 03:48, Nathanael D. Noblet a écrit : >> On 08/03/2011 01:52 PM, Stevan Bajić wrote: >>> On Tue, 02 Aug 2011 12:54:28 -0600 >>> "Nathanael D. Noblet"<nathan...@gnat.ca> wrote: >>> >>>> One more question, which I'm fairly certain of, but thought I would ask >>>> anyway. This is a safe upgrade from 3.9 I presume? no changes to token >>>> system that would force a user to dump the db and re-train?... >>>> >>> Might I ask you why you are asking this? Is it because of the version >>> number jump from 3.9.x to 3.10.x? Or any other reason? >>> >>> >> >> Just to be prudent. As the packager for fedora I wouldn't want to push >> an update that could change the underlying DB or tokenizer etc... I'm >> also partially lazy plus didn't really understand the release >> announcement when it said the upgrade should be problem free... No idea >> why. We just had a baby 2 weeks ago so I blame it on lack of sleep. >> >> Either way Fedora 16,15,14, EPEL 6,5 all have dspam 3.10 rolling in. >> >> >> >> ------------------------------------------------------------------------------ >> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA >> The must-attend event for mobile developers. Connect with experts. >> Get tools for creating Super Apps. See the latest technologies. >> Sessions, hands-on labs, demos& much more. Register early& save! >> http://p.sf.net/sfu/rim-blackberry-1 >> _______________________________________________ >> Dspam-user mailing list >> Dspam-user@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/dspam-user > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos & much more. Register early & save! > http://p.sf.net/sfu/rim-blackberry-1 > _______________________________________________ > Dspam-user mailing list > Dspam-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspam-user -- Regards, Tom PGP key ID: 7D54EFF5 PGP key FP: C26F 374F 5E13 157B 5B42 7A1B 93DF 319D 7D54 EFF5 ------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
