mysql - symfony 1.4 推进 :build-all not working on Mysql 5. 5

Question

我正在使用 Symfony 1.4.8 和 Mysql 5.5 运行时出现此错误

symfony 推进:构建全部

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 1 1

Answer 1

解决了这个问题。似乎在 DDL 中，您不能再说“Type=InnoDB|MyISAM|Foo”了。你必须说“Engine=InnoDB|MyISAM”所以编辑一个文件

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”;