1. [2020-07-22 23:57:47] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'start_recurring_dt' in 'where clause' (SQL: select exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = 0 and `start` <= NOW() and `end` >= NOW()) or (`recurring` = 1 and (`start_recurring_dt` <= date_format(NOW(), '%Y-%m-%d') and (`end_recurring_dt` >= date_format(NOW(), '%Y-%m-%d') or `end_recurring_dt` is null or `end_recurring_dt` = 0000-00-00 or `end_recurring_dt` = )) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), '%w'), '%') or `recurring_day` is null or `recurring_day` = ))) and ((`alert_schedulable_type` = device and `alert_schedulable_id` = 264) or (`alert_schedulable_type` = device_group and `alert_schedulable_id` in (1)) or (`alert_schedulable_type` = location and `alert_schedulable_id` = 137))) as `exists`) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'start_recurring_dt' in 'where clause' (SQL: select exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = 0 and `start` <= NOW() and `end` >= NOW()) or (`recurring` = 1 and (`start_recurring_dt` <= date_format(NOW(), '%Y-%m-%d') and (`end_recurring_dt` >= date_format(NOW(), '%Y-%m-%d') or `end_recurring_dt` is null or `end_recurring_dt` = 0000-00-00 or `end_recurring_dt` = )) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), '%w'), '%') or `recurring_day` is null or `recurring_day` = ))) and ((`alert_schedulable_type` = device and `alert_schedulable_id` = 264) or (`alert_schedulable_type` = device_group and `alert_schedulable_id` in (1)) or (`alert_schedulable_type` = location and `alert_schedulable_id` = 137))) as `exists`) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'start_recurring_dt' in 'where clause' at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:63, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'start_recurring_dt' in 'where clause' at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61)
2. [stacktrace]
3. #0 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('select exists(s...', Array, Object(Closure))
4. #1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(333): Illuminate\\Database\\Connection->run('select exists(s...', Array, Object(Closure))
5. #2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2426): Illuminate\\Database\\Connection->select('select exists(s...', Array, true)
6. #3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1353): Illuminate\\Database\\Query\\Builder->exists()
7. #4 /opt/librenms/app/Models/Device.php(229): Illuminate\\Database\\Eloquent\\Builder->__call('exists', Array)
8. #5 /opt/librenms/LibreNMS/Alert/AlertUtil.php(200): App\\Models\\Device->isUnderMaintenance()
9. #6 /opt/librenms/LibreNMS/Alert/AlertRules.php(46): LibreNMS\\Alert\\AlertUtil::isMaintenance(264)
10. #7 /opt/librenms/poller.php(148): LibreNMS\\Alert\\AlertRules->runRules(264)
11. #8 {main}
12. "}
13. [2020-07-22 23:57:47] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'start_recurring_dt' in 'where clause' (SQL: select exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = 0 and `start` <= NOW() and `end` >= NOW()) or (`recurring` = 1 and (`start_recurring_dt` <= date_format(NOW(), '%Y-%m-%d') and (`end_recurring_dt` >= date_format(NOW(), '%Y-%m-%d') or `end_recurring_dt` is null or `end_recurring_dt` = 0000-00-00 or `end_recurring_dt` = )) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), '%w'), '%') or `recurring_day` is null or `recurring_day` = ))) and ((`alert_schedulable_type` = device and `alert_schedulable_id` = 132) or (`alert_schedulable_type` = device_group and `alert_schedulable_id` in (1)) or (`alert_schedulable_type` = location and `alert_schedulable_id` = 10))) as `exists`) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'start_recurring_dt' in 'where clause' (SQL: select exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = 0 and `start` <= NOW() and `end` >= NOW()) or (`recurring` = 1 and (`start_recurring_dt` <= date_format(NOW(), '%Y-%m-%d') and (`end_recurring_dt` >= date_format(NOW(), '%Y-%m-%d') or `end_recurring_dt` is null or `end_recurring_dt` = 0000-00-00 or `end_recurring_dt` = )) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), '%w'), '%') or `recurring_day` is null or `recurring_day` = ))) and ((`alert_schedulable_type` = device and `alert_schedulable_id` = 132) or (`alert_schedulable_type` = device_group and `alert_schedulable_id` in (1)) or (`alert_schedulable_type` = location and `alert_schedulable_id` = 10))) as `exists`) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'start_recurring_dt' in 'where clause' at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:63, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'start_recurring_dt' in 'where clause' at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61)
14. [stacktrace]
15. #0 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('select exists(s...', Array, Object(Closure))
16. #1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(333): Illuminate\\Database\\Connection->run('select exists(s...', Array, Object(Closure))
17. #2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2426): Illuminate\\Database\\Connection->select('select exists(s...', Array, true)
18. #3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1353): Illuminate\\Database\\Query\\Builder->exists()
19. #4 /opt/librenms/app/Models/Device.php(229): Illuminate\\Database\\Eloquent\\Builder->__call('exists', Array)
20. #5 /opt/librenms/LibreNMS/Alert/AlertUtil.php(200): App\\Models\\Device->isUnderMaintenance()
21. #6 /opt/librenms/LibreNMS/Alert/AlertRules.php(46): LibreNMS\\Alert\\AlertUtil::isMaintenance(132)
22. #7 /opt/librenms/poller.php(148): LibreNMS\\Alert\\AlertRules->runRules(132)
23. #8 {main}
24. "}
25. ^C
26.