ood evening to all!
I have a problem installing a component (clan tools) as well as a package that folder ...

JInstaller::install: Errore 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 DEFAULT CHARSET='utf8'' at line 13 SQL=CREATE TABLE IF NOT EXISTS `jos_ct_awards` ( `id` smallint(6) NOT NULL auto_increment, `uid` smallint(6) NOT NULL , `sid` smallint(6) NOT NULL , `alt_squad` varchar(40) NOT NULL , `platz` char(2) NOT NULL , `beschreibung` text NOT NULL , `event` varchar(50) NOT NULL , `turnier` varchar(50) NOT NULL, `url` varchar(255) NOT NULL , `published` char(2) NOT NULL default '0', `datum` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`)) Type=MyISAM DEFAULT CHARSET='utf8';
SQL =

CREATE TABLE IF NOT EXISTS `jos_ct_awards` ( `id` smallint(6) NOT NULL auto_increment, `uid` smallint(6) NOT NULL , `sid` smallint(6) NOT NULL , `alt_squad` varchar(40) NOT NULL , `platz` char(2) NOT NULL , `beschreibung` text NOT NULL , `event` varchar(50) NOT NULL , `turnier` varchar(50) NOT NULL, `url` varchar(255) NOT NULL , `published` char(2) NOT NULL default '0', `datum` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`)) Type=MyISAM DEFAULT CHARSET='utf8';

componente Installa: Errore 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 DEFAULT CHARSET='utf8'' at line 13 SQL=CREATE TABLE IF NOT EXISTS `jos_ct_awards` ( `id` smallint(6) NOT NULL auto_increment, `uid` smallint(6) NOT NULL , `sid` smallint(6) NOT NULL , `alt_squad` varchar(40) NOT NULL , `platz` char(2) NOT NULL , `beschreibung` text NOT NULL , `event` varchar(50) NOT NULL , `turnier` varchar(50) NOT NULL, `url` varchar(255) NOT NULL , `published` char(2) NOT NULL default '0', `datum` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`)) Type=MyISAM DEFAULT CHARSET='utf8';
SQL =

CREATE TABLE IF NOT EXISTS `jos_ct_awards` ( `id` smallint(6) NOT NULL auto_increment, `uid` smallint(6) NOT NULL , `sid` smallint(6) NOT NULL , `alt_squad` varchar(40) NOT NULL , `platz` char(2) NOT NULL , `beschreibung` text NOT NULL , `event` varchar(50) NOT NULL , `turnier` varchar(50) NOT NULL, `url` varchar(255) NOT NULL , `published` char(2) NOT NULL default '0', `datum` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`)) Type=MyISAM DEFAULT CHARSET='utf8';

I had the same problem with community builder but I solved installing from a folder, not this time