Erro componente Autostand (Ajuda)

Início
Ant
1
Próximo
Fim

ha0015
Autor do Tópico
Offline
JCB! Iniciante

Mais

11 anos 7 meses atrás #80684 por ha0015

ha0015 created the topic: Erro componente Autostand (Ajuda)

Boa Tarde !

Gostaria de saber se alguem poderia me ajudar com a instalação do componente Autostand v.2.6

A instalação ocasiona esse erro de mysql alguém já teve a mesma experiência ??

Versão do joomla: 1.5.13
servidor: Hostgator

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 82 SQL=CREATE TABLE IF NOT EXISTS `jos_autostand` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `imgtitle` text NOT NULL, `imgauthor` varchar(50) default NULL, `vin` varchar(50) default NULL, `imgtext` text NOT NULL, `imgdate` varchar(20) default NULL, `imgcounter` int(11) NOT NULL default '0', `imgvotes` int(11) NOT NULL default '0', `imgvotesum` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `imgfilename` varchar(50) default '', `imgthumbname` varchar(50) default '', `checked_out` int(11) NOT NULL default '0', `price` varchar(20) default NULL, `make` varchar(50) default NULL, `doors` varchar(20) default NULL, `fuel` varchar(20) default NULL, `gearbox` varchar(20) default NULL, `notes` text, `expic1` varchar(50) default '', `expic1_tn` varchar(50) default '', `expic2` varchar(50) default '', `expic2_tn` varchar(50) default '', `expic3` varchar(50) default '', `expic3_tn` varchar(50) default '', `expic4` varchar(50) default '', `expic4_tn` varchar(50) default '', `expic5` varchar(50) default '', `expic5_tn` varchar(50) default '', `expic6` varchar(50) default '', `expic6_tn` varchar(50) default '', `expic7` varchar(50) default '', `expic7_tn` varchar(50) default '', `expic8` varchar(50) default '', `expic8_tn` varchar(50) default '', `expic9` varchar(50) default '', `expic9_tn` varchar(50) default '', `expic10` varchar(50) default '', `expic10_tn` varchar(50) default '', `expic11` varchar(50) default '', `expic11_tn` varchar(50) default '', `expic12` varchar(50) default '', `expic12_tn` varchar(50) default '', `expic13` varchar(50) default '', `expic13_tn` varchar(50) default '', `expic14` varchar(50) default '', `expic14_tn` varchar(50) default '', `expic15` varchar(50) default '', `expic15_tn` varchar(50) default '', `gps` BOOL NOT NULL DEFAULT '0', `ext1` BOOL NOT NULL DEFAULT '0', `ext2` BOOL NOT NULL DEFAULT '0', `ext3` BOOL NOT NULL DEFAULT '0', `ext4` tinyint(1) NOT NULL default '0', `ext5` tinyint(1) NOT NULL default '0', `ext6` tinyint(1) NOT NULL default'0', `ext7` tinyint(1) NOT NULL default '0', `ext8` tinyint(1) NOT NULL default '0', `ext9` tinyint(1) NOT NULL default '0', `hot` tinyint(1) NOT NULL default '0', `sold` tinyint(1) NOT NULL default '0', `airbag` BOOL NOT NULL DEFAULT '0', `abs` BOOL NOT NULL DEFAULT '0', `model` VARCHAR( 50 ) default '', `engine` VARCHAR( 10 ) default '', `km` VARCHAR( 10 ) default '', `power` VARCHAR( 10 ) default '', `year` VARCHAR( 10 ) default '', `color` VARCHAR( 10 ) default '', `seats` VARCHAR( 10 ) default '', `field1` VARCHAR( 12 ) default '', `field2` VARCHAR( 12 ) default '', `field3` VARCHAR( 12 ) default '', `field4` VARCHAR( 12 ) default '', `field5` VARCHAR( 12 ) default '', `field6` VARCHAR( 12 ) default '', PRIMARY KEY (`id`) ) TYPE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
SQL =
CREATE TABLE IF NOT EXISTS `jos_autostand` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`imgtitle` text NOT NULL,
`imgauthor` varchar(50) default NULL,
`vin` varchar(50) default NULL,
`imgtext` text NOT NULL,
`imgdate` varchar(20) default NULL,
`imgcounter` int(11) NOT NULL default '0',
`imgvotes` int(11) NOT NULL default '0',
`imgvotesum` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`imgfilename` varchar(50) default '',
`imgthumbname` varchar(50) default '',
`checked_out` int(11) NOT NULL default '0',
`price` varchar(20) default NULL,
`make` varchar(50) default NULL,
`doors` varchar(20) default NULL,
`fuel` varchar(20) default NULL,
`gearbox` varchar(20) default NULL,
`notes` text,
`expic1` varchar(50) default '',
`expic1_tn` varchar(50) default '',
`expic2` varchar(50) default '',
`expic2_tn` varchar(50) default '',
`expic3` varchar(50) default '',
`expic3_tn` varchar(50) default '',
`expic4` varchar(50) default '',
`expic4_tn` varchar(50) default '',
`expic5` varchar(50) default '',
`expic5_tn` varchar(50) default '',
`expic6` varchar(50) default '',
`expic6_tn` varchar(50) default '',
`expic7` varchar(50) default '',
`expic7_tn` varchar(50) default '',
`expic8` varchar(50) default '',
`expic8_tn` varchar(50) default '',
`expic9` varchar(50) default '',
`expic9_tn` varchar(50) default '',
`expic10` varchar(50) default '',
`expic10_tn` varchar(50) default '',
`expic11` varchar(50) default '',
`expic11_tn` varchar(50) default '',
`expic12` varchar(50) default '',
`expic12_tn` varchar(50) default '',
`expic13` varchar(50) default '',
`expic13_tn` varchar(50) default '',
`expic14` varchar(50) default '',
`expic14_tn` varchar(50) default '',
`expic15` varchar(50) default '',
`expic15_tn` varchar(50) default '',

`gps` BOOL NOT NULL DEFAULT '0',
`ext1` BOOL NOT NULL DEFAULT '0',
`ext2` BOOL NOT NULL DEFAULT '0',
`ext3` BOOL NOT NULL DEFAULT '0',
`ext4` tinyint(1) NOT NULL default '0',
`ext5` tinyint(1) NOT NULL default '0',
`ext6` tinyint(1) NOT NULL default'0',
`ext7` tinyint(1) NOT NULL default '0',
`ext8` tinyint(1) NOT NULL default '0',
`ext9` tinyint(1) NOT NULL default '0',
`hot` tinyint(1) NOT NULL default '0',
`sold` tinyint(1) NOT NULL default '0',
`airbag` BOOL NOT NULL DEFAULT '0',
`abs` BOOL NOT NULL DEFAULT '0',
`model` VARCHAR( 50 ) default '',
`engine` VARCHAR( 10 ) default '',
`km` VARCHAR( 10 ) default '',
`power` VARCHAR( 10 ) default '',
`year` VARCHAR( 10 ) default '',
`color` VARCHAR( 10 ) default '',
`seats` VARCHAR( 10 ) default '',
`field1` VARCHAR( 12 ) default '',
`field2` VARCHAR( 12 ) default '',
`field3` VARCHAR( 12 ) default '',
`field4` VARCHAR( 12 ) default '',
`field5` VARCHAR( 12 ) default '',
`field6` VARCHAR( 12 ) default '',

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 82 SQL=CREATE TABLE IF NOT EXISTS `jos_autostand` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `imgtitle` text NOT NULL, `imgauthor` varchar(50) default NULL, `vin` varchar(50) default NULL, `imgtext` text NOT NULL, `imgdate` varchar(20) default NULL, `imgcounter` int(11) NOT NULL default '0', `imgvotes` int(11) NOT NULL default '0', `imgvotesum` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `imgfilename` varchar(50) default '', `imgthumbname` varchar(50) default '', `checked_out` int(11) NOT NULL default '0', `price` varchar(20) default NULL, `make` varchar(50) default NULL, `doors` varchar(20) default NULL, `fuel` varchar(20) default NULL, `gearbox` varchar(20) default NULL, `notes` text, `expic1` varchar(50) default '', `expic1_tn` varchar(50) default '', `expic2` varchar(50) default '', `expic2_tn` varchar(50) default '', `expic3` varchar(50) default '', `expic3_tn` varchar(50) default '', `expic4` varchar(50) default '', `expic4_tn` varchar(50) default '', `expic5` varchar(50) default '', `expic5_tn` varchar(50) default '', `expic6` varchar(50) default '', `expic6_tn` varchar(50) default '', `expic7` varchar(50) default '', `expic7_tn` varchar(50) default '', `expic8` varchar(50) default '', `expic8_tn` varchar(50) default '', `expic9` varchar(50) default '', `expic9_tn` varchar(50) default '', `expic10` varchar(50) default '', `expic10_tn` varchar(50) default '', `expic11` varchar(50) default '', `expic11_tn` varchar(50) default '', `expic12` varchar(50) default '', `expic12_tn` varchar(50) default '', `expic13` varchar(50) default '', `expic13_tn` varchar(50) default '', `expic14` varchar(50) default '', `expic14_tn` varchar(50) default '', `expic15` varchar(50) default '', `expic15_tn` varchar(50) default '', `gps` BOOL NOT NULL DEFAULT '0', `ext1` BOOL NOT NULL DEFAULT '0', `ext2` BOOL NOT NULL DEFAULT '0', `ext3` BOOL NOT NULL DEFAULT '0', `ext4` tinyint(1) NOT NULL default '0', `ext5` tinyint(1) NOT NULL default '0', `ext6` tinyint(1) NOT NULL default'0', `ext7` tinyint(1) NOT NULL default '0', `ext8` tinyint(1) NOT NULL default '0', `ext9` tinyint(1) NOT NULL default '0', `hot` tinyint(1) NOT NULL default '0', `sold` tinyint(1) NOT NULL default '0', `airbag` BOOL NOT NULL DEFAULT '0', `abs` BOOL NOT NULL DEFAULT '0', `model` VARCHAR( 50 ) default '', `engine` VARCHAR( 10 ) default '', `km` VARCHAR( 10 ) default '', `power` VARCHAR( 10 ) default '', `year` VARCHAR( 10 ) default '', `color` VARCHAR( 10 ) default '', `seats` VARCHAR( 10 ) default '', `field1` VARCHAR( 12 ) default '', `field2` VARCHAR( 12 ) default '', `field3` VARCHAR( 12 ) default '', `field4` VARCHAR( 12 ) default '', `field5` VARCHAR( 12 ) default '', `field6` VARCHAR( 12 ) default '', PRIMARY KEY (`id`) ) TYPE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
SQL =
CREATE TABLE IF NOT EXISTS `jos_autostand` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`imgtitle` text NOT NULL,
`imgauthor` varchar(50) default NULL,
`vin` varchar(50) default NULL,
`imgtext` text NOT NULL,
`imgdate` varchar(20) default NULL,
`imgcounter` int(11) NOT NULL default '0',
`imgvotes` int(11) NOT NULL default '0',
`imgvotesum` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`imgfilename` varchar(50) default '',
`imgthumbname` varchar(50) default '',
`checked_out` int(11) NOT NULL default '0',
`price` varchar(20) default NULL,
`make` varchar(50) default NULL,
`doors` varchar(20) default NULL,
`fuel` varchar(20) default NULL,
`gearbox` varchar(20) default NULL,
`notes` text,
`expic1` varchar(50) default '',
`expic1_tn` varchar(50) default '',
`expic2` varchar(50) default '',
`expic2_tn` varchar(50) default '',
`expic3` varchar(50) default '',
`expic3_tn` varchar(50) default '',
`expic4` varchar(50) default '',
`expic4_tn` varchar(50) default '',
`expic5` varchar(50) default '',
`expic5_tn` varchar(50) default '',
`expic6` varchar(50) default '',
`expic6_tn` varchar(50) default '',
`expic7` varchar(50) default '',
`expic7_tn` varchar(50) default '',
`expic8` varchar(50) default '',
`expic8_tn` varchar(50) default '',
`expic9` varchar(50) default '',
`expic9_tn` varchar(50) default '',
`expic10` varchar(50) default '',
`expic10_tn` varchar(50) default '',
`expic11` varchar(50) default '',
`expic11_tn` varchar(50) default '',
`expic12` varchar(50) default '',
`expic12_tn` varchar(50) default '',
`expic13` varchar(50) default '',
`expic13_tn` varchar(50) default '',
`expic14` varchar(50) default '',
`expic14_tn` varchar(50) default '',
`expic15` varchar(50) default '',
`expic15_tn` varchar(50) default '',

`gps` BOOL NOT NULL DEFAULT '0',
`ext1` BOOL NOT NULL DEFAULT '0',
`ext2` BOOL NOT NULL DEFAULT '0',
`ext3` BOOL NOT NULL DEFAULT '0',
`ext4` tinyint(1) NOT NULL default '0',
`ext5` tinyint(1) NOT NULL default '0',
`ext6` tinyint(1) NOT NULL default'0',
`ext7` tinyint(1) NOT NULL default '0',
`ext8` tinyint(1) NOT NULL default '0',
`ext9` tinyint(1) NOT NULL default '0',
`hot` tinyint(1) NOT NULL default '0',
`sold` tinyint(1) NOT NULL default '0',
`airbag` BOOL NOT NULL DEFAULT '0',
`abs` BOOL NOT NULL DEFAULT '0',
`model` VARCHAR( 50 ) default '',
`engine` VARCHAR( 10 ) default '',
`km` VARCHAR( 10 ) default '',
`power` VARCHAR( 10 ) default '',
`year` VARCHAR( 10 ) default '',
`color` VARCHAR( 10 ) default '',
`seats` VARCHAR( 10 ) default '',
`field1` VARCHAR( 12 ) default '',
`field2` VARCHAR( 12 ) default '',
`field3` VARCHAR( 12 ) default '',
`field4` VARCHAR( 12 ) default '',
`field5` VARCHAR( 12 ) default '',
`field6` VARCHAR( 12 ) default '',

PRIMARY KEY (`id`)
) TYPE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

Please Entrar ou Registrar to join the conversation.

Início
Ant
1
Próximo
Fim

Joomla Templates Best Joomla Templates Premium Joomla Templates Free Joomla Templates