Does not install on mySQL5.5
Posted: 21 Jan 2011, 08:05
I just tired to install phoca gallery on to a site running on mysql5.5 (which is out and stable now) and it failed with
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=MyISAM CHARACTER SET `utf8`' blah, blah, blah.
Mysql5.5 no longer accepts the sql command "TYPE=" .
"ENGINE=" does work in mySQL5.5 and also works backwards all the way to mysql5.0 and maybe some 4.0.
If you use "ENGINE=" instead of "TYPE=" in Phoca Gallery SQL command files (and other components), install will complete without error on all mySQL versions
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=MyISAM CHARACTER SET `utf8`' blah, blah, blah.
Mysql5.5 no longer accepts the sql command "TYPE=" .
"ENGINE=" does work in mySQL5.5 and also works backwards all the way to mysql5.0 and maybe some 4.0.
If you use "ENGINE=" instead of "TYPE=" in Phoca Gallery SQL command files (and other components), install will complete without error on all mySQL versions