1.4 not aware of the MYSQL version ?

[Otyugh2]

Hey,
when i tryed to install things on symfony, i get some :
(lot of generated things)

)Type=InnoDB
[propel-sql-exec] 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 'Type=InnoDB' at line 15

and learning my MYSQL 5.5 i founded that :

Since version 5.5, MySQL changed the syntax of TYPE=INNODB to ENGINE=INNODB in DDL statements.

[Otyugh]

I founded the fix.

symfony/lib/plugins/sfPropelPlugin/lib/vendor/propel-generator/classes/propel/engine/builder /sql/mysql/MysqlDDLBuilder.php

Line 156, change it as follows:- $script .= “Engine=$mysqlTableType”;

Or go to SF version 1.5...

The problem is the version of Mysql that made change the declaration since the 5.5 i guess.