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