Does not install on mySQL5.5

[cybersalt]

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

[Jan]

Ok, thank you for this info. I will add this for next versions.

Jan