Phoca Forum

Hi I am installing component on Joomla 1,5 and I had serverall errors reported by application and related to table creation.
I have tried to create tables manually from phpMyAdmin and I am geting listed below error.

#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=MyISAM CHARACTER SET `utf8`' at line 37

Please advice how to correct installation script to solve the issue.

Hi, which version of database you are running, some newest versions needs engine instead of type so replacing "type" to "engine" will help.

Jan

Hi I have server version 5.5.8.
I did the change from TYPE to ENGINE and it works with manual execution but when I changed it in install.bat zip it and install I have again the same error. Shell I change something else?

Hi, normally the sql queries for installing are stored in controllers:

administrator/components/com_phocagallery/controllers/phocagalleryinstall.php

Jan