Instalação uddeIM 1.9 - ERRO!

Mais
13 anos 6 meses atrás #68478 por JUNIORBA1980
JUNIORBA1980 replied the topic: Re: Instalação uddeIM 1.9 - ERRO!
Boa noite alguem pode me ajudar estou tentando instalar o uddeIM 1.9 no JOOMLA 1.5 mais fica dando esse erro não sei mais o que fazer .<!-- l --><a class="postlink-local" href=" www.joomlaclube.com.br/site/forum/viewto...php?f=11&t=3577# " onclick="window.open(this.href);return false;]viewtopic.php?f=11&t=3577#[/url]<!-- l -->

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' at line 32 SQL=CREATE TABLE IF NOT EXISTS `jos_uddeim` ( `id` int(10) unsigned NOT NULL auto_increment, `replyid` int(11) NOT NULL default '0', `fromid` int(11) NOT NULL default '0', `toid` int(11) NOT NULL default '0', `message` text NOT NULL, `datum` int(11) default NULL, `toread` int(1) NOT NULL default '0', `totrash` int(1) NOT NULL default '0', `totrashdate` int(11) default NULL, `totrashoutbox` int(1) NOT NULL default '0', `totrashdateoutbox` int(11) default NULL, `expires` int(11) NOT NULL default '0', `disablereply` int(1) NOT NULL default '0', `systemmessage` varchar(60) default NULL, `archived` int(1) NOT NULL default '0', `cryptmode` int(1) NOT NULL default '0', `flagged` int(1) NOT NULL default '0', `crypthash` varchar(32) default NULL, `publicname` text default NULL, `publicemail` text default NULL, PRIMARY KEY (`id`), KEY `toid_toread` (`toid`,`toread`), KEY `fromid` (`fromid`), KEY `replyid` (`replyid`), KEY `datum` (`datum`), KEY `totrashdate` (`totrashdate`), KEY `totrashdateoutbox_datum` ( `totrashdateoutbox` , `datum` ), KEY `toread_totrash_datum` (`toread`,`totrash`,`datum`), KEY `totrash_totrashdate` (`totrash`,`totrashdate`), KEY `archived_totrash_toid_datum` (`archived`,`totrash`,`toid`,`datum`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_uddeim` (
`id` int(10) unsigned NOT NULL auto_increment,
`replyid` int(11) NOT NULL default '0',
`fromid` int(11) NOT NULL default '0',
`toid` int(11) NOT NULL default '0',
`message` text NOT NULL,
`datum` int(11) default NULL,
`toread` int(1) NOT NULL default '0',
`totrash` int(1) NOT NULL default '0',
`totrashdate` int(11) default NULL,
`totrashoutbox` int(1) NOT NULL default '0',
`totrashdateoutbox` int(11) default NULL,
`expires` int(11) NOT NULL default '0',
`disablereply` int(1) NOT NULL default '0',
`systemmessage` varchar(60) default NULL,
`archived` int(1) NOT NULL default '0',
`cryptmode` int(1) NOT NULL default '0',
`flagged` int(1) NOT NULL default '0',
`crypthash` varchar(32) default NULL,
`publicname` text default NULL,
`publicemail` text default NULL,
PRIMARY KEY (`id`),
KEY `toid_toread` (`toid`,`toread`),
KEY `fromid` (`fromid`),
KEY `replyid` (`replyid`),
KEY `datum` (`datum`),
KEY `totrashdate` (`totrashdate`),
KEY `totrashdateoutbox_datum` ( `totrashdateoutbox` , `datum` ),
KEY `toread_totrash_datum` (`toread`,`totrash`,`datum`),
KEY `totrash_totrashdate` (`totrash`,`totrashdate`),
KEY `archived_totrash_toid_datum` (`archived`,`totrash`,`toid`,`datum`)
) TYPE=MyISAM;

Componente Instalar: 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' at line 32 SQL=CREATE TABLE IF NOT EXISTS `jos_uddeim` ( `id` int(10) unsigned NOT NULL auto_increment, `replyid` int(11) NOT NULL default '0', `fromid` int(11) NOT NULL default '0', `toid` int(11) NOT NULL default '0', `message` text NOT NULL, `datum` int(11) default NULL, `toread` int(1) NOT NULL default '0', `totrash` int(1) NOT NULL default '0', `totrashdate` int(11) default NULL, `totrashoutbox` int(1) NOT NULL default '0', `totrashdateoutbox` int(11) default NULL, `expires` int(11) NOT NULL default '0', `disablereply` int(1) NOT NULL default '0', `systemmessage` varchar(60) default NULL, `archived` int(1) NOT NULL default '0', `cryptmode` int(1) NOT NULL default '0', `flagged` int(1) NOT NULL default '0', `crypthash` varchar(32) default NULL, `publicname` text default NULL, `publicemail` text default NULL, PRIMARY KEY (`id`), KEY `toid_toread` (`toid`,`toread`), KEY `fromid` (`fromid`), KEY `replyid` (`replyid`), KEY `datum` (`datum`), KEY `totrashdate` (`totrashdate`), KEY `totrashdateoutbox_datum` ( `totrashdateoutbox` , `datum` ), KEY `toread_totrash_datum` (`toread`,`totrash`,`datum`), KEY `totrash_totrashdate` (`totrash`,`totrashdate`), KEY `archived_totrash_toid_datum` (`archived`,`totrash`,`toid`,`datum`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_uddeim` (
`id` int(10) unsigned NOT NULL auto_increment,
`replyid` int(11) NOT NULL default '0',
`fromid` int(11) NOT NULL default '0',
`toid` int(11) NOT NULL default '0',
`message` text NOT NULL,
`datum` int(11) default NULL,
`toread` int(1) NOT NULL default '0',
`totrash` int(1) NOT NULL default '0',
`totrashdate` int(11) default NULL,
`totrashoutbox` int(1) NOT NULL default '0',
`totrashdateoutbox` int(11) default NULL,
`expires` int(11) NOT NULL default '0',
`disablereply` int(1) NOT NULL default '0',
`systemmessage` varchar(60) default NULL,
`archived` int(1) NOT NULL default '0',
`cryptmode` int(1) NOT NULL default '0',
`flagged` int(1) NOT NULL default '0',
`crypthash` varchar(32) default NULL,
`publicname` text default NULL,
`publicemail` text default NULL,
PRIMARY KEY (`id`),
KEY `toid_toread` (`toid`,`toread`),
KEY `fromid` (`fromid`),
KEY `replyid` (`replyid`),
KEY `datum` (`datum`),
KEY `totrashdate` (`totrashdate`),
KEY `totrashdateoutbox_datum` ( `totrashdateoutbox` , `datum` ),
KEY `toread_totrash_datum` (`toread`,`totrash`,`datum`),
KEY `totrash_totrashdate` (`totrash`,`totrashdate`),
KEY `archived_totrash_toid_datum` (`archived`,`totrash`,`toid`,`datum`)
) TYPE=MyISAM;

Please Entrar ou Registrar to join the conversation.

Mais
13 anos 1 mês atrás #80190 por albertojunior
albertojunior replied the topic: Re: Instalação uddeIM 1.9 - ERRO!
Saudações amigos.
Estou com o mesmo erro na instação do componente, os plugns instalaram perfeitamente.
Alguem poderia postar uma solução por favor....

Joomla Versão 1.5.26

Sei que tenho que criar a tabela no DB, mas não entendo direito de tabela de DB, algum script ou mesmo a estrutura do DB do Uddeim 1.9. Ou outra solução.

Agradeço desde ja.

Alberto
Erro:


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' at line 32 SQL=CREATE TABLE IF NOT EXISTS `jos_uddeim` ( `id` int(10) unsigned NOT NULL auto_increment, `replyid` int(11) NOT NULL default '0', `fromid` int(11) NOT NULL default '0', `toid` int(11) NOT NULL default '0', `message` text NOT NULL, `datum` int(11) default NULL, `toread` int(1) NOT NULL default '0', `totrash` int(1) NOT NULL default '0', `totrashdate` int(11) default NULL, `totrashoutbox` int(1) NOT NULL default '0', `totrashdateoutbox` int(11) default NULL, `expires` int(11) NOT NULL default '0', `disablereply` int(1) NOT NULL default '0', `systemmessage` varchar(60) default NULL, `archived` int(1) NOT NULL default '0', `cryptmode` int(1) NOT NULL default '0', `flagged` int(1) NOT NULL default '0', `crypthash` varchar(32) default NULL, `publicname` text default NULL, `publicemail` text default NULL, PRIMARY KEY (`id`), KEY `toid_toread` (`toid`,`toread`), KEY `fromid` (`fromid`), KEY `replyid` (`replyid`), KEY `datum` (`datum`), KEY `totrashdate` (`totrashdate`), KEY `totrashdateoutbox_datum` ( `totrashdateoutbox` , `datum` ), KEY `toread_totrash_datum` (`toread`,`totrash`,`datum`), KEY `totrash_totrashdate` (`totrash`,`totrashdate`), KEY `archived_totrash_toid_datum` (`archived`,`totrash`,`toid`,`datum`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_uddeim` (
`id` int(10) unsigned NOT NULL auto_increment,
`replyid` int(11) NOT NULL default '0',
`fromid` int(11) NOT NULL default '0',
`toid` int(11) NOT NULL default '0',
`message` text NOT NULL,
`datum` int(11) default NULL,
`toread` int(1) NOT NULL default '0',
`totrash` int(1) NOT NULL default '0',
`totrashdate` int(11) default NULL,
`totrashoutbox` int(1) NOT NULL default '0',
`totrashdateoutbox` int(11) default NULL,
`expires` int(11) NOT NULL default '0',
`disablereply` int(1) NOT NULL default '0',
`systemmessage` varchar(60) default NULL,
`archived` int(1) NOT NULL default '0',
`cryptmode` int(1) NOT NULL default '0',
`flagged` int(1) NOT NULL default '0',
`crypthash` varchar(32) default NULL,
`publicname` text default NULL,
`publicemail` text default NULL,
PRIMARY KEY (`id`),
KEY `toid_toread` (`toid`,`toread`),
KEY `fromid` (`fromid`),
KEY `replyid` (`replyid`),
KEY `datum` (`datum`),
KEY `totrashdate` (`totrashdate`),
KEY `totrashdateoutbox_datum` ( `totrashdateoutbox` , `datum` ),
KEY `toread_totrash_datum` (`toread`,`totrash`,`datum`),
KEY `totrash_totrashdate` (`totrash`,`totrashdate`),
KEY `archived_totrash_toid_datum` (`archived`,`totrash`,`toid`,`datum`)
) TYPE=MyISAM;

Componente Instalar: 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' at line 32 SQL=CREATE TABLE IF NOT EXISTS `jos_uddeim` ( `id` int(10) unsigned NOT NULL auto_increment, `replyid` int(11) NOT NULL default '0', `fromid` int(11) NOT NULL default '0', `toid` int(11) NOT NULL default '0', `message` text NOT NULL, `datum` int(11) default NULL, `toread` int(1) NOT NULL default '0', `totrash` int(1) NOT NULL default '0', `totrashdate` int(11) default NULL, `totrashoutbox` int(1) NOT NULL default '0', `totrashdateoutbox` int(11) default NULL, `expires` int(11) NOT NULL default '0', `disablereply` int(1) NOT NULL default '0', `systemmessage` varchar(60) default NULL, `archived` int(1) NOT NULL default '0', `cryptmode` int(1) NOT NULL default '0', `flagged` int(1) NOT NULL default '0', `crypthash` varchar(32) default NULL, `publicname` text default NULL, `publicemail` text default NULL, PRIMARY KEY (`id`), KEY `toid_toread` (`toid`,`toread`), KEY `fromid` (`fromid`), KEY `replyid` (`replyid`), KEY `datum` (`datum`), KEY `totrashdate` (`totrashdate`), KEY `totrashdateoutbox_datum` ( `totrashdateoutbox` , `datum` ), KEY `toread_totrash_datum` (`toread`,`totrash`,`datum`), KEY `totrash_totrashdate` (`totrash`,`totrashdate`), KEY `archived_totrash_toid_datum` (`archived`,`totrash`,`toid`,`datum`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_uddeim` (
`id` int(10) unsigned NOT NULL auto_increment,
`replyid` int(11) NOT NULL default '0',
`fromid` int(11) NOT NULL default '0',
`toid` int(11) NOT NULL default '0',
`message` text NOT NULL,
`datum` int(11) default NULL,
`toread` int(1) NOT NULL default '0',
`totrash` int(1) NOT NULL default '0',
`totrashdate` int(11) default NULL,
`totrashoutbox` int(1) NOT NULL default '0',
`totrashdateoutbox` int(11) default NULL,
`expires` int(11) NOT NULL default '0',
`disablereply` int(1) NOT NULL default '0',
`systemmessage` varchar(60) default NULL,
`archived` int(1) NOT NULL default '0',
`cryptmode` int(1) NOT NULL default '0',
`flagged` int(1) NOT NULL default '0',
`crypthash` varchar(32) default NULL,
`publicname` text default NULL,
`publicemail` text default NULL,
PRIMARY KEY (`id`),
KEY `toid_toread` (`toid`,`toread`),
KEY `fromid` (`fromid`),
KEY `replyid` (`replyid`),
KEY `datum` (`datum`),
KEY `totrashdate` (`totrashdate`),
KEY `totrashdateoutbox_datum` ( `totrashdateoutbox` , `datum` ),
KEY `toread_totrash_datum` (`toread`,`totrash`,`datum`),
KEY `totrash_totrashdate` (`totrash`,`totrashdate`),
KEY `archived_totrash_toid_datum` (`archived`,`totrash`,`toid`,`datum`)
) TYPE=MyISAM;

Please Entrar ou Registrar to join the conversation.

Mais
12 anos 6 meses atrás #88091 por albertojunior
albertojunior replied the topic: Re: Instalação uddeIM 1.9 - ERRO!
Saudações amigos, ninguem mesmo sabe como resolver isto....

Obrigado....

Boa sorte

Please Entrar ou Registrar to join the conversation.