This forum is in READ-ONLY mode.
You can look around, but if you want to ask a new question, please use Stack Overflow.

1.4 not aware of the MYSQL version ?

Discussion relating to version 1.3.x and 1.4.x

1.4 not aware of the MYSQL version ?

by Otyugh2 » Tue May 01, 2012 9:24 pm

Hey,
when i tryed to install things on symfony, i get some :
(lot of generated things)
)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 15

and learning my MYSQL 5.5 i founded that :
Since version 5.5, MySQL changed the syntax of TYPE=INNODB to ENGINE=INNODB in DDL statements.
Otyugh2
Junior Member
 
Posts: 3
Joined: Fri Apr 27, 2012 3:44 pm

Re: 1.4 not aware of the MYSQL version ?

by Otyugh » Tue May 22, 2012 10:12 pm

I founded the fix.

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

Or go to SF version 1.5...

The problem is the version of Mysql that made change the declaration since the 5.5 i guess.
Otyugh
Junior Member
 
Posts: 3
Joined: Wed May 16, 2012 4:33 pm

Re: 1.4 not aware of the MYSQL version ?

by GianniErre » Fri Dec 27, 2013 7:50 pm

Wow, great, I had this same problem but after editing that MysqlDDLBuilder.php file and restarting Windows' cmd it worked.
I would have never figured this out for myself, this configuration stuff is definitely out of my grasp.
User avatar
GianniErre
Junior Member
 
Posts: 26
Joined: Sun Nov 24, 2013 5:42 pm

Re: 1.4 not aware of the MYSQL version ?

by smugford » Sun Jan 05, 2014 9:06 am

symfony 1.x on Windows is a brutal experience...from years on experience. Get your hands on a linux or mac machine.

My latest discovery is https://www.virtualbox.org/ which can run a "virtual version" of linux on a windows box. It literally is the best of both worlds
User avatar
smugford
Faithful Member
 
Posts: 245
Joined: Sun Nov 29, 2009 8:32 pm

Re: 1.4 not aware of the MYSQL version ?

by GianniErre » Wed Jan 08, 2014 6:12 pm

Sorry, wrong thread.
User avatar
GianniErre
Junior Member
 
Posts: 26
Joined: Sun Nov 24, 2013 5:42 pm