Instalação MorfeoShow

  • cicerobrasil
  • Avatar de cicerobrasil Autor do Tópico
  • Offline
  • JCB! Novato
  • JCB! Novato
Mais
14 anos 2 semanas atrás #56824 por cicerobrasil
cicerobrasil created the topic: Instalação MorfeoShow
Qdo tento instalar o morfeoshow, aparece esse erro, oq faço para resolvê-lo?

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`' at line 58 SQL=CREATE TABLE IF NOT EXISTS `jos_morfeoshow` ( `id` INT( 5 ) NOT NULL AUTO_INCREMENT , `name` varchar( 128 ) NOT NULL , `description` TEXT NOT NULL , `description1` TEXT NOT NULL , `folder` varchar( 32 ) NOT NULL , `shortcut_filename` varchar( 128 ) NOT NULL, `published` tinyint(1) NOT NULL default 0, `flashgallery` int(2) NOT NULL default 0, `height` int(4) NOT NULL, `width` int(4) NOT NULL, `heightsw` int(4) NOT NULL, `widthsw` int(4) NOT NULL, `heightpc` int(4) NOT NULL, `widthpc` int(4) NOT NULL, `heightpl` int(4) NOT NULL, `widthpl` int(4) NOT NULL, `trans` int(2) NOT NULL default 0, `movimento` tinyint(1) NOT NULL default 1, `navigation` tinyint(1) NOT NULL default 1, `tempo` int(4) NOT NULL, `bkgnd` varchar(12) NOT NULL , `bkgnd1` varchar(12) NOT NULL , `bkgnd2` varchar(12) NOT NULL , `bkgnd3` varchar(12) NOT NULL , `ordering` int(4) NOT NULL, `metakey` TEXT NOT NULL , `metadesc` TEXT NOT NULL , `metadata` TEXT NOT NULL , `glat` varchar( 20 ) NOT NULL, `glng` varchar( 20 ) NOT NULL, `gzoom` int(4) NOT NULL, `gmapkey` varchar( 100 ) NOT NULL, `luogo` varchar( 128 ) NOT NULL , `user_id` varchar(255) NOT NULL, `group_id` varchar(255) NOT NULL, `text` varchar(255) NOT NULL, `tags` varchar(255) NOT NULL, `set_id` varchar(255) NOT NULL, `sort` int(4) NOT NULL, `pusername` varchar(180) NOT NULL, `pphotosize` int(4) NOT NULL default '512', `pthumbsize` int(4) NOT NULL default '64', `palbumcols` int(4) NOT NULL default '3', `pcols` int(4) NOT NULL default '6', `pmaxresults` int(4) NOT NULL default '24', `pmaxalbums` int(4) NOT NULL default '4', `psingle` varchar(120) NOT NULL, `pback` varchar(10) NOT NULL , `paltezza` int(4) NOT NULL , `plarghezza` int(4) NOT NULL , `overstretch` tinyint(1) NOT NULL default 0, `shuffle` tinyint(1) NOT NULL default 0, `tclassic` int(4) NOT NULL , `tcol` int(4) NOT NULL , `orderfront` varchar( 30 ) NOT NULL , PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =

CREATE TABLE IF NOT EXISTS `jos_morfeoshow` (
`id` INT( 5 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 128 ) NOT NULL ,
`description` TEXT NOT NULL ,
`description1` TEXT NOT NULL ,
`folder` varchar( 32 ) NOT NULL ,
`shortcut_filename` varchar( 128 ) NOT NULL,
`published` tinyint(1) NOT NULL default 0,
`flashgallery` int(2) NOT NULL default 0,
`height` int(4) NOT NULL,
`width` int(4) NOT NULL,
`heightsw` int(4) NOT NULL,
`widthsw` int(4) NOT NULL,
`heightpc` int(4) NOT NULL,
`widthpc` int(4) NOT NULL,
`heightpl` int(4) NOT NULL,
`widthpl` int(4) NOT NULL,
`trans` int(2) NOT NULL default 0,
`movimento` tinyint(1) NOT NULL default 1,
`navigation` tinyint(1) NOT NULL default 1,
`tempo` int(4) NOT NULL,
`bkgnd` varchar(12) NOT NULL ,
`bkgnd1` varchar(12) NOT NULL ,
`bkgnd2` varchar(12) NOT NULL ,
`bkgnd3` varchar(12) NOT NULL ,
`ordering` int(4) NOT NULL,
`metakey` TEXT NOT NULL ,
`metadesc` TEXT NOT NULL ,
`metadata` TEXT NOT NULL ,
`glat` varchar( 20 ) NOT NULL,
`glng` varchar( 20 ) NOT NULL,
`gzoom` int(4) NOT NULL,
`gmapkey` varchar( 100 ) NOT NULL,
`luogo` varchar( 128 ) NOT NULL ,
`user_id` varchar(255) NOT NULL,
`group_id` varchar(255) NOT NULL,
`text` varchar(255) NOT NULL,
`tags` varchar(255) NOT NULL,
`set_id` varchar(255) NOT NULL,
`sort` int(4) NOT NULL,
`pusername` varchar(180) NOT NULL,
`pphotosize` int(4) NOT NULL default '512',
`pthumbsize` int(4) NOT NULL default '64',
`palbumcols` int(4) NOT NULL default '3',
`pcols` int(4) NOT NULL default '6',
`pmaxresults` int(4) NOT NULL default '24',
`pmaxalbums` int(4) NOT NULL default '4',
`psingle` varchar(120) NOT NULL,
`pback` varchar(10) NOT NULL ,
`paltezza` int(4) NOT NULL ,
`plarghezza` int(4) NOT NULL ,
`overstretch` tinyint(1) NOT NULL default 0,
`shuffle` tinyint(1) NOT NULL default 0,
`tclassic` int(4) NOT NULL ,
`tcol` int(4) NOT NULL ,
`orderfront` varchar( 30 ) NOT NULL ,
PRIMARY KEY (`id`)
) TYPE=MyISAM CHARACTER SET `utf8`;

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`' at line 58 SQL=CREATE TABLE IF NOT EXISTS `jos_morfeoshow` ( `id` INT( 5 ) NOT NULL AUTO_INCREMENT , `name` varchar( 128 ) NOT NULL , `description` TEXT NOT NULL , `description1` TEXT NOT NULL , `folder` varchar( 32 ) NOT NULL , `shortcut_filename` varchar( 128 ) NOT NULL, `published` tinyint(1) NOT NULL default 0, `flashgallery` int(2) NOT NULL default 0, `height` int(4) NOT NULL, `width` int(4) NOT NULL, `heightsw` int(4) NOT NULL, `widthsw` int(4) NOT NULL, `heightpc` int(4) NOT NULL, `widthpc` int(4) NOT NULL, `heightpl` int(4) NOT NULL, `widthpl` int(4) NOT NULL, `trans` int(2) NOT NULL default 0, `movimento` tinyint(1) NOT NULL default 1, `navigation` tinyint(1) NOT NULL default 1, `tempo` int(4) NOT NULL, `bkgnd` varchar(12) NOT NULL , `bkgnd1` varchar(12) NOT NULL , `bkgnd2` varchar(12) NOT NULL , `bkgnd3` varchar(12) NOT NULL , `ordering` int(4) NOT NULL, `metakey` TEXT NOT NULL , `metadesc` TEXT NOT NULL , `metadata` TEXT NOT NULL , `glat` varchar( 20 ) NOT NULL, `glng` varchar( 20 ) NOT NULL, `gzoom` int(4) NOT NULL, `gmapkey` varchar( 100 ) NOT NULL, `luogo` varchar( 128 ) NOT NULL , `user_id` varchar(255) NOT NULL, `group_id` varchar(255) NOT NULL, `text` varchar(255) NOT NULL, `tags` varchar(255) NOT NULL, `set_id` varchar(255) NOT NULL, `sort` int(4) NOT NULL, `pusername` varchar(180) NOT NULL, `pphotosize` int(4) NOT NULL default '512', `pthumbsize` int(4) NOT NULL default '64', `palbumcols` int(4) NOT NULL default '3', `pcols` int(4) NOT NULL default '6', `pmaxresults` int(4) NOT NULL default '24', `pmaxalbums` int(4) NOT NULL default '4', `psingle` varchar(120) NOT NULL, `pback` varchar(10) NOT NULL , `paltezza` int(4) NOT NULL , `plarghezza` int(4) NOT NULL , `overstretch` tinyint(1) NOT NULL default 0, `shuffle` tinyint(1) NOT NULL default 0, `tclassic` int(4) NOT NULL , `tcol` int(4) NOT NULL , `orderfront` varchar( 30 ) NOT NULL , PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8`;
SQL =

CREATE TABLE IF NOT EXISTS `jos_morfeoshow` (
`id` INT( 5 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 128 ) NOT NULL ,
`description` TEXT NOT NULL ,
`description1` TEXT NOT NULL ,
`folder` varchar( 32 ) NOT NULL ,
`shortcut_filename` varchar( 128 ) NOT NULL,
`published` tinyint(1) NOT NULL default 0,
`flashgallery` int(2) NOT NULL default 0,
`height` int(4) NOT NULL,
`width` int(4) NOT NULL,
`heightsw` int(4) NOT NULL,
`widthsw` int(4) NOT NULL,
`heightpc` int(4) NOT NULL,
`widthpc` int(4) NOT NULL,
`heightpl` int(4) NOT NULL,
`widthpl` int(4) NOT NULL,
`trans` int(2) NOT NULL default 0,
`movimento` tinyint(1) NOT NULL default 1,
`navigation` tinyint(1) NOT NULL default 1,
`tempo` int(4) NOT NULL,
`bkgnd` varchar(12) NOT NULL ,
`bkgnd1` varchar(12) NOT NULL ,
`bkgnd2` varchar(12) NOT NULL ,
`bkgnd3` varchar(12) NOT NULL ,
`ordering` int(4) NOT NULL,
`metakey` TEXT NOT NULL ,
`metadesc` TEXT NOT NULL ,
`metadata` TEXT NOT NULL ,
`glat` varchar( 20 ) NOT NULL,
`glng` varchar( 20 ) NOT NULL,
`gzoom` int(4) NOT NULL,
`gmapkey` varchar( 100 ) NOT NULL,
`luogo` varchar( 128 ) NOT NULL ,
`user_id` varchar(255) NOT NULL,
`group_id` varchar(255) NOT NULL,
`text` varchar(255) NOT NULL,
`tags` varchar(255) NOT NULL,
`set_id` varchar(255) NOT NULL,
`sort` int(4) NOT NULL,
`pusername` varchar(180) NOT NULL,
`pphotosize` int(4) NOT NULL default '512',
`pthumbsize` int(4) NOT NULL default '64',
`palbumcols` int(4) NOT NULL default '3',
`pcols` int(4) NOT NULL default '6',
`pmaxresults` int(4) NOT NULL default '24',
`pmaxalbums` int(4) NOT NULL default '4',
`psingle` varchar(120) NOT NULL,
`pback` varchar(10) NOT NULL ,
`paltezza` int(4) NOT NULL ,
`plarghezza` int(4) NOT NULL ,
`overstretch` tinyint(1) NOT NULL default 0,
`shuffle` tinyint(1) NOT NULL default 0,
`tclassic` int(4) NOT NULL ,
`tcol` int(4) NOT NULL ,
`orderfront` varchar( 30 ) NOT NULL ,
PRIMARY KEY (`id`)
) TYPE=MyISAM CHARACTER SET `utf8`;

Please Entrar ou Registrar to join the conversation.


Mais
13 anos 11 meses atrás #58964 por Vip Art
Vip Art replied the topic: Re: Instalação MorfeoShow
Boa tarde, também estou com o mesmo problema, se alguem souber nos ajudar. agradeço.

Please Entrar ou Registrar to join the conversation.

Mais
13 anos 10 meses atrás #60017 por Naniko
Naniko replied the topic: Re: Instalação MorfeoShow
Aqui também estou com esse problema, será que ficou incompativel com alguma atualização do mysql?

Please Entrar ou Registrar to join the conversation.

Mais
13 anos 10 meses atrás #60021 por mps
mps replied the topic: Re: Instalação MorfeoShow
Aee galera, tentem mudar no .sql de "TYPE=MyISAM", para "ENGINE=MyISAM", talvez resolva

Please Entrar ou Registrar to join the conversation.

Mais
13 anos 5 meses atrás #71276 por moumesquita
moumesquita replied the topic: Re: Instalação MorfeoShow

mps escreveu: Aee galera, tentem mudar no .sql de "TYPE=MyISAM", para "ENGINE=MyISAM", talvez resolva

Estou com o mesmo problema e nao adiantou a dica do amigo MPS... se alguém souber o que está acontecendo... eu baixei o joomla e o morpheo aqui do JoomlaClub... obrigado. <!-- s:x --><img src="{SMILIES_PATH}/icon_mad.gif" alt=":x" title="Furioso" /><!-- s:x -->

Please Entrar ou Registrar to join the conversation.