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!
