Hi,
please try latest revision and please show complete url, where you get such error.
sql query fixed in latest revision, but undecoded vars for processor_id possible only if you requested graph as not authorized user.
Or this is really php 5.3 issue too :)
On Mon, Nov 28, 2016 at 10:39 PM, Chip Pleasants wpleasants@gmail.com wrote:
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 _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium