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



--
Mike Stupalov
http://observium.org/