- Postagens: 14
- Obrigados Recebidos: 0
Erro de instalação do Componente QuikFAQ
- Lourdilene
-
Autor do Tópico
- Offline
- JCB! Estagiário
-
Menos
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.
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="

Please Entrar ou Registrar to join the conversation.