开发者

Symfony: creating invalid MySQL code?

开发者 https://www.devze.com 2023-03-06 06:02 出处:网络
I\'m reading the Symfony documentation (Practical Symfony), and I finished creating the SQL code with propel.

I'm reading the Symfony documentation (Practical Symfony), and I finished creating the SQL code with propel.

But when i try to

$ symfony propel:insert-sql

the MySQL complains with:

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

Snippet of the produced MySQL code:

CREATE TABLE `jobeet_category` (
`id` INTEGER NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 255 ) ,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `jobe开发者_运维百科et_category_U_1` ( `name` )
) TYPE = InnoDB;

So the problem is TYPE = InnoDB;, but I don't understand why did propel produce invalid code.

I followed all the instructions in the book, I'm not sure what could be the problem - maybe the MySQL version I have?

Edit: I found my answer. http://zippykid.com/2010/05/symfony-mysql5-5-error/


I'm pretty sure it should be ENGINE = InnoDB instead of type.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号