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 6 Stunden 3 Minuten
vor 20 Stunden 8 Minuten
vor 1 Tag 21 Stunden
vor 4 Tagen 1 Stunde
vor 4 Tagen 3 Stunden
vor 4 Tagen 6 Stunden
vor 4 Tagen 16 Stunden
vor 5 Tagen 57 Minuten
vor 5 Tagen 57 Minuten
vor 5 Tagen 2 Stunden