[propel-sql-exec] SQLSTATE[42000]: Syntax error or access violation: 106 you have an error in your SQL syntax; check the manual that corresponds to you
server version for the right syntax to use near ‘Type=InnoDB’ at line 16
>> propel Running “insert-sql” phing task
[propel-sql-exec] Failed to execute:
CREATE TABLE `tblName`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`description` TEXT,
`image` VARCHAR(255),
`created_at` DATETIME,
PRIMARY KEY (`id`),
)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 16
Some problems occurred when executing the task:
If the exception message is not clear enough, read the output of the task for more information
>> file- D:/xampp/htdocs/s…1_4/config/generated-schema.xml
The solution to this is
Edit the file D:/xampp/htdocs/symfony_1_4/lib/vendor/symfony/lib/plugins/sfPropelPlugin/lib/vendor/propel-generator/classes/propel/engine/builder/sql/mysql/MysqlDDLBuilder.php
Line 156, change
$script .= “Type=$mysqlTableType”;
to
$script .= “Engine=$mysqlTableType”;
Vinod Ram has been in Software Industry since 2006 and has experience of over 16 years in Software Development & Project Management domain specialised majorly in LAMP stack & Open Source Technology, building enterprise level Web based Application, Large Database driven and huge traffic Websites and Project Management.
He loves to write information articles and blog to share his knowledge and experience with the outside world and help people to find solution for their problems.
Great!! It solve a very tedious problem !!!!
I wont find the solution without you, thanks for help!
Merci !!!
well not working for me, i keep getting the same error… any other ideas?
Yeah, exactly what I needed!! 🙂
Thaanks is working. For anyone out-there whoś not working you should run propel:build-sql and them propel:insert-sql
I have been pulling my hair out for hours with this and this finally worked for me so thank you!
Also thanks to Raulucco,
Thanks. I wasted so much time with this problem. Finally thanks to you I solved it.
Thank you !
It works!! Thx!!!
I really tried to solve this problem since 3 days, but i couldn’t get any solution. I can’t found what’s actually problem.. Any idea…I tried all possible ways to resolve it but still nothing to get.
Have you loaded PDO and PDO Mysql?
Verify in your php.ini , if its enabled or not?
Also make sure “xml” extension is enabled.
Thanks
Admin
I tried it all day. Thank !
this approach didn’t work to me…any other ideias to fix this issue?