SQL syntax error 1064

Phoca Gallery - image gallery extension
irek
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 13 Feb 2011, 13:34

SQL syntax error 1064

Post by irek »

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.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: SQL syntax error 1064

Post by Jan »

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

Jan
If you find Phoca extensions useful, please support the project
irek
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 13 Feb 2011, 13:34

Re: SQL syntax error 1064

Post by irek »

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?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: SQL syntax error 1064

Post by Jan »

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

administrator/components/com_phocagallery/controllers/phocagalleryinstall.php

Jan
If you find Phoca extensions useful, please support the project
Post Reply