Ad Widget

Collapse

ZABBIX1.7.2 db insert error where initialize

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • j-luo
    Junior Member
    • Nov 2009
    • 7

    #1

    ZABBIX1.7.2 db insert error where initialize

    I want to install zabbix 1.7.2 on CentOS5.4 with mysql 5.0

    following the manual,
    1. run mysql.sql to init db layout,
    table [items] is created at line 692-734, with 40 fields
    2. run data.sql to init db data
    at line 506, the script want to insert table items a data with 41 values
    3. so i meet the error 1136
    ----------------------------------------
    ERROR 1136(21S01) at line 506: Column count doesn't match value count at
    row 1
    ----------------------------------------

    since i can not initialize the db, i can not go further
    what can i do to solve the problem?
  • richlv
    Senior Member
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Oct 2005
    • 3112

    #2
    this should be fixed in trunk, rev 8315
    Zabbix 3.0 Network Monitoring book

    Comment

    • richlv
      Senior Member
      Zabbix Certified Trainer
      Zabbix Certified SpecialistZabbix Certified Professional
      • Oct 2005
      • 3112

      #3
      to make things a bit easier, here's data.sql from that revision : http://www.zabbix.com/wiki/_media/co...a.sql-8315.bz2
      Zabbix 3.0 Network Monitoring book

      Comment

      • j-luo
        Junior Member
        • Nov 2009
        • 7

        #4
        thanks

        i will try the new data.sql today

        Comment

        Working...