Erro de instalação do Componente QuikFAQ

  • Lourdilene
  • Avatar de Lourdilene Autor do Tópico
  • Offline
  • JCB! Estagiário
  • JCB! Estagiário
Mais
14 anos 1 mês atrás #54946 por Lourdilene
Lourdilene created the topic: Erro de instalação do Componente QuikFAQ
Olá pessoal,

Quando vou instalar o componente ora citado aparece a seguinte mensagem:

JInstaller::install: Erro do SQL. 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 CHARACTER SET `utf8` COLLATE `utf8_general_ci`' at line 16 SQL=CREATE TABLE IF NOT EXISTS `jos_quickfaq_categories` ( `id` int(11) unsigned NOT NULL auto_increment, `parent_id` int(11) unsigned NOT NULL default '0', `title` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `text` mediumtext NOT NULL, `meta_keywords` text NOT NULL, `meta_description` text NOT NULL, `image` text NOT NULL default '', `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `access` int(11) unsigned NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =

CREATE TABLE IF NOT EXISTS `jos_quickfaq_categories` (
`id` int(11) unsigned NOT NULL auto_increment,
`parent_id` int(11) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`text` mediumtext NOT NULL,
`meta_keywords` text NOT NULL,
`meta_description` text NOT NULL,
`image` text NOT NULL default '',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`access` int(11) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

Componente Instalar: Arquivo SQL com erro, inexistente ou inacessível para leitura. 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 CHARACTER SET `utf8` COLLATE `utf8_general_ci`' at line 16 SQL=CREATE TABLE IF NOT EXISTS `jos_quickfaq_categories` ( `id` int(11) unsigned NOT NULL auto_increment, `parent_id` int(11) unsigned NOT NULL default '0', `title` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `text` mediumtext NOT NULL, `meta_keywords` text NOT NULL, `meta_description` text NOT NULL, `image` text NOT NULL default '', `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `access` int(11) unsigned NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =

CREATE TABLE IF NOT EXISTS `jos_quickfaq_categories` (
`id` int(11) unsigned NOT NULL auto_increment,
`parent_id` int(11) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`text` mediumtext NOT NULL,
`meta_keywords` text NOT NULL,
`meta_description` text NOT NULL,
`image` text NOT NULL default '',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`access` int(11) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;


Como devo proceder neste caso <!-- s:? --><img src="{SMILIES_PATH}/icon_e_confused.gif" alt=":?" title="Confuso" /><!-- s:? --> Muito Obrigada.

Please Entrar ou Registrar to join the conversation.