Mysql query error: saving graphs

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Major
    • None
    • Affects Version/s: 1.4.3
    • Component/s: None
    • None

      I'm running into a mysql error when saving changes to my graphs. It appears it is trying to make a query for a graph with a null hostid. I've searched through the hosts and graphs tables and cannot find anything that would explain this. Thanks for your suggestions.

      1. Error in query [select new.itemid from items new, items dest where dest.itemid=17356 and new.key_=dest.key_ and new.hostid=] [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]
      2. mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:411]
      3. Error in query [select * from hosts where hostid=] [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]
      4. mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:411]
      5. No host with hostid=[]
      6. Missed key "system.cpu.util[,user,avg1]" for host ""
      7. Can not update graph "CPU Utilization" for host ""

      http://www.zabbix.com/forum/showthread.php?t=7955

            Assignee:
            Unassigned
            Reporter:
            Artem Suharev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: