Got error when doing doctrine:insert-sql

[davidqi]

I got an error when doing doctrine:insert-sql, same story using doctrine:build-all.

The error message is:
SQLSTATE[42000]: Syntax error or access violation: 1064 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 '1 INT, v TINYINT, h TINYINT, PRIMARY KEY(db_name, table_name)) ENGINE = INNODB' at line 1. Failing Query: CREATE TABLE pma_designer_coords (db_name VARCHAR(64), table_name VARCHAR(64), x INT, 1 INT, v TINYINT, h TINYINT, PRIMARY KEY(db_name, table_name)) ENGINE = INNODB

The query to create pma_designer_coords table is built in data/sql/schema.sql by symfony1.3 when runing doctrine:build-sql.

I can not figure out what's wrong. Please help.

MySql Server version is 5.1.3.

Thx.

[gil_]

I got an error when doing doctrine:insert-sql, same story using doctrine:build-all.

The error message is:
SQLSTATE[42000]: Syntax error or access violation: 1064 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 '1 INT, v TINYINT, h TINYINT, PRIMARY KEY(db_name, table_name)) ENGINE = INNODB' at line 1. Failing Query: CREATE TABLE pma_designer_coords (db_name VARCHAR(64), table_name VARCHAR(64), x INT, 1 INT, v TINYINT, h TINYINT, PRIMARY KEY(db_name, table_name)) ENGINE = INNODB

The query to create pma_designer_coords table is built in data/sql/schema.sql by symfony1.3 when runing doctrine:build-sql.

I can not figure out what's wrong. Please help.

MySql Server version is 5.1.3.

Thx.

"1 INT" is strange. And the error is the same as if you were using "1" instead of "l".