Did you, perchance, install a "special" mysql package which uses strict mode?
:D
adam.
Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm...] On 15/01/2016 16:02:20, Simon Smith simonsmith5521@gmail.com wrote: HI All,
decided to do a fresh install of observium and DB
I’m getting dbquery errors in db.log with add_user.php, add_device.php, discovery.php and poller.php
http://pastebin.com/w13kXT6H - full db.log
just a few lines i managed to find out
[2016/01/15 14:46:43 +0000] adduser.php(26168): Failed dbQuery (#1366 - Incorrect integer value: 'NULL' for column 'device_id' at row 1), Query: INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('NULL',NULL,NULL,NOW(),'6','Observium updated: -> 7497')
[2016/01/15 14:47:59 +0000] add_device.php(26237): Failed dbQuery (#1292 - Incorrect datetime value: 'NULL' for column 'last_discovered' at row 1), Query: UPDATE `devices` set `last_discovered` ='NULL' WHERE `device_id` = '2'
[2016/01/15 14:48:27 +0000] discovery.php(26358): Failed dbQuery (#1364 - Field 'sensor_status' doesn't have a default value), Query: INSERT INTO `sensors-state` (`sensor_id`,`sensor_value`,`sensor_polled`) VALUES ('5','23','NOW()’)
[2016/01/15 14:49:21 +0000] poller.php(26843): Failed dbQuery (#1364 - Field 'location_country' doesn't have a default value), Query: INSERT INTO `devices_locations` (`location`,`location_geoapi`,`location_lat`,`location_lon`,`location_updated`,`device_id`) VALUES ('L24 9PB [53.352382, -2.858778]','yahoo','53.352382','-2.858778','2016-01-15 14:48:52','1')
[2016/01/15 14:51:12 +0000] poller.php(26843): Failed dbQuery (#1366 - Incorrect integer value: '' for column 'sensor_last_change' at row 1), Query: INSERT INTO `sensors-state` (`sensor_id`,`sensor_value`,`sensor_event`,`sensor_status`,`sensor_last_change`,`sensor_polled`) VALUES ('7','24.1','ok','','','1452869472')
[2016/01/15 14:51:28 +0000] poller.php(26843): Failed dbQuery (#1364 - Field 'ifInUcastPkts_delta' doesn't have a default value), Query: INSERT INTO `ports-state` (`poll_time`,`poll_period`,`ifInOctets`,`ifOutOctets`,`ifInErrors`,`ifOutErrors`,`ifInUcastPkts`,`ifOutUcastPkts`,`ifInOctets_perc`,`ifOutOctets_perc`,`ifOctets_rate`,`ifUcastPkts_rate`,`ifErrors_rate`,`port_id`) VALUES ('1452869487','1452869487','0','0','0','0','0','0','0','0','0','0','0','152')
however I’m seeing the ' insert into ports-state ' every time i poll my switches
ive only added 3 switches for test reasons
regards
Simon
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium