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.
SQL syntax error 1064
- Jan
- Phoca Hero
- Posts: 47870
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: SQL syntax error 1064
Hi, which version of database you are running, some newest versions needs engine instead of type so replacing "type" to "engine" will help.
Jan
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Newbie
- Posts: 2
- Joined: 13 Feb 2011, 13:34
Re: SQL syntax error 1064
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?
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?
- Jan
- Phoca Hero
- Posts: 47870
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: SQL syntax error 1064
Hi, normally the sql queries for installing are stored in controllers:
administrator/components/com_phocagallery/controllers/phocagalleryinstall.php
Jan
administrator/components/com_phocagallery/controllers/phocagalleryinstall.php
Jan
If you find Phoca extensions useful, please support the project