Ad Widget

Collapse

Zabbix 1.5.2 - Screen SQL errors

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ataylo13
    Senior Member
    • Feb 2007
    • 122

    #1

    Zabbix 1.5.2 - Screen SQL errors

    I upgraded form 1.5.1 to 1.5.2 and now i am seeing this error message at the bottom of the page for each of my screens now. Did I botch the upgrade?

    * Error in query [SELECT s.* FROM scripts s WHERE (s.scriptid div 100000000000000) in (0) AND (s.groupid IN (2,4,0)) AND (s.usrgrpid IN (7,0)) ORDER BY scriptid ASC] [Unknown column 's.groupid' in 'where clause']
    * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix_1.5.2/include/db.inc.php:490]
    Version : 1.8.8
    Current Configuration 1 Master and 3 Child Nodes
  • ataylo13
    Senior Member
    • Feb 2007
    • 122

    #2
    Update... it does not have any errors on the Dynamic Screens.
    Version : 1.8.8
    Current Configuration 1 Master and 3 Child Nodes

    Comment

    • Aly
      ZABBIX developer
      • May 2007
      • 1126

      #3
      :/ Add to table scripts, 2 columns:

      SQL:
      Code:
      ALTER TABLE `scripts` ADD COLUMN `groupid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 AFTER `host_access`, ADD COLUMN `usrgrpid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 AFTER `groupid`;
      Zabbix | ex GUI developer

      Comment

      • ataylo13
        Senior Member
        • Feb 2007
        • 122

        #4
        That did it... you rock!
        Version : 1.8.8
        Current Configuration 1 Master and 3 Child Nodes

        Comment

        Working...