After I ran ./discovery.php -u the second message stopped. Sorry about that. The original message continues to occur and looks like it happens when looking at an overview of a Juniper or Cisco device.
[2016/11/28 15:53:10 -0600] graph.php(47035): 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 near '==)' at line 1), Query: SELECT * FROM `processors` WHERE `processor_type` != 'hr-average' AND `device_id` = '112' AND `processor_id` IN (WyIyMjkiXQ==) [2016/11/28 15:53:11 -0600] graph.php(35094): 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 near '==)' at line 1), Query: SELECT * FROM `processors` WHERE `processor_type` != 'hr-average' AND `device_id` = '112' AND `processor_id` IN (WyIyMjgiXQ==) [2016/11/28 15:55:57 -0600] graph.php(46264): 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 near ')' at line 1), Query: SELECT * FROM `processors` WHERE `processor_type` != 'hr-average' AND `device_id` = '8' AND `processor_id` IN (WyIxMDkxIl0=) [2016/11/28 15:55:57 -0600] graph.php(47158): 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 near ')' at line 1), Query: SELECT * FROM `processors` WHERE `processor_type` != 'hr-average' AND `device_id` = '8' AND `processor_id` IN (WyIxMDkyIl0=) [2016/11/28 15:55:57 -0600] graph.php(47019): 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 near '==)' at line 1), Query: SELECT * FROM `processors` WHERE `processor_type` != 'hr-average' AND `device_id` = '8' AND `processor_id` IN (WyI5MzUiXQ==) [2016/11/28 15:55:57 -0600] graph.php(47019): Failed dbQuery (#1054 - Unknown column 'WyIyOCJd' in 'where clause'), Query: SELECT * FROM `processors` WHERE `processor_type` != 'hr-average' AND `device_id` = '8' AND `processor_id` IN (WyIyOCJd) [2016/11/28 15:56:04 -0600] graph.php(47867): 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 near '==)' at line 1), Query: SELECT * FROM `processors` WHERE `processor_type` != 'hr-average' AND `device_id` = '112' AND `processor_id` IN (WyIyMjgiXQ==) [2016/11/28 15:56:05 -0600] graph.php(47867): 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 near '==)' at line 1), Query: SELECT * FROM `processors` WHERE `processor_type` != 'hr-average' AND `device_id` = '112' AND `processor_id` IN (WyIyMjkiXQ==)
-Chip
On Mon, Nov 28, 2016 at 4:41 PM, Mike Stupalov mike@observium.org wrote:
you have not updated db schema
http://observium.org/docs/updating/#upgrading-the-subscription-edition-to-th...
./discovery.php -u
On Tue, Nov 29, 2016 at 12:38 AM, Chip Pleasants wpleasants@gmail.com wrote:
Hi Mike,
Thanks for helping Mike. I updated to 8249 and it looks like it is still occurring and we've added another log one that is absolutely blowing up the log file. These are in db.log and they occur without clicking on anything I believe.
[2016/11/28 15:26:57 -0600] poller.php(8391): Failed dbQuery (#1054 - Unknown column 'ifDiscards_rate' in 'field list'), Query: UPDATE `ports` set `poll_time` ='1480368409',`poll_period` ='1520',`ifInOctets` ='8288982',`ifInOctets_rate` ='0.042105263157895',`ifOutOctets` ='6394034',`ifOutOctets_rate` ='0.027631578947368',`ifInErrors` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='129510',`ifInUcastPkts_rate` ='0.00065789473684211',`ifOutUcastPkts` ='129571',`ifOutUcastPkts_rate` ='0.00065789473684211',`ifInNUcastPkts` ='0',`ifInNUcastPkts_rate` ='0',`ifOutNUcastPkts` ='0',`ifOutNUcastPkts_rate` ='0',`ifInBroadcastPkts` ='0',`ifInBroadcastPkts_rate` ='0',`ifOutBroadcastPkts` ='0',`ifOutBroadcastPkts_rate` ='0',`ifInMulticastPkts` ='0',`ifInMulticastPkts_rate` ='0',`ifOutMulticastPkts` ='0',`ifOutMulticastPkts_rate` ='0',`ifInDiscards` ='0',`ifInDiscards_rate` ='0',`ifOutDiscards` ='0',`ifOutDiscards_rate` ='0',`ifInOctets_perc` ='0',`ifOutOctets_perc` ='0',`ifOctets_rate` ='0.069736842105263',`ifUcastPkts_rate` ='0.0013157894736842',`ifErrors_rate` ='0',`ifDiscards_rate` ='0' WHERE `port_id` = '1415503'
[2016/11/28 15:27:50 -0600] graph.php(20539): 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 near '==)' at line 1), Query: SELECT * FROM `processors` WHERE `processor_type` != 'hr-average' AND `device_id` = '112' AND `processor_id` IN (WyIyMjkiXQ==)
-Chip
On Mon, Nov 28, 2016 at 3:38 PM, Mike Stupalov mike@observium.org wrote:
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/
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalov http://observium.org/