basic user question on install

Hi All

Im getting this error when uploading events booking to Joomla. Can someone please decipher what this means and how I fix it.

Thanks

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`;

Hi

I think you are using an old version of Mysql and it causes the error. To fix the issue, please follow the instruction below :

- Unzip the file com_eventbooking.zip which you you can see from download package which you downloaded .

- Find the file install.eventbooking.sql in the folder admin/sql .

- Open the file in a text editor .

- Find TYPE=MyISAM and replace it with ENGINE = MyISAM . Save the file .

- Zip the folder com_eventbooking again and reinstall it . It should install properly .

If you still having trouble with the installation, please submit a support ticket contains administrator account of your site so that I can install it for you .

Regards,

Tuan