I installed the spam-module in the 5.x-3.0-beta1 version(recommended) but it gave me the missing argument error which was suppsoed to be fixed in the current dev-version. The error has indeed disappeared, but (after complete removal and reinstall) comment spam keeps flowing in. The module is set to be active against comment spam (which is default). When I check messages as being Spam they are removed instantly, but they are not removed without any input from my part. The Logs remain empty (statistics not), in Spamlogs - Blocked IP's I get the following error:
* user warning: 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 'SELECT DISTINCT x.hostname, x.timestamp, COUNT(x.hostname) AS c query: SELECT count(hostname) FROM (SELECT DISTINCT x.hostname, x.timestamp, COUNT(x.hostname) AS count FROM (SELECT timestamp, hostname FROM KLIMA_spam_tracker WHERE score > 86 ORDER BY timestamp DESC) AS x GROUP BY x.hostname) AS y WHERE y.count >= 3 in /home/www/klimatosoof/includes/database.mysql.inc on line 174.
* user warning: 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 'SELECT DISTINCT x.hostname, x.timestamp, COUNT(x.hostname) AS c query: SELECT * FROM (SELECT DISTINCT x.hostname, x.timestamp, COUNT(x.hostname) AS count FROM (SELECT timestamp, hostname FROM KLIMA_spam_tracker WHERE score > 86 ORDER BY timestamp DESC) AS x GROUP BY x.hostname) AS y WHERE y.count >= 3 ORDER BY timestamp DESC LIMIT 0, 50 in /home/www/klimatosoof/includes/database.mysql.inc on line 174.
Thanks for your time.
Comments
Comment #1
theorichel commentedWell I have switched to Mollom, so there is no need to answer this anymore.