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 18 Stunden 21 Minuten
vor 2 Tagen 17 Stunden
vor 2 Tagen 22 Stunden
vor 5 Tagen 21 Stunden
vor 6 Tagen 16 Stunden
vor 6 Tagen 23 Stunden
vor 1 Woche 43 Sekunden
vor 1 Woche 15 Stunden
vor 1 Woche 16 Stunden
vor 1 Woche 2 Tagen