Sorry, wrong forum...
Hi,
I'm trying to install zabbix 1.3.2. I'm using a winxp box with mysql 5.0.27.
When creating the schema, I received some errors telling me that the blob fields didn't allow the "default" keyword. So I removed it and I was abble to create it.
Now, I'm trying to populate the database, using the data.sql file, but I got some errors to. I receive the following error: ERROR 1264 (22003) at line 56: Out of range value adjusted for column 'type' at row 1
Looking at the script it's trying to insert this: INSERT INTO rights VALUES (1,1,'Default permission','U',0);
But, the schema.sql created the rights table with the following statements: CREATE TABLE rights (
rightid bigint unsigned DEFAULT '0' NOT NULL,
groupid bigint unsigned DEFAULT '0' NOT NULL,
type integer DEFAULT '0' NOT NULL,
permission integer DEFAULT '0' NOT NULL,
id bigint unsigned ,
PRIMARY KEY (rightid)
);
So, as long I can see, it will never work...
Am I doing something wrong? Because I can see that people are testing it.
Hi,
I'm trying to install zabbix 1.3.2. I'm using a winxp box with mysql 5.0.27.
When creating the schema, I received some errors telling me that the blob fields didn't allow the "default" keyword. So I removed it and I was abble to create it.
Now, I'm trying to populate the database, using the data.sql file, but I got some errors to. I receive the following error: ERROR 1264 (22003) at line 56: Out of range value adjusted for column 'type' at row 1
Looking at the script it's trying to insert this: INSERT INTO rights VALUES (1,1,'Default permission','U',0);
But, the schema.sql created the rights table with the following statements: CREATE TABLE rights (
rightid bigint unsigned DEFAULT '0' NOT NULL,
groupid bigint unsigned DEFAULT '0' NOT NULL,
type integer DEFAULT '0' NOT NULL,
permission integer DEFAULT '0' NOT NULL,
id bigint unsigned ,
PRIMARY KEY (rightid)
);
So, as long I can see, it will never work...
Am I doing something wrong? Because I can see that people are testing it.