Ad Widget

Collapse

creating screens gives elastic field mysql error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bambin0
    Junior Member
    • Apr 2006
    • 8

    #1

    creating screens gives elastic field mysql error

    Here is what I get when I go to screens, and try to add anything including plain text, simple graphs etc. This used to work in 1.1b2, but when i upgraded to b8, something broke. I suspect it's a simple mysql entry:
    [ERROR:Cannot add item]

    SQL error: Unknown column 'elastic' in 'field list'
    Query: insert into screens_items (resource,screenid,x,y,resourceid,width,height,col span,rowspan,elements,valign,halign,style,url) values (3,1,0,0,17209,0,0,0,0,25,0,0,elastic,'')

    My particulars:
    mysql 4.1.12
    RHEL 4.0
    zabbix 1.1b8
    I also tried to do a clean install AFTER I started getting the errors and it wasn't any help.

    I fixed this by:
    mysql zabbix -u username -p password

    DROP TABLE IF EXISTS screens_items;
    CREATE TABLE screens_items (
    screenitemid int(4) NOT NULL auto_increment,
    screenid int(4) DEFAULT '0' NOT NULL,
    resource int(4) DEFAULT '0' NOT NULL,
    resourceid int(4) DEFAULT '0' NOT NULL,
    width int(4) DEFAULT '320' NOT NULL,
    height int(4) DEFAULT '200' NOT NULL,
    x int(4) DEFAULT '0' NOT NULL,
    y int(4) DEFAULT '0' NOT NULL,
    colspan int(4) DEFAULT '0' NOT NULL,
    rowspan int(4) DEFAULT '0' NOT NULL,
    elements int(4) DEFAULT '25' NOT NULL,
    valign int(2) DEFAULT '0' NOT NULL,
    halign int(2) DEFAULT '0' NOT NULL,
    style int(4) DEFAULT '0' NOT NULL,
    elastic int(4) DEFAULT '0' NOT NULL,
    url varchar(255) DEFAULT '' NOT NULL,
    PRIMARY KEY (screenitemid)
    ) TYPE=InnoDB;
    Last edited by bambin0; 17-04-2006, 15:37.
Working...