Ad Widget

Collapse

what meants this? please help me

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

    #1

    what meants this? please help me

    This happens when i add details the a server and Link to Service 1 in the IT SERVICES configuration:

    Code:
    Error in query [select count(*) as cnt from services_links where servicedownid= and soft=0] [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 soft=0' at line 1]
    And Link to Service 1 in the IT SERVICES configuration:

    Code:
    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 '5,1)' at line 1
  • raminix
    Member
    • Jun 2006
    • 37

    #2
    Did you by any chance use a single quote ( ' ) in any of the data you keyed in for the server? It sounds like your query is broken due to a stray encapsulation character.

    Comment

    • debora
      Member
      • Jan 2006
      • 75

      #3
      But where is? in data.sql or schema.sql

      Comment

      • Alexei
        Founder, CEO
        Zabbix Certified Trainer
        Zabbix Certified SpecialistZabbix Certified Professional
        • Sep 2004
        • 5654

        #4
        Originally posted by debora
        This happens when i add details the a server and Link to Service 1 in the IT SERVICES configuration:

        ...
        It looks like a bug to me, it will be fixed by 1.1.2 (next minor stable).
        Alexei Vladishev
        Creator of Zabbix, Product manager
        New York | Tokyo | Riga
        My Twitter

        Comment

        Working...