Fehler in Spam-Logs
Eingetragen von imdse (25)am 25.08.2008 - 11:09 Uhr in
Hallo
Ich nutze das Modul Spam. In den Logs zu "Blocked IPs" unter admin/logs/spam/blockedips gibt es da diese Fehlermeldung:
* 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 drupal_skhor_spam_tracker WHERE probability>86 ORDER BY timestamp DESC) AS x GROUP BY x.hostname) AS y WHERE y.count>=2 in /homepages/xx/xx/htdocs/skhor.de/includes/database.mysql.inc on line 172.
* 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 drupal_skhor_spam_tracker WHERE probability>86 ORDER BY timestamp DESC) AS x GROUP BY x.hostname) AS y WHERE y.count>=2 ORDER BY timestamp DESC LIMIT 0, 50 in /homepages/xx/xx/htdocs/skhor.de/includes/database.mysql.inc on line 172.Ich kann sie leider nicht verstehen. Jedenfalls bleibt die Tabelle mit den geblockten IPs leer. Wo könnte der Fehler stecken?
- Anmelden oder Registrieren um Kommentare zu schreiben
Neue Kommentare
vor 1 Stunde 11 Minuten
vor 22 Stunden 34 Minuten
vor 2 Tagen 4 Stunden
vor 2 Tagen 4 Stunden
vor 2 Tagen 17 Stunden
vor 2 Tagen 18 Stunden
vor 2 Tagen 20 Stunden
vor 2 Tagen 20 Stunden
vor 4 Tagen 13 Stunden
vor 4 Tagen 15 Stunden