![](https://secure.gravatar.com/avatar/2c243dff66113c5055f16cce02e18476.jpg?s=120&d=mm&r=g)
Please help
I did clean install observium subscription on Centos 7 and follow instruction from this link http://www.observium.org/docs/install_rhel7/ I choose php 7.0 to install, after installation complete I add user and device to manage, everything ok, but the graphs not shown only realtime graphs is show, I am waiting about 1 day but the data in the graphs in and out only give -nan, what I missed and how to solve this problem ?
see attachment
on the logs folder and I tail -f db.log I saw an error like this :
[2017/01/17 05:34:32 +0000] discovery.php(31631): Failed dbQuery (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `device_id` = '1' AND `entPhysicalIndex` = '39'' at line 1), Query: UPDATE `entPhysical` set `ifIndex` = WHERE `device_id` = '1' AND `entPhysicalIndex` = '39'
only db.log give an error, on error_log is empty.
best regards
Aswin Triadhi
IT System Administrator PT Citratubindo Tbk Jln. Hang Kesturi KM4 Kabil - Batam Indonesia
Office : +62-778-711123 (ext 113) Speed Dial : internal *1112 HP : +628 1364405096