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.
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
