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 » 13 Feb 2011, 13:40

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: 41777
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: SQL syntax error 1064

Post by Jan » 13 Feb 2011, 16:23

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 » 13 Feb 2011, 17:07

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: 41777
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: SQL syntax error 1064

Post by Jan » 14 Feb 2011, 18:16

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