On Fri, 05 Aug 2011 14:36:25 +0200 Guillaume Hilt <gh...@shadowprojects.org> wrote:
> I checked my conf and tried with the original one (from 3.8.0) and the > updated one (3.10.0) and the same errors occurs. > I switched back to the previous version for now. > The problem is not the DSPAM configuration. It is something inside the DSPAM code that is triggering this issue. > Guillaume Hilt > > > Le 05/08/2011 13:50, Guillaume Hilt a écrit : > > 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 > > ------------------------------------------------------------------------------ > 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
