Welcome, Guest. Please login or register.

Author Topic: You have an error in your SQL syntax  (Read 967 times)

cyberdude

  • Newbie
  • *
  • Posts: 13
    • View Profile
You have an error in your SQL syntax
« on: December 22, 2015, 03:10:24 PM »
I am getting the attached mysql error on the monitoring health page. I have not made any changes to the sql tables or code. Any suggestions on how to fix this message. Thanks

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2510
    • View Profile
    • NeDi
Re: You have an error in your SQL syntax
« Reply #1 on: December 23, 2015, 09:23:34 AM »
When logged in as admin, click on the ladybug on the top right to enter debug mode. Find the corresponding query and click on it. It'll open in System-Export, where you can further investigate the syntax...

Are you using the "view" filter to control what a user can see from the network?
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

cyberdude

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: You have an error in your SQL syntax
« Reply #2 on: December 29, 2015, 05:11:05 PM »
i am not using view filters. Below are the messages I get when debugging...


#0 GenQuery(interfaces, s, device,ifname,speed,iftype,dinoct/speed/*800, dinoct/speed desc, 10, Array ([0] => speed,[1] => dinoct/speed/*800,[2] => trafalert,[3] => location), Array ([0] => >,[1] => >,[2] => <,[3] => LIKE), Array ([0] => 0,[1] => 75,[2] => 100,[3] => ), Array ([0] => AND,[1] => AND,[2] => AND), JOIN devices USING (device)) called at [/opt/nedi/html/inc/libmon.php:280] #1 StatusIf(, bbup, 3) called at [/opt/nedi/html/Monitoring-Health.php:77]

SELECT device,ifname,speed,iftype,dinoct/speed/*800 FROM interfaces JOIN devices USING (device) WHERE (speed > '0' AND dinoct/speed/*800 > '75') AND (trafalert < '100') ORDER BY dinoct/speed desc LIMIT 10
338.3kB @0s





rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2510
    • View Profile
    • NeDi
Re: You have an error in your SQL syntax
« Reply #3 on: December 30, 2015, 06:50:35 PM »
Is rrdstep set in nedi.conf?
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo