On Fri, 05 Aug 2011 13:50:30 +0200 Guillaume Hilt <[email protected]> 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 ='[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 ? > Looks like the same issue Paul has with his older FreeBSD box and the same issue some one other (can not remember the name) has reported. Can you please post the following info: - emerge --info - equery l mysql > Guillaume Hilt > -- Kind Regards from Switzerland, Stevan Bajić > > 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 ------------------------------------------------------------------------------ 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
