Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

symfony 1.4 propel:build-all not working on Mysql 5.5

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

symfony propel:build-all

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

like image 968
Bhanu Krishnan Avatar asked Feb 18 '11 11:02

Bhanu Krishnan


2 Answers

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

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

like image 145
Bhanu Krishnan Avatar answered Oct 04 '22 12:10

Bhanu Krishnan


A good (better) alternative to manually patching sfPropelPlugin is to upgrade to Propel 1.5 with the sfPropel15Plugin. It doesn't have this issue with MySQL 5.5

like image 20
Nathan Avatar answered Oct 04 '22 12:10

Nathan