symfony 1.4 propel:build-all在MySQL 5.5上不起作用 [英] symfony 1.4 propel:build-all not working on Mysql 5.5

问题描述

我正在使用Symfony 1.4.8和Mysql 5.5 我在运行

i am using Symfony 1.4.8 and Mysql 5.5 i got this error when i run

symfony propel:全部构建

symfony propel:build-all

您的SQL语法有错误； 检查对应的手册 您的MySQL服务器版本 在"Type = InnoDB"附近使用正确的语法 在第1 1行

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

推荐答案

解决了该问题. 似乎在DDL中，您不再可以说"Type = InnoDB | MyISAM | Foo".您必须说"Engine = InnoDB | MyISAM" 所以编辑一个文件

Fixed the issue. It seems that in the DDL, you can’t say "Type=InnoDB|MyISAM|Foo" anymore. You have to say "Engine=InnoDB|MyISAM" so edit one file

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

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

第156行，如下更改:- $脚本 .="Engine = $ mysqlTableType";

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

这篇关于symfony 1.4 propel:build-all在MySQL 5.5上不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！