Dieses Projekt wird in seiner aktuellen Form die Tore bald schließen.
Hier mehr erfahren: Unsere Zukunft innerhalb des WoltLab-Ökosystems
  • Moin zusammen,


    ich bekomme Abends immer eine Fehlermeldung und dann werden die Visits nicht sauber gespeichert:




    Sun, 06 Dec 2020 00:11:40 +0000

    Message: Could not execute statement 'INSERT INTO wcf1_visitor_daily (date, counter, isRegistered) SELECT CONVERT_TZ(DATE_FORMAT(FROM_UNIXTIME(time), '%Y-%m-%d'), @@SESSION.time_zone, ?) AS date, COUNT(*) AS counter, isRegistered FROM wcf1_visitor WHERE time BETWEEN ? AND ? GROUP BY isRegistered, date'

    PHP version: 7.1.33-nmm1

    WoltLab Suite version: 5.2.9

    Request URI: /index.php?ajax-proxy/&t=4db191c440d714782afe87bc3a7572b0eed91607

    Referrer: https://www..de/user/70-chilled/

    User Agent: Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.140 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)

    Peak Memory Usage: 6355048/268435456

    ======

    Error Class: wcf\system\database\exception\DatabaseQueryExecutionException

    Error Message: Could not execute statement 'INSERT INTO wcf1_visitor_daily (date, counter, isRegistered) SELECT CONVERT_TZ(DATE_FORMAT(FROM_UNIXTIME(time), '%Y-%m-%d'), @@SESSION.time_zone, ?) AS date, COUNT(*) AS counter, isRegistered FROM wcf1_visitor WHERE time BETWEEN ? AND ? GROUP BY isRegistered, date'

    Error Code: 23000

    File: /www/htdocs/w012a463/.de/lib/system/database/statement/PreparedStatement.class.php (105)

    Extra Information: YTozOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtzOjg6IicrMDE6MDAnIjt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7aToxNjAzMDU4NDAwO31pOjI7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDMiO2k6MTtpOjE2MDcyMDkxOTk7fX0=

    Stack Trace: [{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/event\/listener\/VisitStatisticsDailyCleanUpCronjobListener.class.php","line":124,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/event\/listener\/VisitStatisticsDailyCleanUpCronjobListener.class.php","line":30,"function":"setDailyStats","class":"wcf\\system\\event\\listener\\VisitStatisticsDailyCleanUpCronjobListener","type":"->","args":[1603058400]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/event\/EventHandler.class.php","line":221,"function":"execute","class":"wcf\\system\\event\\listener\\VisitStatisticsDailyCleanUpCronjobListener","type":"->","args":["wcf\\system\\cronjob\\DailyCleanUpCronjob","wcf\\system\\cronjob\\DailyCleanUpCronjob","execute",[]]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/cronjob\/AbstractCronjob.class.php","line":19,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":["wcf\\system\\cronjob\\DailyCleanUpCronjob","execute"]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/cronjob\/DailyCleanUpCronjob.class.php","line":22,"function":"execute","class":"wcf\\system\\cronjob\\AbstractCronjob","type":"->","args":["wcf\\data\\cronjob\\Cronjob"]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":253,"function":"execute","class":"wcf\\system\\cronjob\\DailyCleanUpCronjob","type":"->","args":["wcf\\data\\cronjob\\Cronjob"]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":71,"function":"executeCronjob","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":["wcf\\data\\cronjob\\CronjobEditor","wcf\\data\\cronjob\\log\\CronjobLogEditor"]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/data\/cronjob\/CronjobAction.class.php","line":232,"function":"executeCronjobs","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"executeCronjobs","class":"wcf\\data\\cronjob\\CronjobAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

    ======

    Error Class: PDOException

    Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2020-10-18-0' for key 'date'

    Error Code: 23000

    File: /www/htdocs/w012a463/.de/lib/system/database/statement/PreparedStatement.class.php (93)

    Extra Information: -

    Stack Trace: [{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/event\/listener\/VisitStatisticsDailyCleanUpCronjobListener.class.php","line":124,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/event\/listener\/VisitStatisticsDailyCleanUpCronjobListener.class.php","line":30,"function":"setDailyStats","class":"wcf\\system\\event\\listener\\VisitStatisticsDailyCleanUpCronjobListener","type":"->","args":[1603058400]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/event\/EventHandler.class.php","line":221,"function":"execute","class":"wcf\\system\\event\\listener\\VisitStatisticsDailyCleanUpCronjobListener","type":"->","args":["wcf\\system\\cronjob\\DailyCleanUpCronjob","wcf\\system\\cronjob\\DailyCleanUpCronjob","execute",[]]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/cronjob\/AbstractCronjob.class.php","line":19,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":["wcf\\system\\cronjob\\DailyCleanUpCronjob","execute"]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/cronjob\/DailyCleanUpCronjob.class.php","line":22,"function":"execute","class":"wcf\\system\\cronjob\\AbstractCronjob","type":"->","args":["wcf\\data\\cronjob\\Cronjob"]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":253,"function":"execute","class":"wcf\\system\\cronjob\\DailyCleanUpCronjob","type":"->","args":["wcf\\data\\cronjob\\Cronjob"]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":71,"function":"executeCronjob","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":["wcf\\data\\cronjob\\CronjobEditor","wcf\\data\\cronjob\\log\\CronjobLogEditor"]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/data\/cronjob\/CronjobAction.class.php","line":232,"function":"executeCronjobs","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"executeCronjobs","class":"wcf\\data\\cronjob\\CronjobAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w012a463\/.de\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]



    Could not execute statement 'INSERT INTO wcf1_visitor_daily (date, counter, isRegistered) SELECT CONVERT_TZ(DATE_FORMAT(FROM_UNIXTIME(time), '%Y-%m-%d'), @@SESSION.time_zone, ?) AS date, COUNT(*) AS counter, isRegistered FROM wcf1_visitor WHERE time BETWEEN ? AND ? GROUP BY isRegistered, date'

    Datum6. Dezember 2020, 01:11Aufgerufene URL/index.php?ajax-proxy/&t=4db191c440d714782afe87bc3a7572b0eed91607Referrerhttps://www..de/user/70-chilled/BrowserMozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.140 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)Arbeitsspeicher6,06 MiB / 256 MiBFehlermeldungCould not execute statement 'INSERT INTO wcf1_visitor_daily (date, counter, isRegistered) SELECT CONVERT_TZ(DATE_FORMAT(FROM_UNIXTIME(time), '%Y-%m-%d'), @@SESSION.time_zone, ?) AS date, COUNT(*) AS counter, isRegistered FROM wcf1_visitor WHERE time BETWEEN ? AND ? GROUP BY isRegistered, date'Artwcf\system\database\exception\DatabaseQueryExecutionExceptionDatei (Zeile)/www/htdocs/w012a463/.de/lib/system/database/statement/PreparedStatement.class.php (105)Query Parameter 1'+01:00'Query Parameter 21603058400Query Parameter 31607209199Stacktrace


    /www/htdocs/w012a463/.de/lib/system/event/listener/VisitStatisticsDailyCleanUpCronjobListener.class.php (124): wcf\system\database\statement\PreparedStatement->execute(…)

    /www/htdocs/w012a463/.de/lib/system/event/listener/VisitStatisticsDailyCleanUpCronjobListener.class.php (30): wcf\system\event\listener\VisitStatisticsDailyCleanUpCronjobListener->setDailyStats(…)

    /www/htdocs/w012a463/.de/lib/system/event/EventHandler.class.php (221): wcf\system\event\listener\VisitStatisticsDailyCleanUpCronjobListener->execute(…)

    /www/htdocs/w012a463/.de/lib/system/cronjob/AbstractCronjob.class.php (19): wcf\system\event\EventHandler->fireAction(…)

    /www/htdocs/w012a463/.de/lib/system/cronjob/DailyCleanUpCronjob.class.php (22): wcf\system\cronjob\AbstractCronjob->execute(…)

    /www/htdocs/w012a463/.de/lib/system/cronjob/CronjobScheduler.class.php (253): wcf\system\cronjob\DailyCleanUpCronjob->execute(…)

    /www/htdocs/w012a463/.de/lib/system/cronjob/CronjobScheduler.class.php (71): wcf\system\cronjob\CronjobScheduler->executeCronjob(…)

    /www/htdocs/w012a463/.de/lib/data/cronjob/CronjobAction.class.php (232): wcf\system\cronjob\CronjobScheduler->executeCronjobs(…)

    /www/htdocs/w012a463/.de/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\cronjob\CronjobAction->executeCronjobs(…)

    /www/htdocs/w012a463/.de/lib/action/AJAXProxyAction.class.php (75): wcf\data\AbstractDatabaseObjectAction->executeAction(…)

    /www/htdocs/w012a463/.de/lib/action/AJAXInvokeAction.class.php (94): wcf\action\AJAXProxyAction->invoke(…)

    /www/htdocs/w012a463/.de/lib/action/AbstractAction.class.php (47): wcf\action\AJAXInvokeAction->execute(…)

    /www/htdocs/w012a463/.de/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)

    /www/htdocs/w012a463/.de/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)

    /www/htdocs/w012a463/.de/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)

    /www/htdocs/w012a463/.de/index.php (9): wcf\system\request\RequestHandler->handle(…)

    FehlermeldungSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2020-10-18-0' for key 'date'ArtPDOExceptionDatei (Zeile)/www/htdocs/w012a463/.de/lib/system/database/statement/PreparedStatement.class.php (93)Stacktrace


    /www/htdocs/w012a463/.de/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)

    /www/htdocs/w012a463/.de/lib/system/event/listener/VisitStatisticsDailyCleanUpCronjobListener.class.php (124): wcf\system\database\statement\PreparedStatement->execute(…)

    /www/htdocs/w012a463/.de/lib/system/event/listener/VisitStatisticsDailyCleanUpCronjobListener.class.php (30): wcf\system\event\listener\VisitStatisticsDailyCleanUpCronjobListener->setDailyStats(…)

    /www/htdocs/w012a463/.de/lib/system/event/EventHandler.class.php (221): wcf\system\event\listener\VisitStatisticsDailyCleanUpCronjobListener->execute(…)

    /www/htdocs/w012a463/.de/lib/system/cronjob/AbstractCronjob.class.php (19): wcf\system\event\EventHandler->fireAction(…)

    /www/htdocs/w012a463/.de/lib/system/cronjob/DailyCleanUpCronjob.class.php (22): wcf\system\cronjob\AbstractCronjob->execute(…)

    /www/htdocs/w012a463/.de/lib/system/cronjob/CronjobScheduler.class.php (253): wcf\system\cronjob\DailyCleanUpCronjob->execute(…)

    /www/htdocs/w012a463/.de/lib/system/cronjob/CronjobScheduler.class.php (71): wcf\system\cronjob\CronjobScheduler->executeCronjob(…)

    /www/htdocs/w012a463/.de/lib/data/cronjob/CronjobAction.class.php (232): wcf\system\cronjob\CronjobScheduler->executeCronjobs(…)

    /www/htdocs/w012a463/.de/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\cronjob\CronjobAction->executeCronjobs(…)

    /www/htdocs/w012a463/.de/lib/action/AJAXProxyAction.class.php (75): wcf\data\AbstractDatabaseObjectAction->executeAction(…)

    /www/htdocs/w012a463/.de/lib/action/AJAXInvokeAction.class.php (94): wcf\action\AJAXProxyAction->invoke(…)

    /www/htdocs/w012a463/.de/lib/action/AbstractAction.class.php (47): wcf\action\AJAXInvokeAction->execute(…)

    /www/htdocs/w012a463/.de/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)

    /www/htdocs/w012a463/.de/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)

    /www/htdocs/w012a463/.de/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)

    /www/htdocs/w012a463/.de/index.php (9): wcf\system\request\RequestHandler->handle(…)

    Ist das schon bekannt?

  • Moin Matthias und danke für die schnelle Antwort!


    Ich denke der Cronjob für dein Plugin ist der "Generiert die tägliche Statistiken", oder? Der scheint zusammen zu laufen mit "Löscht veraltete Einträge in der Moderation" und "Führt tägliche Aufräumarbeiten aus".


    Da sind aber bpsw. heute Nacht noch ein paar mehr fehlgeschlagen sehe ich gerade. Könnte eventuell auch hier mit dem Thema zu tun haben -> https://community.woltlab.com/…ostID=1830879#post1830879

  • Black Rider

    Hat das Label Problem hinzugefügt.
  • Black Rider

    Hat das Label Besuchsstatistiken hinzugefügt.
  • Black Rider

    Hat das Label Kein Fehler hinzugefügt.