Problems with database creation

[bobrivers]

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.

[Alexei]

Thanks for reporting this. For some strange reason the SQL statements work perfectly on other versions of MySQL. It has to be fixed anyway.

[bobrivers]

Worked with MySQL 4.1.22

Hi,

Thanks for replying.

I did a downgrade from 5.0.22 to 4.1.22 and it worked. The same scripts that failed before...