mySql problem when installing ARTIO JoomSEF for Joomla

Status
Not open for further replies.
G

graphismologie

New Member
Messages
11
Reaction score
0
Points
0
Hello, i have tried install the component ARTIO JoomSEF, but i get the following errors :

JInstaller::install: Erreur SQL. DB function failed with error number 2013
Lost connection to MySQL server during query SQL=CREATE TABLE IF NOT EXISTS `jos_sefurls` ( `id` int(11) NOT NULL auto_increment, `cpt` int(11) NOT NULL default '0', `sefurl` varchar(255) NOT NULL, `origurl` varchar(255) COLLATE utf8_bin NOT NULL, `Itemid` varchar(20) default NULL, `metadesc` varchar(255) default '', `metakey` varchar(255) default '', `metatitle` varchar(255) default '', `metalang` varchar(30) default '', `metarobots` varchar(30) default '', `metagoogle` varchar(30) default '', `metacustom` TEXT, `canonicallink` varchar(255) default '', `dateadd` date NOT NULL default '0000-00-00', `priority` int(11) NOT NULL DEFAULT '0', `trace` text DEFAULT NULL, `enabled` TINYINT(1) NOT NULL DEFAULT '1', `locked` TINYINT(1) NOT NULL DEFAULT '0', `sef` TINYINT(1) NOT NULL DEFAULT '1', `sm_indexed` TINYINT(1) NOT NULL DEFAULT '0', `sm_date` DATE NOT NULL DEFAULT '0000-00-00', `sm_frequency` VARCHAR(20) NOT NULL DEFAULT 'weekly', `sm_priority` VARCHAR(10) NOT NULL DEFAULT '0.5', `trashed` TINYINT(1) NOT NULL DEFAULT '0', `flag` TINYINT(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `sefurl` (`sefurl`), KEY `origurl` (`origurl`, `Itemid`) ) TYPE=MyISAM
SQL =
CREATE TABLE IF NOT EXISTS `jos_sefurls` (
`id` int(11) NOT NULL auto_increment,
`cpt` int(11) NOT NULL default '0',
`sefurl` varchar(255) NOT NULL,
`origurl` varchar(255) COLLATE utf8_bin NOT NULL,
`Itemid` varchar(20) default NULL,
`metadesc` varchar(255) default '',
`metakey` varchar(255) default '',
`metatitle` varchar(255) default '',
`metalang` varchar(30) default '',
`metarobots` varchar(30) default '',
`metagoogle` varchar(30) default '',
`metacustom` TEXT,
`canonicallink` varchar(255) default '',
`dateadd` date NOT NULL default '0000-00-00',
`priority` int(11) NOT NULL DEFAULT '0',
`trace` text DEFAULT NULL,
`enabled` TINYINT(1) NOT NULL DEFAULT '1',
`locked` TINYINT(1) NOT NULL DEFAULT '0',
`sef` TINYINT(1) NOT NULL DEFAULT '1',
`sm_indexed` TINYINT(1) NOT NULL DEFAULT '0',
`sm_date` DATE NOT NULL DEFAULT '0000-00-00',
`sm_frequency` VARCHAR(20) NOT NULL DEFAULT 'weekly',
`sm_priority` VARCHAR(10) NOT NULL DEFAULT '0.5',
`trashed` TINYINT(1) NOT NULL DEFAULT '0',
`flag` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `sefurl` (`sefurl`),
KEY `origurl` (`origurl`, `Itemid`)
) TYPE=MyISAM
Composant Installation: Erreur SQL ou fichier sql absent ou illisible. DB function failed with error number 2013
Lost connection to MySQL server during query SQL=CREATE TABLE IF NOT EXISTS `jos_sefurls` ( `id` int(11) NOT NULL auto_increment, `cpt` int(11) NOT NULL default '0', `sefurl` varchar(255) NOT NULL, `origurl` varchar(255) COLLATE utf8_bin NOT NULL, `Itemid` varchar(20) default NULL, `metadesc` varchar(255) default '', `metakey` varchar(255) default '', `metatitle` varchar(255) default '', `metalang` varchar(30) default '', `metarobots` varchar(30) default '', `metagoogle` varchar(30) default '', `metacustom` TEXT, `canonicallink` varchar(255) default '', `dateadd` date NOT NULL default '0000-00-00', `priority` int(11) NOT NULL DEFAULT '0', `trace` text DEFAULT NULL, `enabled` TINYINT(1) NOT NULL DEFAULT '1', `locked` TINYINT(1) NOT NULL DEFAULT '0', `sef` TINYINT(1) NOT NULL DEFAULT '1', `sm_indexed` TINYINT(1) NOT NULL DEFAULT '0', `sm_date` DATE NOT NULL DEFAULT '0000-00-00', `sm_frequency` VARCHAR(20) NOT NULL DEFAULT 'weekly', `sm_priority` VARCHAR(10) NOT NULL DEFAULT '0.5', `trashed` TINYINT(1) NOT NULL DEFAULT '0', `flag` TINYINT(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `sefurl` (`sefurl`), KEY `origurl` (`origurl`, `Itemid`) ) TYPE=MyISAM
SQL =
CREATE TABLE IF NOT EXISTS `jos_sefurls` (
`id` int(11) NOT NULL auto_increment,
`cpt` int(11) NOT NULL default '0',
`sefurl` varchar(255) NOT NULL,
`origurl` varchar(255) COLLATE utf8_bin NOT NULL,
`Itemid` varchar(20) default NULL,
`metadesc` varchar(255) default '',
`metakey` varchar(255) default '',
`metatitle` varchar(255) default '',
`metalang` varchar(30) default '',
`metarobots` varchar(30) default '',
`metagoogle` varchar(30) default '',
`metacustom` TEXT,
`canonicallink` varchar(255) default '',
`dateadd` date NOT NULL default '0000-00-00',
`priority` int(11) NOT NULL DEFAULT '0',
`trace` text DEFAULT NULL,
`enabled` TINYINT(1) NOT NULL DEFAULT '1',
`locked` TINYINT(1) NOT NULL DEFAULT '0',
`sef` TINYINT(1) NOT NULL DEFAULT '1',
`sm_indexed` TINYINT(1) NOT NULL DEFAULT '0',
`sm_date` DATE NOT NULL DEFAULT '0000-00-00',
`sm_frequency` VARCHAR(20) NOT NULL DEFAULT 'weekly',
`sm_priority` VARCHAR(10) NOT NULL DEFAULT '0.5',
`trashed` TINYINT(1) NOT NULL DEFAULT '0',
`flag` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `sefurl` (`sefurl`),
KEY `origurl` (`origurl`, `Itemid`)
) TYPE=MyISAM
Click to expand...

I think this is a timeout problem, but i don't know how to fix it. I have tried this plugin on my local installation, and it work very well.
 
Status
Not open for further replies.
Top