Fehler in Spam-Logs
Eingetragen von imdse (25)am 25.08.2008 - 10: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 9 Stunden 58 Minuten
vor 11 Stunden 26 Minuten
vor 11 Stunden 29 Minuten
vor 21 Stunden 33 Minuten
vor 1 Tag 7 Stunden
vor 1 Tag 9 Stunden
vor 1 Tag 9 Stunden
vor 1 Tag 9 Stunden
vor 1 Tag 10 Stunden
vor 2 Tagen 4 Stunden