Could not execute statement 'INSERT INTO wcf1_visitor_daily (date, counter, isRegistered) SELECT…

  • Affected Version
    WoltLab Suite 5.2
    Affected App
    WoltLab Suite Core

    Guten Morgen,


    bei mir im Forum ist nun folgender Fehler schon zum zweiten Mal hintereinander aufgefallen:


    Requested URL
    /cron.php
    Referrer
    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'
    Type
    wcf\system\database\exception\DatabaseQueryExecutionException
    File (Line)
    /www/htdocs/xxx/domain.de/lib/system/database/statement/PreparedStatement.class.php (105)
    Query Parameter 1
    '+01:00'
    Query Parameter 2
    1603058400
    Query Parameter 3
    1603753199
    Stacktrace
    1. /www/htdocs/xxx/domain.de/lib/system/event/listener/VisitStatisticsDailyCleanUpCronjobListener.class.php (124): wcf\system\database\statement\PreparedStatement->execute(…)
    2. /www/htdocs/xxx/domain.de/lib/system/event/listener/VisitStatisticsDailyCleanUpCronjobListener.class.php (30): wcf\system\event\listener\VisitStatisticsDailyCleanUpCronjobListener->setDailyStats(…)
    3. /www/htdocs/xxx/domain.de/lib/system/event/EventHandler.class.php (221): wcf\system\event\listener\VisitStatisticsDailyCleanUpCronjobListener->execute(…)
    4. /www/htdocs/xxx/domain.de/lib/system/cronjob/AbstractCronjob.class.php (19): wcf\system\event\EventHandler->fireAction(…)
    5. /www/htdocs/xxx/domain.de/lib/system/cronjob/DailyCleanUpCronjob.class.php (22): wcf\system\cronjob\AbstractCronjob->execute(…)
    6. /www/htdocs/xxx/domain.de/lib/system/cronjob/CronjobScheduler.class.php (253): wcf\system\cronjob\DailyCleanUpCronjob->execute(…)
    7. /www/htdocs/xxx/domain.de/lib/system/cronjob/CronjobScheduler.class.php (71): wcf\system\cronjob\CronjobScheduler->executeCronjob(…)
    8. /www/htdocs/xxx/domain.de/lib/data/cronjob/CronjobAction.class.php (232): wcf\system\cronjob\CronjobScheduler->executeCronjobs(…)
    9. /www/htdocs/xxx/domain.de/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\cronjob\CronjobAction->executeCronjobs(…)
    10. /www/htdocs/xxx/domain.de/cron.php (18): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    Error Message
    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2020-10-18-0' for key 'date'
    Type
    PDOException
    File (Line)
    /www/htdocs/xxx/domain.de/lib/system/database/statement/PreparedStatement.class.php (93)
    Stacktrace
    1. /www/htdocs/xxx/domain.de/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
    2. /www/htdocs/xxx/domain.de/lib/system/event/listener/VisitStatisticsDailyCleanUpCronjobListener.class.php (124): wcf\system\database\statement\PreparedStatement->execute(…)
    3. /www/htdocs/xxx/domain.de/lib/system/event/listener/VisitStatisticsDailyCleanUpCronjobListener.class.php (30): wcf\system\event\listener\VisitStatisticsDailyCleanUpCronjobListener->setDailyStats(…)
    4. /www/htdocs/xxx/domain.de/lib/system/event/EventHandler.class.php (221): wcf\system\event\listener\VisitStatisticsDailyCleanUpCronjobListener->execute(…)
    5. /www/htdocs/xxx/domain.de/lib/system/cronjob/AbstractCronjob.class.php (19): wcf\system\event\EventHandler->fireAction(…)
    6. /www/htdocs/xxx/domain.de/lib/system/cronjob/DailyCleanUpCronjob.class.php (22): wcf\system\cronjob\AbstractCronjob->execute(…)
    7. /www/htdocs/xxx/domain.de/lib/system/cronjob/CronjobScheduler.class.php (253): wcf\system\cronjob\DailyCleanUpCronjob->execute(…)
    8. /www/htdocs/xxx/domain.de/lib/system/cronjob/CronjobScheduler.class.php (71): wcf\system\cronjob\CronjobScheduler->executeCronjob(…)
    9. /www/htdocs/xxx/domain.de/lib/data/cronjob/CronjobAction.class.php (232): wcf\system\cronjob\CronjobScheduler->executeCronjobs(…)
    10. /www/htdocs/xxx/domain.de/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\cronjob\CronjobAction->executeCronjobs(…)
    11. /www/htdocs/xxx/domain.de/cron.php (18): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
  • Da schließe ich mich an.


    Fehlermeldung

    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'


    Art

    wcf\system\database\exception\DatabaseQueryExecutionException


    Datei (Zeile)

    /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/database/statement/PreparedStatement.class.php (105)


    Query Parameter 1

    '+01:00'


    Query Parameter 2

    1603062000


    Query Parameter 3

    1603756799


    Stacktrace


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

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

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

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

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

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

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

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

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

    /var/www/XXXX.XXX/htdocs/XXXX.XXX/cron.php (27): wcf\data\AbstractDatabaseObjectAction->executeAction(…)


    Fehlermeldung

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


    Art

    PDOException


    Datei (Zeile)

    /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/database/statement/PreparedStatement.class.php (93)


    Stacktrace


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

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

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

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

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

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

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

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

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

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

    /var/www/XXXX.XXX/htdocs/XXXX.XXX/cron.php (27): wcf\data\AbstractDatabaseObjectAction->executeAction(…)


    Requested URL
    Referrer
    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'
    Type
    wcf\system\database\exception\DatabaseQueryExecutionException
    File (Line)
    /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/database/statement/PreparedStatement.class.php (105)
    Query Parameter 1
    '+01:00'
    Query Parameter 2
    1603062000
    Query Parameter 3
    1603756799
    Stacktrace
    1. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/event/listener/VisitStatisticsDailyCleanUpCronjobListener.class.php (124): wcf\system\database\statement\PreparedStatement->execute(…)
    2. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/event/listener/VisitStatisticsDailyCleanUpCronjobListener.class.php (30): wcf\system\event\listener\VisitStatisticsDailyCleanUpCronjobListener->setDailyStats(…)
    3. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/event/EventHandler.class.php (221): wcf\system\event\listener\VisitStatisticsDailyCleanUpCronjobListener->execute(…)
    4. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/cronjob/AbstractCronjob.class.php (19): wcf\system\event\EventHandler->fireAction(…)
    5. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/cronjob/DailyCleanUpCronjob.class.php (22): wcf\system\cronjob\AbstractCronjob->execute(…)
    6. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/cronjob/CronjobScheduler.class.php (253): wcf\system\cronjob\DailyCleanUpCronjob->execute(…)
    7. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/cronjob/CronjobScheduler.class.php (71): wcf\system\cronjob\CronjobScheduler->executeCronjob(…)
    8. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/data/cronjob/CronjobAction.class.php (232): wcf\system\cronjob\CronjobScheduler->executeCronjobs(…)
    9. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\cronjob\CronjobAction->executeCronjobs(…)
    10. /var/www/XXXX.XXX/htdocs/XXXX.XXX/cron.php (27): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    Error Message
    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2020-10-18-0' for key 'date'
    Type
    PDOException
    File (Line)
    /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/database/statement/PreparedStatement.class.php (93)
    Stacktrace
    1. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
    2. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/event/listener/VisitStatisticsDailyCleanUpCronjobListener.class.php (124): wcf\system\database\statement\PreparedStatement->execute(…)
    3. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/event/listener/VisitStatisticsDailyCleanUpCronjobListener.class.php (30): wcf\system\event\listener\VisitStatisticsDailyCleanUpCronjobListener->setDailyStats(…)
    4. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/event/EventHandler.class.php (221): wcf\system\event\listener\VisitStatisticsDailyCleanUpCronjobListener->execute(…)
    5. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/cronjob/AbstractCronjob.class.php (19): wcf\system\event\EventHandler->fireAction(…)
    6. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/cronjob/DailyCleanUpCronjob.class.php (22): wcf\system\cronjob\AbstractCronjob->execute(…)
    7. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/cronjob/CronjobScheduler.class.php (253): wcf\system\cronjob\DailyCleanUpCronjob->execute(…)
    8. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/system/cronjob/CronjobScheduler.class.php (71): wcf\system\cronjob\CronjobScheduler->executeCronjob(…)
    9. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/data/cronjob/CronjobAction.class.php (232): wcf\system\cronjob\CronjobScheduler->executeCronjobs(…)
    10. /var/www/XXXX.XXX/htdocs/XXXX.XXX/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\cronjob\CronjobAction->executeCronjobs(…)
    11. /var/www/XXXX.XXX/htdocs/XXXX.XXX/cron.php (27): wcf\data\AbstractDatabaseObjectAction->executeAction(…)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!