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
>