Ad Widget

Collapse

SQL error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • patryk
    Junior Member
    • Dec 2012
    • 9

    #1

    SQL error

    mysql_query(): Unable to save result set [include/db.inc.php:432]
    Error in query [SELECT COUNT(DISTINCT t.triggerid) AS cnt,t.status,t.value FROM triggers t INNER JOIN functions f ON t.triggerid=f.triggerid INNER JOIN items i ON f.itemid=i.itemid INNER JOIN hosts h ON i.hostid=h.hostid WHERE i.status=0 AND h.status=0 GROUP BY t.status,t.value] [Out of memory (Needed 1048544 bytes)]
    mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:569]
    mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:570]

    I get this error when I open dashboard

    Anyone can helpme with it, please?
  • Colttt
    Senior Member
    Zabbix Certified Specialist
    • Mar 2009
    • 878

    #2
    please create a bug-report!!
    Debian-User

    Sorry for my bad english

    Comment

    • patryk
      Junior Member
      • Dec 2012
      • 9

      #3
      It turned out that my server run out of memory
      After restart all went back to normal

      Comment

      Working...