Hi all,
We just upgrade Observium Pro version from 5565 to 8181 a few days. Everything seems to be working from we can tell, although since the upgrade we noticed this message in the db.log. It occurs for multiple devices. We are running Ubuntu 12.04.5. I'm wondering if it is because we are running PHP is 5.3? Has anyone seen this message after upgrading? It would nice to have some idea about the error message before we upgrade to 16.04.1. Thanks for the assistance in advance and let me know if you need any other information.
[2016/11/22 20:20:35 -0600] graph.php(21109): Failed dbQuery (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ne ar '==)' at line 1), Query: SELECT * FROM `processors` WHERE `processor_type` != 'hr-average' AND `device_id` = '280' AND `processor_id` IN (WyI2MzAiXQ==)
[2016/11/22 20:21:26 -0600] graph.php(21109): Failed dbQuery (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ne ar ')' at line 1), Query: SELECT * FROM `processors` WHERE `processor_type` != 'hr-average' AND `device_id` = '116' AND `processor_id` IN (WyIxMDMwIl0=)
Ubuntu 12.04.5 MySQL Ver 14.14 Distrib 5.5.53 PHP 5.3.10-1ubuntu3.25 Server version: Apache/2.2.22 NET-SNMP version: 5.4.3 RRDtool 1.4.7
Thanks, Chip