| 
| 
Błąd podczas instalacji komponentu tagmeta 1.2
Podczas instalacji komponentu tag meta w wersji 1.2 na serwerach home.pl występuje problem z bazą danych :
* 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;
Proponowane rozwiązanie:
Przed instalacją komponentu, w pliku intalacyjnym tagmeta.xml należy zamienić:
type=MyISAM default CHARSET=utf8;
na
ENGINE=MyISAM default CHARSET=utf8;
Po tej operacji można bez problemu zainstalować komponent w zapleczu joomla.
| następna » |
|---|
