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 ='[email protected]'' at line 1: SELECT /lib64/libgcc_s.so.1 FROM À0k WHERE ='[email protected]' [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 ='[email protected]'' at line 1: SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='[email protected]' [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"<[email protected]> 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/dspam-user
