Ad Widget

Collapse

Alpha11 MySQL error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Neo
    Member
    • Jun 2005
    • 59

    #1

    Alpha11 MySQL error

    I was trying to install Alpha11 and get this error.
    ERROR 1064 (42000): 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 'lob DEFAULT '' NOT NULL,
    PRIMARY KEY (hostid)
    ) type=InnoDB' at line 13
    when I tried to execute the following.
    Code:
    cat schema.sql | mysql -u root zabbix11
    Is Alpha 11 broken? or is there something wrong with my DB setup?
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    Replace lob by blob to fix this problem. Sorry for inconvinience.
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • Neo
      Member
      • Jun 2005
      • 59

      #3
      Whoops! thanks Alexei. Hope it's corrected in the package that is available for download

      Comment

      Working...