* JInstaller::install: Ошибка SQL DB function failed with error number 1064
You have an error in your SQL syntax near 'CHARACTER SET `utf8`' at line 12 SQL=CREATE TABLE IF NOT EXISTS `jos_redirection` ( `id` int(11) NOT NULL auto_increment, `cpt` int(11) NOT NULL default '0', `rank` int(11) NOT NULL default '0', `oldurl` varchar(255) NOT NULL default '', `newurl` varchar(255) NOT NULL default '', `dateadd` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`), KEY `newurl` (`newurl`), KEY `rank` (`rank`), KEY `oldurl` (`oldurl`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =
CREATE TABLE IF NOT EXISTS `jos_redirection` (
`id` int(11) NOT NULL auto_increment,
`cpt` int(11) NOT NULL default '0',
`rank` int(11) NOT NULL default '0',
`oldurl` varchar(255) NOT NULL default '',
`newurl` varchar(255) NOT NULL default '',
`dateadd` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`),
KEY `newurl` (`newurl`),
KEY `rank` (`rank`),
KEY `oldurl` (`oldurl`)
) TYPE=MyISAM CHARACTER SET `utf8`;
* Компонент Установить: Ошибка SQL DB function failed with error number 1064
You have an error in your SQL syntax near 'CHARACTER SET `utf8`' at line 12 SQL=CREATE TABLE IF NOT EXISTS `jos_redirection` ( `id` int(11) NOT NULL auto_increment, `cpt` int(11) NOT NULL default '0', `rank` int(11) NOT NULL default '0', `oldurl` varchar(255) NOT NULL default '', `newurl` varchar(255) NOT NULL default '', `dateadd` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`), KEY `newurl` (`newurl`), KEY `rank` (`rank`), KEY `oldurl` (`oldurl`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =
CREATE TABLE IF NOT EXISTS `jos_redirection` (
`id` int(11) NOT NULL auto_increment,
`cpt` int(11) NOT NULL default '0',
`rank` int(11) NOT NULL default '0',
`oldurl` varchar(255) NOT NULL default '',
`newurl` varchar(255) NOT NULL default '',
`dateadd` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`),
KEY `newurl` (`newurl`),
KEY `rank` (`rank`),
KEY `oldurl` (`oldurl`)
) TYPE=MyISAM CHARACTER SET `utf8`;