Ad Widget

Collapse

SQL error:

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • logo
    Junior Member
    • Feb 2006
    • 3

    #1

    SQL error:

    Hello,
    just installed the first time zabbix and getting this error when trying to add a screen. The same goes when i try to add a host into a map.

    This parameter (x=) will not hand over apparently - why?

    SQL error: 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 'and y=0' at line 1
    Query: delete from screens_items where screenid=1 and x= and y=0
    SQL error: 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 '0,17220,500,100,0,0,0)' at line 1
    Query: insert into screens_items (resource,screenid,x,y,resourceid,width,height,col span,rowspan,elements) values (1,1,,0,17220,500,100,0,0,0)

    Any ideas?
  • krusty
    Senior Member
    • Oct 2005
    • 222

    #2
    Hi, i think you have forget to set the parameter x when you create a map.

    Comment

    • logo
      Junior Member
      • Feb 2006
      • 3

      #3
      be sure - I filled in the params, they were ignored.

      Comment

      • logo
        Junior Member
        • Feb 2006
        • 3

        #4
        ??? The Problem is fixed but i don't know why. After this weekend i logged in zabbix and try again to add hosts to a map - it works - the same with screens.

        I've changed nothing to the system!
        silly...

        Comment

        Working...