Ir para conteúdo
TK News
  • Cadastre-se

Erros no Distro

PsyMcKenzie
 Share Seguidores 0

Posts Recomendados

PsyMcKenzie

PsyMcKenzie 46

Postado
Postado

Bom galera, baixei um servidor e quando fui abrir, me deparei com isso:
 

1º:
 

[02/07/2014 20:08:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetime6 (UPDATE "players" SET "onlinetime7"=players.onlinetime6, "onlinetime6"=players.onlinetime5, "onlinetime5"=players.onlinetime4, "onlinetime4"=players.onlinetime3, "onlinetime3"=players.onlinetime2, "onlinetime2"=players.onlinetime1, "onlinetime1"=players.onlinetimetoday, "onlinetimetoday"=0;)
[02/07/2014 20:08:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist6 (UPDATE "players" SET "exphist7"=players.exphist6, "exphist6"=players.exphist5, "exphist5"=players.exphist4, "exphist4"=players.exphist3, "exphist3"=players.exphist2, "exphist2"=players.exphist1, "exphist1"=players.experience-players.exphist_lastexp, "exphist_lastexp"=players.experience;)
[02/07/2014 20:08:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:08:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:08:51] sqlite3_step(): SQLITE ERROR: columns id, world_id are not unique

2º

[02/07/2014 20:09:25] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:09:26] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:09:57] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:10:26] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:10:28] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:10:59] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:11:27] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:11:30] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:12:01] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:12:28] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:12:32] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:13:03] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:13:29] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:13:34] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:14:05] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:14:30] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:14:36] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:15:07] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:15:31] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:15:38] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:16:09] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:16:32] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:16:40] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)

Alguém tem ideia de como faço para arrumar?

Link para o post
Compartilhar em outros sites
Rusherzin

Rusherzin 527

Postado
Postado (editado) 
CREATE TABLE "z_ots_comunication" (
"id" INTEGER NOT NULL auto_increment,
"name" varchar(255) NOT NULL,
"type" varchar(255) NOT NULL,
"action" varchar(255) NOT NULL,
"param1" varchar(255) NOT NULL,
"param2" varchar(255) NOT NULL,
"param3" varchar(255) NOT NULL,
"param4" varchar(255) NOT NULL,
"param5" varchar(255) NOT NULL,
"param6" varchar(255) NOT NULL,
"param7" varchar(255) NOT NULL,
"delete_it" INTEGER NOT NULL default "1",
PRIMARY KEY ("id")
)

ALTER TABLE "players" ADD "exphist_lastexp" BIGINT NOT NULL DEFAULT '0',
ADD "exphist1" BIGINT NOT NULL DEFAULT '0',
ADD "exphist2" BIGINT NOT NULL DEFAULT '0',
ADD "exphist3" BIGINT NOT NULL DEFAULT '0',
ADD "exphist4" BIGINT NOT NULL DEFAULT '0',
ADD "exphist5" BIGINT NOT NULL DEFAULT '0',
ADD "exphist6" BIGINT NOT NULL DEFAULT '0',
ADD "exphist7" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetimetoday" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime1" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime2" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime3" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime4" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime5" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime6" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime7" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetimeall" BIGINT NOT NULL DEFAULT '0';
Editado por Rusherzin (veja o histórico de edições)

                                                                     Ajudei? De nada \o/                                            Att Rusherzin

Link para o post
Compartilhar em outros sites
PsyMcKenzie

PsyMcKenzie 46

Postado
  • Autor
Postado
O primeiro deu esse erro quando apertei F9: 
 Error while executing query: near "auto_increment": syntax error
<simple query executor>

E o segundo esse:

 Error while executing query: near ",": syntax error
<simple query executor>
Link para o post
Compartilhar em outros sites
Rusherzin

Rusherzin 527

Postado
Postado

Foi mal..

CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `login` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
);

                                                                     Ajudei? De nada \o/                                            Att Rusherzin

Link para o post
Compartilhar em outros sites
PsyMcKenzie

PsyMcKenzie 46

Postado
  • Autor
Postado

Ainda ta dando esse erro:

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetime6 (UPDATE "players" SET "onlinetime7"=players.onlinetime6, "onlinetime6"=players.onlinetime5, "onlinetime5"=players.onlinetime4, "onlinetime4"=players.onlinetime3, "onlinetime3"=players.onlinetime2, "onlinetime2"=players.onlinetime1, "onlinetime1"=players.onlinetimetoday, "onlinetimetoday"=0;)
OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist6 (UPDATE "players" SET "exphist7"=players.exphist6, "exphist6"=players.exphist5, "exphist5"=players.exphist4, "exphist4"=players.exphist3, "exphist3"=players.exphist2, "exphist2"=players.exphist1, "exphist1"=players.experience-players.exphist_lastexp, "exphist_lastexp"=players.experience;)
OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
sqlite3_step(): SQLITE ERROR: columns id, world_id are not unique
~~GOD Dii~~ has logged in.
Error during getDataInt(auction_balance).
OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
 OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
 

 

Link para o post
Compartilhar em outros sites
Rusherzin

Rusherzin 527

Postado
Postado 
ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0';
ALTER TABLE `players` ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0';

                                                                     Ajudei? De nada \o/                                            Att Rusherzin

Link para o post
Compartilhar em outros sites
PsyMcKenzie

PsyMcKenzie 46

Postado
  • Autor
Postado

Aee, ta diminuindo kkk

Só ta dando isso agora:
 

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist1 (UPDATE "players" SET "exphist7"=players.exphist6, "exphist6"=players.exphist5, "exphist5"=players.exphist4, "exphist4"=players.exphist3, "exphist3"=players.exphist2, "exphist2"=players.exphist1, "exphist1"=players.experience-players.exphist_lastexp, "exphist_lastexp"=players.experience;)
sqlite3_step(): SQLITE ERROR: columns id, world_id are not unique
~~GOD Dii~~ has logged in.
Error during getDataInt(auction_balance).
Link para o post
Compartilhar em outros sites
Rusherzin

Rusherzin 527

Postado
Postado 
ALTER TABLE `players` ADD `players.exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0';

E não achei nada relativo aos outros :(

                                                                     Ajudei? De nada \o/                                            Att Rusherzin

Link para o post
Compartilhar em outros sites
PsyMcKenzie

PsyMcKenzie 46

Postado
  • Autor
Postado (editado)

Ah, obrigado mesmo assim cara, valew mesmo em!

Agora só falta isso:

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist1 (UPDATE "players" SET "exphist7"=players.exphist6, "exphist6"=players.exphist5, "exphist5"=players.exphist4, "exphist4"=players.exphist3, "exphist3"=players.exphist2, "exphist2"=players.exphist1, "exphist1"=players.experience-players.exphist_lastexp, "exphist_lastexp"=players.experience;)

sqlite3_step(): SQLITE ERROR: columns id, world_id are not unique
Error during getDataInt(auction_balance).
Editado por PsyMcKenzie (veja o histórico de edições)
Link para o post
Compartilhar em outros sites
  • 1 month later...

Participe da conversa

Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

Visitante
Responder

×   Você colou conteúdo com formatação.   Remover formatação

  Apenas 75 emojis são permitidos.

×   Seu link foi automaticamente incorporado.   Mostrar como link

×   Seu conteúdo anterior foi restaurado.   Limpar o editor

×   Não é possível colar imagens diretamente. Carregar ou inserir imagens do URL.

×
 Share
Seguidores 0
Ir para a lista de tópicos

  • Quem Está Navegando   0 membros estão online

    Nenhum usuário registrado visualizando esta página.

TibiaKing

Open Tibia Server

Quer aprender a criar seu próprio servidor de Tibia? Então está no lugar certo, aqui você encontrará milhares de tutorias, scripts, códigos, mapas e utilitários para que você possa fazer o seu próprio servidor de Tibia começando do zero.

Redes Sociais

Anuncie no TibiaKing

Precisa de mais visibilidade em seus projetos? Quer fazer um plano publicitário para o seu servidor? Anuncie no OTKing e faça sua divulgação, possuímos centenas de acessos simultâneos e milhares diários, com certeza será a sua solução!

×
×
  • Criar Novo...

Informação Importante

Confirmação de Termo

  Eu aceito