MySQL and Scheduled maintenace

Help
1

It seams that on 5.7.20 MySQL Community Server (also had this on earlier versions) there is a problem with Maintenance Scheduling.
When trying to add a Maintenance record, a following error occurs:

MySQL Error: Incorrect date value: ‘0000-00-00’ for column ‘start_recurring_dt’ at row 1 (INSERT INTO alert_schedule (recurring,start,end,start_recurring_dt,end_recurring_dt,start_recurring_hr,end_recurring_hr,recurring_day,title,notes) VALUES (‘0’,‘2018-01-22 13:35’,‘2018-01-22 14:35’,‘0000-00-00’,’’,‘00:00:00’,‘00:00:00’,’’,‘test’,’’))

One of the fixes i see is making a change in “html/includes/forms/schedule-maintenance.inc.php”, but I am not sure if it doesn’t break anything in MariaDB:
//$start_recurring_dt = ‘0000-00-00’;
$start_recurring_dt = ‘1970-01-02’;
//$end_recurring_dt = null;
$end_recurring_dt = ‘1970-01-02’;

2

post the output ./validate.php

3

Note - Extra table is one of the in-house plugins

====================================

Component Version
LibreNMS 1.33-382-gfbca432
DB Schema 230
PHP 5.6.30-0+deb8u1
MySQL 5.7.20
RRDTool 1.6.0
SNMP NET-SNMP 5.7.2.1

====================================

[OK] Database connection successful
[FAIL] You have not set sql_mode=’’ in your mysql config.
[FIX] Set sql-mode=’’ in your mysql config file in the [mysqld] section.
[FAIL] Database: extra table (plugin_config_rules)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (https://t.libren.ms/5gscd):
[FIX] Run the following SQL statements to fix.
SQL Statements:
DROP TABLE plugin_config_rules;

4

just try to delete NO_ZERO_DATE and NO_ZERO_IN_DATE , from the sql_mode.
for example , add this line below in the mysqld.cnf and restart the service:
sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION