Ad Widget

Collapse

Please help!!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • debora
    Member
    • Jan 2006
    • 75

    #1

    Please help!!

    I have a problem with Configuration-> IT SERVICES-> Add server details-> server xxx click add server and show this error:

    [Trigger added]
    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 'on,0,off,99)' at line 1Query: insert into services (name,status,triggerid,algorithm,showsla,goodsla,s ortorder) values ('el servidor es inalcanzabble',0,12218,on,0,off,99)
    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 '1,0)' at line 1
    Query: insert into services_links (servicedownid,serviceupid,soft) values (,1,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 'on,0,off,99)' at line 1
    Query: insert into services (name,status,triggerid,algorithm,showsla,goodsla,s ortorder) values ('prueba',0,12209,on,0,off,99)
  • amcorreia
    Member
    • Mar 2006
    • 73

    #2
    Originally posted by debora
    I have a problem with Configuration-> IT SERVICES-> Add server details-> server xxx click add server and show this error:
    What version of zabbix you are running?

    Comment

    • debora
      Member
      • Jan 2006
      • 75

      #3
      I have zabbix 1.1 in debian 3.1 (stable) and mysql 4.1.11

      Comment

      • azilber
        Member
        • Apr 2005
        • 33

        #4
        Originally posted by debora
        I have a problem with Configuration-> IT SERVICES-> Add server details-> server xxx click add server and show this error:

        [Trigger added]
        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 'on,0,off,99)' at line 1Query: insert into services (name,status,triggerid,algorithm,showsla,goodsla,s ortorder) values ('el servidor es inalcanzabble',0,12218,on,0,off,99)
        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 '1,0)' at line 1
        Query: insert into services_links (servicedownid,serviceupid,soft) values (,1,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 'on,0,off,99)' at line 1
        Query: insert into services (name,status,triggerid,algorithm,showsla,goodsla,s ortorder) values ('prueba',0,12209,on,0,off,99)
        Make sure magic quotes are off in your php.ini.

        Code:
        ; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.
        magic_quotes_runtime = Off

        Comment

        • debora
          Member
          • Jan 2006
          • 75

          #5
          Is off, look:
          ; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.
          magic_quotes_runtime = Off

          Comment

          Working...