Zabbix database creation [Archive]

alanjay

25-01-2006, 08:52

Hi,

After trying the 1.1beta and it not compiling I wnet back and tried 1.0 on compilation and installation went fine up to the point where I wanted to create the database following your instructions (which are fine except the "|" looks like a "\" :) ) all went well until copying the data.

Creating the schema went fine but addign the data resulted in:

ERROR 1136 at line 24: Column count doesn't match value count at row 1

I am using mySQL 4.1.16; FreeBSD 4.9; PHP 4.4.2

PS Thanks for the very fast response on the problems with the beta.

alanjay

25-01-2006, 15:59

This seemed to be implying that the data is already in place but this is with a brand new database created from scratch. Not sure what I have done wrong on this.

Also once loaded and running in the Houskeeping Confguration trying to update the database gives:

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 'alert_history=350,refresh_unsupported=' at line 1
Query: update config set alarm_history=,alert_history=350,refresh_unsupport ed=