I got an error when doing doctrine:insert-sql, same story using doctrine:build-all.
The error message is:
SQLSTATE: 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.