Bug Tracker item #3388293, was opened at 2011-08-08 13:53 Message generated for change (Comment added) made by dolpa You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=3388293&group_id=250683
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Antal Kovacs (dolpa) Assigned to: Nobody/Anonymous (nobody) Summary: MySQL issue in 3.10.0 Initial Comment: I use DSPAM on Archlinux with PerconaDB 5.5 (full compatible with MySQL 5.5) atm in a test environment with 3.9.0. Last day I tried to update to 3.10.0. I totally wiped clean my previous DB for a fresh install. At first I tried to run a classic retain procedure: dspam_train globaluser spam_2/ easy_ham_2/ But I got a lot of SQL errors like: "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 '?.?='globaluser'' at line 1: SELECT off FROM off WHERE ...='globaluser'" more report and dspam.conf attached If I switch to libhash_drv everything is perfect, so I think there is some wrong with the sql driver. ---------------------------------------------------------------------- Comment By: Antal Kovacs (dolpa) Date: 2011-08-11 09:35 Message: Well. It looks like work, the database tables seems to be good. I got no errors, everything is fine. Thanks for this patch, great work! ps: I tested it with Percona Server with XtraDB 5.5 (full compatible with MySQL 5.5 innoDB) Cheers, Antal ---------------------------------------------------------------------- Comment By: Antal Kovacs (dolpa) Date: 2011-08-11 08:29 Message: Sure, I can help. This tarball is perfect for me. Today will be my time to test and I'll report back ASAP. Cheers, Antal ---------------------------------------------------------------------- Comment By: Tom Hendrikx (whyscream) Date: 2011-08-10 23:55 Message: Stevan has found a short term solution for the issue with the MySQL driver (he rolled back some speed optimizations on the mysql driver that were introduced after 3.9.1), which works on my systems where I could reproduce the issue. Would it be possible that you test this fix before we release it? I created a tarball of git master which includes the fix, it should install in the same way as a regular release tarball [1]. You could also just pull the latest code from git [2]. If you need any help or need to receive the fix in another form (f.i. a patch against 3.10.0) in order to test it, then please let me know. Thanks in advance, and waiting for your feedback! [1] http://whyscream.net/opendir/dspam-GIT-2011081001.tar.gz [2] http://dspam.git.sourceforge.net/ ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=3388293&group_id=250683 ------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
