JInstaller::install: SQL Error. 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 41 SQL=CREATE TABLE IF NOT EXISTS `ute_muscol_albums` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `artist_id` int(12) NOT NULL, `year` year(4) NOT NULL, `month` int(2) NOT NULL default '0', `edition_year` year(4) NOT NULL, `edition_month` int(2) NOT NULL, `edition_country` varchar(127) NOT NULL, `edition_details` varchar(255) NOT NULL, `genre_id` int(3) NOT NULL, `catalog_number` varchar(31) NOT NULL, `label` varchar(127) NOT NULL, `length` varchar(9) NOT NULL, `format_id` int(6) NOT NULL, `image` varchar(255) NOT NULL default 'no_image.jpg', `ndisc` int(11) NOT NULL default '1', `types` varchar(31) NOT NULL, `review` mediumtext NOT NULL, `name2` varchar(255) NOT NULL, `artist2` varchar(255) NOT NULL, `subtitle` varchar(255) NOT NULL, `subartist` varchar(255) NOT NULL, `fisic` varchar(4) NOT NULL default 'si', `points` tinyint(1) NOT NULL default '0', `added` datetime NOT NULL default '0000-00-00 00:00:00', `modified` datetime NOT NULL, `price` decimal(6,2) NOT NULL default '0.00', `tags` varchar(63) NOT NULL, `part_of_set` int(6) NOT NULL default '0', `show_separately` varchar(1) NOT NULL default 'Y', `params` mediumtext NOT NULL, `keywords` varchar(2048) NOT NULL, `user_id` int(6) NOT NULL, `hits` INT( 11 ) NOT NULL , `buy_link` VARCHAR( 255 ) NOT NULL , `album_file` VARCHAR( 255 ) NOT NULL , `metakeywords` text NOT NULL, `metadescription` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `ute_muscol_albums` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`artist_id` int(12) NOT NULL,
`year` year(4) NOT NULL,
`month` int(2) NOT NULL default '0',
`edition_year` year(4) NOT NULL,
`edition_month` int(2) NOT NULL,
`edition_country` varchar(127) NOT NULL,
`edition_details` varchar(255) NOT NULL,
`genre_id` int(3) NOT NULL,
`catalog_number` varchar(31) NOT NULL,
`label` varchar(127) NOT NULL,
`length` varchar(9) NOT NULL,
`format_id` int(6) NOT NULL,
`image` varchar(255) NOT NULL default 'no_image.jpg',
`ndisc` int(11) NOT NULL default '1',
`types` varchar(31) NOT NULL,
`review` mediumtext NOT NULL,
`name2` varchar(255) NOT NULL,
`artist2` varchar(255) NOT NULL,
`subtitle` varchar(255) NOT NULL,
`subartist` varchar(255) NOT NULL,
`fisic` varchar(4) NOT NULL default 'si',
`points` tinyint(1) NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL,
`price` decimal(6,2) NOT NULL default '0.00',
`tags` varchar(63) NOT NULL,
`part_of_set` int(6) NOT NULL default '0',
`show_separately` varchar(1) NOT NULL default 'Y',
`params` mediumtext NOT NULL,
`keywords` varchar(2048) NOT NULL,
`user_id` int(6) NOT NULL,
`hits` INT( 11 ) NOT NULL ,
`buy_link` VARCHAR( 255 ) NOT NULL ,
`album_file` VARCHAR( 255 ) NOT NULL ,
`metakeywords` text NOT NULL,
`metadescription` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;

Component Install: SQL error or missing or unreadable SQL 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 DEFAULT CHARSET=utf8' at line 41 SQL=CREATE TABLE IF NOT EXISTS `ute_muscol_albums` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `artist_id` int(12) NOT NULL, `year` year(4) NOT NULL, `month` int(2) NOT NULL default '0', `edition_year` year(4) NOT NULL, `edition_month` int(2) NOT NULL, `edition_country` varchar(127) NOT NULL, `edition_details` varchar(255) NOT NULL, `genre_id` int(3) NOT NULL, `catalog_number` varchar(31) NOT NULL, `label` varchar(127) NOT NULL, `length` varchar(9) NOT NULL, `format_id` int(6) NOT NULL, `image` varchar(255) NOT NULL default 'no_image.jpg', `ndisc` int(11) NOT NULL default '1', `types` varchar(31) NOT NULL, `review` mediumtext NOT NULL, `name2` varchar(255) NOT NULL, `artist2` varchar(255) NOT NULL, `subtitle` varchar(255) NOT NULL, `subartist` varchar(255) NOT NULL, `fisic` varchar(4) NOT NULL default 'si', `points` tinyint(1) NOT NULL default '0', `added` datetime NOT NULL default '0000-00-00 00:00:00', `modified` datetime NOT NULL, `price` decimal(6,2) NOT NULL default '0.00', `tags` varchar(63) NOT NULL, `part_of_set` int(6) NOT NULL default '0', `show_separately` varchar(1) NOT NULL default 'Y', `params` mediumtext NOT NULL, `keywords` varchar(2048) NOT NULL, `user_id` int(6) NOT NULL, `hits` INT( 11 ) NOT NULL , `buy_link` VARCHAR( 255 ) NOT NULL , `album_file` VARCHAR( 255 ) NOT NULL , `metakeywords` text NOT NULL, `metadescription` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `ute_muscol_albums` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`artist_id` int(12) NOT NULL,
`year` year(4) NOT NULL,
`month` int(2) NOT NULL default '0',
`edition_year` year(4) NOT NULL,
`edition_month` int(2) NOT NULL,
`edition_country` varchar(127) NOT NULL,
`edition_details` varchar(255) NOT NULL,
`genre_id` int(3) NOT NULL,
`catalog_number` varchar(31) NOT NULL,
`label` varchar(127) NOT NULL,
`length` varchar(9) NOT NULL,
`format_id` int(6) NOT NULL,
`image` varchar(255) NOT NULL default 'no_image.jpg',
`ndisc` int(11) NOT NULL default '1',
`types` varchar(31) NOT NULL,
`review` mediumtext NOT NULL,
`name2` varchar(255) NOT NULL,
`artist2` varchar(255) NOT NULL,
`subtitle` varchar(255) NOT NULL,
`subartist` varchar(255) NOT NULL,
`fisic` varchar(4) NOT NULL default 'si',
`points` tinyint(1) NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL,
`price` decimal(6,2) NOT NULL default '0.00',
`tags` varchar(63) NOT NULL,
`part_of_set` int(6) NOT NULL default '0',
`show_separately` varchar(1) NOT NULL default 'Y',
`params` mediumtext NOT NULL,
`keywords` varchar(2048) NOT NULL,
`user_id` int(6) NOT NULL,
`hits` INT( 11 ) NOT NULL ,
`buy_link` VARCHAR( 255 ) NOT NULL ,
`album_file` VARCHAR( 255 ) NOT NULL ,
`metakeywords` text NOT NULL,
`metadescription` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;