v0.16.1.7533 upgraded from 0.15.6.6430
./discovery.php -u
Observium Community Edition 0.16.1.7533
-- Database is up to date.
it's full of entries like
[2016/02/08 11:30:35 +1100] poller.php(622): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('424','fdb_count','') [2016/02/08 11:30:35 +1100] poller.php(626): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('427','fdb_count','') [2016/02/08 11:30:35 +1100] poller.php(622): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('424','firewall_sessions_ipv4','') [2016/02/08 11:30:35 +1100] poller.php(610): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('476','firewall_sessions_ipv4','') [2016/02/08 11:30:35 +1100] poller.php(626): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'enabled' at row 1), Query: INSERT INTO `device_graphs` (` device_id`,`graph`,`enabled`) VALUES ('427','firewall_sessions_ipv4','') [2016/02/08 11:30:35 +1100] poller.php(603): Failed dbQuery (#1364 - Field 'ifInUcastPkts_delta' doesn't have a default value), Query: INSERT INTO `ports-state` (`pol l_time`,`poll_period`,`ifInOctets`,`ifOutOctets`,`ifInErrors`,`ifOutErrors`,`ifInUcastPkts`,`ifOutUcastPkts`,`ifInOctets_perc`,`ifOutOctets_perc`,`ifOctets_rate`,`ifU
castPkts_rate`,`ifErrors_rate`,`port_id`) VALUES ('1454891434','1454891434','','','','','','','0','0','0','0','0','1668') [2016/02/08 11:30:35 +1100] poller.php(3592): Failed dbQuery (#1364 - Field 'mempool_polled' doesn't have a default value), Query: INSERT INTO `mempools-state` (`memp ool_id`) VALUES ('1973') [2016/02/08 11:30:35 +1100] poller.php(3592): Failed dbQuery (#1364 - Field 'mempool_polled' doesn't have a default value), Query: INSERT INTO `mempools-state` (`memp ool_id`) VALUES ('1974') [2016/02/08 11:30:35 +1100] poller.php(603): Failed dbQuery (#1364 - Field 'ifInUcastPkts_delta' doesn't have a default value), Query: INSERT INTO `ports-state` (`pol l_time`,`poll_period`,`ifInOctets`,`ifOutOctets`,`ifInErrors`,`ifOutErrors`,`ifInUcastPkts`,`ifOutUcastPkts`,`ifInOctets_perc`,`ifOutOctets_perc`,`ifOctets_rate`,`ifU
castPkts_rate`,`ifErrors_rate`,`port_id`) VALUES ('1454891434','1454891434','','','','','','','0','0','0','0','0','1669')
so the question is, how do i remediate it.
thanks
Peter Hine Senior Technical Support Engineer (Servers) FCoA ITS peter.hine@familycourt.gov.au
********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************