@[Only registered and activated users can see links. Click Here To Register...]
Esse módulo extra de classes, tem um tutorial para adicionar ?
Att
Printable View
@[Only registered and activated users can see links. Click Here To Register...]
Esse módulo extra de classes, tem um tutorial para adicionar ?
Att
Bom, pode ser que eu tenha feitoalgo errado mas, ao executar:Citação:
Originally Posted by louis [Only registered and activated users can see links. Click Here To Register...]
Me retorna:Citação:
CREATE TABLE IF NOT EXISTS `fotos` (
`id` int(11) NOT NULL,
`foto` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`comentario` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ALTER TABLE `fotos`
ADD PRIMARY KEY (`id`);
ALTER TABLE `fotos`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=25;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
CREATE TABLE IF NOT EXISTS `noticias` (
`Id` int(6) unsigned NOT NULL,
`data` date DEFAULT NULL,
`titulo` text,
`noticia` text NOT NULL,
`user` varchar(20) NOT NULL,
`server` int(11) NOT NULL DEFAULT '1',
`tipo` tinyint(4) NOT NULL DEFAULT '1',
`dias_promo` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=1081 DEFAULT CHARSET=latin1;
ALTER TABLE `noticias`
ADD PRIMARY KEY (`Id`);
ALTER TABLE `noticias`
MODIFY `Id` int(6) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1081;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Erro
Comando SQL:
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */
Mensagens do MySQL : [Only registered and activated users can see links. Click Here To Register...]
#1231 - Variável 'character_set_client' não pode ser configurada para o valor de 'NULL'
alguma ideia?
Att:
Só só colocar o link no menu ^^Citação:
Originally Posted by kaoshi [Only registered and activated users can see links. Click Here To Register...]
pode excluir essas linhas:Citação:
Originally Posted by sula10 [Only registered and activated users can see links. Click Here To Register...]
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Linhas excluidas, script rodado e outro erro:Citação:
Originally Posted by louis [Only registered and activated users can see links. Click Here To Register...]
Citação:
Erro
Comando SQL:
ALTER TABLE `fotos`
ADD PRIMARY KEY (`id`)
Mensagens do MySQL : [Only registered and activated users can see links. Click Here To Register...]
#1068 - Definida mais de uma chave primária
Obs: a query é aquela q acompanha o site mesmo? ou tem uma outra modificada?
Att:
Eu acho que já criou a tabela por isso está dando esse erroCitação:
Originally Posted by sula10 [Only registered and activated users can see links. Click Here To Register...]
louis lane,Citação:
Originally Posted by louis [Only registered and activated users can see links. Click Here To Register...]
agora com calma eu fui verificar e estava assim:
[Only registered and activated users can see links. Click Here To Register...]
aew eu rodei apenas ssa parte:
e bingooo.Citação:
CREATE TABLE IF NOT EXISTS `noticias` (`Id` int(6) unsigned NOT NULL,
`data` date DEFAULT NULL,
`titulo` text,
`noticia` text NOT NULL,
`user` varchar(20) NOT NULL,
`server` int(11) NOT NULL DEFAULT '1',
`tipo` tinyint(4) NOT NULL DEFAULT '1',
`dias_promo` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=1081 DEFAULT CHARSET=latin1;
ALTER TABLE `noticias`
ADD PRIMARY KEY (`Id`);
ALTER TABLE `noticias`
MODIFY `Id` int(6) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1081;
[Only registered and activated users can see links. Click Here To Register...]
teste a noticia e foi de boa, ñ tenho certeza mas acho q caracteres especiais no testo da algum "`erro`".
Att:
Se aparceu ali já instalou a tabela.Citação:
Originally Posted by sula10 [Only registered and activated users can see links. Click Here To Register...]
agora é só configurar no config.php e enviar uma noticia para testar ^^
Eu tenho esse erro no meu painel web
[Only registered and activated users can see links. Click Here To Register...]
Basta adicionar essa linha no config.php:Citação:
Originally Posted by Azzlaer [Only registered and activated users can see links. Click Here To Register...]
*Pessoal antes de perguntar tente ler todos os tópicos, pois a maioria dos erros comuns eu já coloquei a resposta aqui, não que eu não vá responder mas isso agiliza para vocês e vocês poderão encontrar outras correções.Citação:
error_reporting(E_ERROR | E_WARNING | E_PARSE);
abraço
Como arumo o MR para tirar 300 resets por MR e ter que ta 64900 status
minhas conf estao assim
;================================================= =
; Master Reset Command Settings
;================================================= =
CommandMasterResetSwitch = 1
CommandMasterResetType = 1
CommandMasterResetEnable_AL0 = 1
CommandMasterResetEnable_AL1 = 1
CommandMasterResetEnable_AL2 = 1
CommandMasterResetEnable_AL3 = 1
CommandMasterResetCheckItem_AL0 = 0
CommandMasterResetCheckItem_AL1 = 0
CommandMasterResetCheckItem_AL2 = 0
CommandMasterResetCheckItem_AL3 = 0
CommandMasterResetMove_AL0 = 1
CommandMasterResetMove_AL1 = 1
CommandMasterResetMove_AL2 = 1
CommandMasterResetMove_AL3 = 1
CommandMasterResetQuest_AL0 = 0
CommandMasterResetQuest_AL1 = 0
CommandMasterResetQuest_AL2 = 0
CommandMasterResetQuest_AL3 = 0
CommandMasterResetSkill_AL0 = 0
CommandMasterResetSkill_AL1 = 0
CommandMasterResetSkill_AL2 = 0
CommandMasterResetSkill_AL3 = 0
CommandMasterResetLevel_AL0 = 400
CommandMasterResetLevel_AL1 = 400
CommandMasterResetLevel_AL2 = 400
CommandMasterResetLevel_AL3 = 400
CommandMasterResetReset_AL0 = 300
CommandMasterResetReset_AL1 = 300
CommandMasterResetReset_AL2 = 300
CommandMasterResetReset_AL3 = 300
CommandMasterResetMoney_AL0 = 0
CommandMasterResetMoney_AL1 = 0
CommandMasterResetMoney_AL2 = 0
CommandMasterResetMoney_AL3 = 0
CommandMasterResetCount_AL0 = 1
CommandMasterResetCount_AL1 = 1
CommandMasterResetCount_AL2 = 1
CommandMasterResetCount_AL3 = 1
CommandMasterResetLimit_AL0 = 10000
CommandMasterResetLimit_AL1 = 10000
CommandMasterResetLimit_AL2 = 10000
CommandMasterResetLimit_AL3 = 10000
CommandMasterResetLimitDay_AL0 = 10000
CommandMasterResetLimitDay_AL1 = 10000
CommandMasterResetLimitDay_AL2 = 10000
CommandMasterResetLimitDay_AL3 = 10000
CommandMasterResetLimitWek_AL0 = 10000
CommandMasterResetLimitWek_AL1 = 10000
CommandMasterResetLimitWek_AL2 = 10000
CommandMasterResetLimitWek_AL3 = 10000
CommandMasterResetLimitMon_AL0 = 10000
CommandMasterResetLimitMon_AL1 = 10000
CommandMasterResetLimitMon_AL2 = 10000
CommandMasterResetLimitMon_AL3 = 10000
CommandMasterResetStartLevel_AL0 = 1
CommandMasterResetStartLevel_AL1 = 1
CommandMasterResetStartLevel_AL2 = 1
CommandMasterResetStartLevel_AL3 = 1
CommandMasterResetStartReset_AL0 = 0
CommandMasterResetStartReset_AL1 = 0
CommandMasterResetStartReset_AL2 = 0
CommandMasterResetStartReset_AL3 = 0
CommandMasterResetPoint_AL0 = 0
CommandMasterResetPoint_AL1 = 0
CommandMasterResetPoint_AL2 = 0
CommandMasterResetPoint_AL3 = 0
CommandMasterResetPointRateDW = 100
CommandMasterResetPointRateDK = 100
CommandMasterResetPointRateFE = 100
CommandMasterResetPointRateMG = 100
CommandMasterResetPointRateDL = 100
CommandMasterResetPointRateSU = 100
CommandMasterResetPointRateRF = 100