error msg at installation?

hi there,

when trying to install events booking i get the following error message:



JInstaller: :Install: Error SQL DB function failed with error number 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 10 SQL=CREATE TABLE IF NOT EXISTS `t0r4j_eb_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `layout` varchar(50) DEFAULT NULL, `description` text, `ordering` int(11) DEFAULT NULL, `published` tinyint(3) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =
CREATE TABLE IF NOT EXISTS `#__eb_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`layout` varchar(50) DEFAULT NULL,
`description` text,
`ordering` int(11) DEFAULT NULL,
`published` tinyint(3) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM CHARACTER SET `utf8`;
Component Install: SQL error file DB function failed with error number 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 10 SQL=CREATE TABLE IF NOT EXISTS `t0r4j_eb_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `layout` varchar(50) DEFAULT NULL, `description` text, `ordering` int(11) DEFAULT NULL, `published` tinyint(3) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =
CREATE TABLE IF NOT EXISTS `#__eb_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`layout` varchar(50) DEFAULT NULL,
`description` text,
`ordering` int(11) DEFAULT NULL,
`published` tinyint(3) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM CHARACTER SET `utf8`;


can somebody please help me figure out why i get this error / how i can get rid of it?
Using Joomla 1.6, trying to install com_eventbooking.zip (also tried the unzipped version, but i get the same error message).

thanks!

Hi

It must be something with Mysql verison of your server. Could you please submit a support ticket give me administrator and FTP account of your site so that I can help you to install it ?

Regards,

Tuan

Hi Tuan,

Thx for offering to install it for me!

I found a different solution to the problem that i want to share, may be it helps sb else? I got the above error message with a local installation, using MAMP, php 5.3.6.

So to enable you to install this extension for me I uploaded my joomla site to the host I was going to use. After some initial problems of getting the ftp to run properly via joomla (file owner, file premissions) to upload the zip file, the extension installed beautifully & easy on the non-local version of the page.

Gonna try now if it works better if i use different settings @ MAMP - would prefer to keep my joomla page offline until it is ready. Either way seems that MAMP is the problem, not the extension or joomla. So if sb out there has the same problem, check your XAMPP / MAMP / whatever settings. If i can get the installation process to run on MAMP aswell (as said, i prefer doing all of that offline) I'll let you know what settings make it work


take care,
A