On Fri, 05 Aug 2011 14:37:51 +0200 Guillaume Hilt <gh...@shadowprojects.org> wrote:
> Sorry, I forgot. > I'm running MySQL 5.1.42. > Mail server is running with Gentoo 2011 AMD64 and MySQL server is using > OpenSolaris AMD64. > MySQL librairies are both on 5.1.42. > Please post the output of "emerge --info". > Guillaume Hilt > > > Le 05/08/2011 14:31, Tom Hendrikx a écrit : > > 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 > > > > ------------------------------------------------------------------------------ > 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
