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 12 Stunden 44 Minuten
vor 14 Stunden 59 Minuten
vor 17 Stunden 34 Minuten
vor 18 Stunden 32 Minuten
vor 19 Stunden 22 Minuten
vor 19 Stunden 34 Minuten
vor 1 Tag 15 Stunden
vor 1 Tag 16 Stunden
vor 3 Tagen 21 Stunden
vor 4 Tagen 17 Stunden