Ad Widget

Collapse

Error creating an item in a graph

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mightor
    Junior Member
    • May 2007
    • 15

    #1

    Error creating an item in a graph

    When trying to insert a new item in a graph, I get the following error message:

    SQL error: Unknown column 'calc_fnc' in 'field list'
    Query: insert into graphs_items (graphid,itemid,color,drawtype,sortorder,yaxisside ,calc_fnc,type,periods_cnt) values (6,17421,'Yellow',0,0,1,2,0,5)

    I understand SQL syntax: structure of table graphs_items may be wrong. Is it possible that I have a mismatch between DB version and front-end (PHP) version ?
    Note: I'm using an OpenESM preconfigured Zabbix platform in a VMWare appliance.
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    Originally posted by mightor
    Note: I'm using an OpenESM preconfigured Zabbix platform in a VMWare appliance.
    I would suggest asking of OpenESM developers if there is a mismatch of DB schema and binaries in the distro.
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • mightor
      Junior Member
      • May 2007
      • 15

      #3
      Thank you. I decided to give up with OpenEMS.
      I started from scratch and set up a new VM with Debian Etch. Now everything works fine, except for actions (http://www.zabbix.com/forum/showthread.php?t=6172).

      Thanks,
      Regis

      Comment

      Working...