Hi, can you help me please, I have tried to install the Tag Meta component using the Install/Uninstall menu in Joomla 1.5 and I get the message below, what does it mean?
---------------------------------------------------------
* 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 'default CHARSET=utf8' at line 18 SQL=CREATE TABLE IF NOT EXISTS `jos_tagmeta` ( `id` int(11) NOT NULL auto_increment, `uri` varchar(255) NOT NULL default '', `title` varchar(70) default NULL, `description` varchar(160) default NULL, `keywords` varchar(160) default NULL, `rindex` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip', `rfollow` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip', `rsnippet` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip', `rarchive` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip', `rodp` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip', `ordering` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `idxuri` (`uri`) ) type=MyISAM default CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_tagmeta` (
`id` int(11) NOT NULL auto_increment,
`uri` varchar(255) NOT NULL default '',
`title` varchar(70) default NULL,
`description` varchar(160) default NULL,
`keywords` varchar(160) default NULL,
`rindex` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip',
`rfollow` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip',
`rsnippet` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip',
`rarchive` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip',
`rodp` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `idxuri` (`uri`)
) type=MyISAM default CHARSET=utf8;
* Component 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 'default CHARSET=utf8' at line 18 SQL=CREATE TABLE IF NOT EXISTS `jos_tagmeta` ( `id` int(11) NOT NULL auto_increment, `uri` varchar(255) NOT NULL default '', `title` varchar(70) default NULL, `description` varchar(160) default NULL, `keywords` varchar(160) default NULL, `rindex` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip', `rfollow` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip', `rsnippet` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip', `rarchive` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip', `rodp` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip', `ordering` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `idxuri` (`uri`) ) type=MyISAM default CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_tagmeta` (
`id` int(11) NOT NULL auto_increment,
`uri` varchar(255) NOT NULL default '',
`title` varchar(70) default NULL,
`description` varchar(160) default NULL,
`keywords` varchar(160) default NULL,
`rindex` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip',
`rfollow` tinyint(1) NOT NULL default '1' COMMENT '0=No,1=Yes,2=Skip',
`rsnippet` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip',
`rarchive` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip',
`rodp` tinyint(1) NOT NULL default '2' COMMENT '0=No,1=Yes,2=Skip',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `idxuri` (`uri`)
) type=MyISAM default CHARSET=utf8;