Found in an old thread: > On Wed, Mar 9, 2011 at 12:43 PM, James Lawton > <[email protected]> > wrote: >> Ahhh...just found a change in the MySQL manuals >> >> ==================================== >> >> Section 5.1.7, "Server SQL Modes". >> >> Note >> The older TYPE option was synonymous with ENGINE. TYPE was deprecated >> in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or >> later, you must convert existing applications that rely on TYPE to >> use ENGINE instead. >>
I don't know if OFBiz trunk/11.04 were ever updated to work with the later versions of MySql, but since BigFish is based on 10.04, this may be the problem. It's another good reason to use postgresql over mysql.
