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?