[Encerrado] [Dúvida]

[sonkis 6]

Boa Tarde..

Pessoal baixei um servidor mas só veio com a pasta (data) e (mods) então eu coloquei as dll, pasta schemas, arquivo.s3db e um distro (TFS).

Mas quando eu abro o OT aparece alguns bugs que não consigo arrumar...

 

[07/07/2011 14:08:17] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 00180 / 00359 / 006 )

[07/07/2011 14:08:17] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 00176 / 00360 / 006 )

[07/07/2011 14:08:17] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 00180 / 00360 / 006 )

[07/07/2011 14:08:17] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 00180 / 00363 / 006 )

[07/07/2011 14:08:17] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 00176 / 00364 / 006 )

[07/07/2011 14:08:17] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 00180 / 00364 / 006 )

[07/07/2011 14:08:17] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 00170 / 00362 / 006 )

[07/07/2011 14:08:17] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 00168 / 00365 / 006 )

[07/07/2011 14:08:17] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 00169 / 00365 / 006 )

[07/07/2011 14:08:17] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 00170 / 00355 / 006 )

[07/07/2011 14:08:17] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 00170 / 00356 / 006 )

[07/07/2011 14:08:17] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 00171 / 00359 / 006 )

 

 

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

[07/07/2011 14:08:43] [Notice - AnnounceEvent::configureRaidEvent] Unknown type tag for announce event, using default: 22

 

 

[07/07/2011 14:08:43] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "owner" ,"id" FROM "houses" WHERE "owner" IN (SELECT "id" FROM "players" WHERE "lastlogin" < UNIX_TIMESTAMP() - 14*24*60*60))

 

 

[07/07/2011 14:08:47] 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;)

[07/07/2011 14:08:47] 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;)

[07/07/2011 14:08:47] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)

[07/07/2011 14:08:47] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login'

 

 

Gostaria de saber se alguém consegue me ajudar..

[informações Adicionais]

Distro: TFS

Versão: 8.60

Server de outro Fórum...

Quem conseguir resolver ai REP+

Se precisarem de mais alguma informação informem no tópico que eu lhes informo

[VictorTasquin 3]

[07/07/2011 14:08:43] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "owner" ,"id" FROM "houses" WHERE "owner" IN (SELECT "id" FROM "players" WHERE "lastlogin" < UNIX_TIMESTAMP() - 14*24*60*60))

Troque a pasta Schemas de seu servidor.

Aconselho também voce substituir seu DATABASE (arquivo .s3db) por um arquivo de algum outro OT que voce tenha, que funcione perfeitamente!

[kbpaulo 19]

desculpa responder depois de 30 dias mais e que estava lendo outros topico e vi esse e sei responder alguns erros dele....

o quarto erro e so vc executar isso aki na sua database

 

ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0',

ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';

 

e esse tb

 

UPDATE `players` SET `exphist_lastexp`=`players`.`experience`

 

 

 

1ª erro parece que tem algum item nas cordenadas do floor 6 do seu ot bugado entre no mapa editor e retire oqe estiver nakela cordenada.....

2º tem 1 erro na sua parte de EVENTO Raid...tente subistituir ela...ou se suber identificar o erro no Raids/raids.xml

3º nao sei...

4º ta em cima esplicando...

 

desculpa se nao ajudei muito...

[Stigal 584]

A questão neste tópico de suporte foi encerrada por falta de respostas. Este tópico está fechado e foi movido para Suporte - Tópicos Sem Resposta.

+ Caso a dúvida não tenha sido resolvida você poderá criar outro tópico solicitando ajuda.
* Lembre-se que é permitido dar UP no tópico a cada 24 horas para assim o destacar e manter movimentado.