[Encerrado] Bug Xvx Server

[markiiitu 0]

Bom galera, se alguem já passou por esse erro, espero que alguém me dê uma luz, porque segui a risca tudo o que foi recomendado, estou usando o MySQL como no tutorial, só que esse erro persiste, meu OT fica On, porém nenhuma acc entra.

 

[29/07/2009 00:22:31] The Forgotten Server, version 0.3.5_SVN (Crying Damson)

[29/07/2009 00:22:31] A server developed by Elf, Talaturen, Lithium, Kiper, Kornholijo, KaczooH, slawkens & Macroman.

[29/07/2009 00:22:31] Visit our forum for updates, support and resources: http://otland.net.

 

[29/07/2009 00:22:31] >> Loading config (config.lua)

[29/07/2009 00:22:31] > Using plaintext passwords

[29/07/2009 00:22:31] >> Checking software version... outdated, please consider updating!

[29/07/2009 00:22:31] > Current version information - version: 0.3.5_SVN, patch: 0, build: 0, timestamp: 0.

[29/07/2009 00:22:31] > Latest version information - version: 0.3.4, patch: 2, build: 1879, timestamp: 1242396574.

[29/07/2009 00:22:31] >> Fetching blacklist

[29/07/2009 00:22:32] >> Loading RSA key

[29/07/2009 00:22:32] >> Starting SQL connection

 

[29/07/2009 00:22:32] > WARNING: max_allowed_packet might be set too low for binary map storage.

[29/07/2009 00:22:32] Use the following query to raise max_allow_packet: SET GLOBAL max_allowed_packet = 16776192;

[29/07/2009 00:22:32] >> Running Database Manager

[29/07/2009 00:22:33] > Trigger: oncreate_guilds does not exist, creating it...

[29/07/2009 00:22:33] mysql_real_query(): CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds` FOR EACH ROW BEGIN INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`); END; - MYSQL ERROR: Unknown column 'id' in 'NEW' (1054)

[29/07/2009 00:22:33] > Trigger: ondelete_guilds does not exist, creating it...

[29/07/2009 00:22:33] mysql_real_query(): CREATE TRIGGER `ondelete_guilds` BEFORE DELETE ON `guilds` FOR EACH ROW BEGIN UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`); END; - MYSQL ERROR: Unknown column 'id' in 'OLD' (1054)

[29/07/2009 00:22:33] > Optimizing table: accounts... [success]

[29/07/2009 00:22:34] > Optimizing table: bans... [success]

[29/07/2009 00:22:34] > Optimizing table: global_storage... [success]

[29/07/2009 00:22:35] > Optimizing table: guilds... [success]

[29/07/2009 00:22:35] > Optimizing table: house_data... [success]

[29/07/2009 00:22:35] > Optimizing table: houseaccess... [success]

[29/07/2009 00:22:36] > Optimizing table: houses... [success]

[29/07/2009 00:22:36] > Optimizing table: items... [success]

[29/07/2009 00:22:36] > Optimizing table: players... [success]

[29/07/2009 00:22:37] > Optimizing table: playerstorage... [success]

[29/07/2009 00:22:37] > Optimizing table: server_config... [success]

[29/07/2009 00:22:37] > Optimizing table: server_motd... [success]

[29/07/2009 00:22:38] > Optimizing table: server_record... [success]

[29/07/2009 00:22:38] > Optimizing table: server_reports... [success]

[29/07/2009 00:22:38] > Optimizing table: skills... [success]

[29/07/2009 00:22:38] > Optimizing table: tileitems... [success]

[29/07/2009 00:22:39] > Optimizing table: tilelist... [success]

[29/07/2009 00:22:39] > Optimizing table: viplist... [success]

[29/07/2009 00:22:39] >> Loading items

[29/07/2009 00:22:40] >> Loading groups

[29/07/2009 00:22:40] >> Loading vocations

[29/07/2009 00:22:40] >> Loading script systems

[29/07/2009 00:22:43] >> Loading chat channels

[29/07/2009 00:22:44] >> Loading outfits

[29/07/2009 00:22:44] >> Loading experience stages

[29/07/2009 00:22:44] >> Loading monsters

[29/07/2009 00:22:49] >> Loading mods...

[29/07/2009 00:22:49] Loading buypremium_command.xml... done.

[29/07/2009 00:22:49] Loading changender_command.xml... done.

[29/07/2009 00:22:49] Loading custommonsters.xml... done.

[29/07/2009 00:22:49] Loading customspells.xml... done.

[29/07/2009 00:22:49] Loading firstitems.xml... done, but disabled.

[29/07/2009 00:22:49] Loading highscorebook.xml... done.

[29/07/2009 00:22:49] > 6 mods were loaded.

[29/07/2009 00:22:49] >> Loading map and spawns...

[29/07/2009 00:22:58] > Map size: 38000x38000.

[29/07/2009 00:22:58] > Map descriptions:

[29/07/2009 00:22:58] Saved with Remere's Map Editor 1.1.8

[29/07/2009 00:22:58] XvX Global Project 0.3

[29/07/2009 00:24:32] > Map loading time: 102.39 seconds.

[29/07/2009 00:24:40] Parameter 'keyword_reply3' missing. Skipping...

[29/07/2009 00:24:40] Parameter 'keyword_reply4' missing. Skipping...

[29/07/2009 00:24:42] Parameter 'keyword_reply1' missing. Skipping...

[29/07/2009 00:24:42] Parameter 'keyword_reply2' missing. Skipping...

[29/07/2009 00:24:42] Parameter 'keyword_reply40' missing. Skipping...

[29/07/2009 00:24:42] Parameter 'keyword_reply41' missing. Skipping...

[29/07/2009 00:24:42] Parameter 'keyword_reply4' missing. Skipping...

[29/07/2009 00:24:42] Parameter 'keyword_reply3' missing. Skipping...

[29/07/2009 00:24:42] Parameter 'keyword_reply4' missing. Skipping...

[29/07/2009 00:24:42] Parameter 'keyword_reply4' missing. Skipping...

 

 

[29/07/2009 00:24:44] Parameter 'keyword_reply3' missing. Skipping...

[29/07/2009 00:24:44] Parameter 'keyword_reply4' missing. Skipping...

 

 

 

[29/07/2009 00:24:45] Parameter 'keyword_reply3' missing. Skipping...

[29/07/2009 00:24:45] Parameter 'keyword_reply4' missing. Skipping...

[29/07/2009 00:24:46] Parameter 'keyword_reply4' missing. Skipping...

 

[29/07/2009 00:24:46] > Data parsing time: 14.172 seconds.

[29/07/2009 00:24:47] mysql_real_query(): SELECT `id` FROM `houses` WHERE `id` = 1 AND `world_id` = 0 LIMIT 1; - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)

[29/07/2009 00:24:47] mysql_real_query(): INSERT INTO `houses` (`id`, `world_id`, `owner`, `name`, `town`, `size`, `price`, `rent`, `doors`, `beds`, `tiles`, `guild`) VALUES (1, 0, 0, 'Edron 1', 9, 31, 235000, 0, 3, 2, 47, 0); - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)

[29/07/2009 00:24:48] mysql_real_query(): SELECT `house_id`, `player_id`, `bid` FROM `house_auctions` WHERE `endtime` < 1248837887; - MYSQL ERROR: Table 'otserv.house_auctions' doesn't exist (1146)

[29/07/2009 00:24:48] > Houses synchronization time: 1.282 seconds.

[29/07/2009 00:24:48] > Content unserialization time: 0.438 seconds.

[29/07/2009 00:24:48] >> Checking world type... PvP

[29/07/2009 00:24:48] >> Initializing game state modules and registering services...

[29/07/2009 00:24:51] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=0 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15; - MYSQL ERROR: Table 'otserv.player_skills' doesn't exist (1146)

[29/07/2009 00:24:51] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=1 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15; - MYSQL ERROR: Table 'otserv.player_skills' doesn't exist (1146)

[29/07/2009 00:24:51] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=2 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15; - MYSQL ERROR: Table 'otserv.player_skills' doesn't exist (1146)

[29/07/2009 00:24:51] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=3 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15; - MYSQL ERROR: Table 'otserv.player_skills' doesn't exist (1146)

[29/07/2009 00:24:51] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=4 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15; - MYSQL ERROR: Table 'otserv.player_skills' doesn't exist (1146)

[29/07/2009 00:24:51] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=5 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15; - MYSQL ERROR: Table 'otserv.player_skills' doesn't exist (1146)

[29/07/2009 00:24:51] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=6 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15; - MYSQL ERROR: Table 'otserv.player_skills' doesn't exist (1146)

[29/07/2009 00:24:51] mysql_real_query(): UPDATE `players` SET `online` = 0 WHERE `world_id` = 0; - MYSQL ERROR: Unknown column 'online' in 'field list' (1054)

[29/07/2009 00:24:51] mysql_real_query(): SELECT `id` FROM `accounts` WHERE `lastday` <= 1248751491; - MYSQL ERROR: Unknown column 'lastday' in 'where clause' (1054)

[29/07/2009 00:24:51] > Global address: 189.32.145.47

[29/07/2009 00:24:52] > Local ports: 7171 7172

[29/07/2009 00:24:52] >> All modules were loaded, server is starting up...

[29/07/2009 00:24:52] >> XvX server Online!

[lordguadalupano 0]

Bom, você tá usando a database de outro otserver sem ser a do xvx? Porque ali diz: Optimizing table...

Normalmente esse erro acontece quando usa a db de um ot, em um outro cujo o executável não aceita, daí ngm vai logar msm. Quando você troca de ot, acho q o mais apropriado é resetá-lo, ou então usar o executável e as dll's do otserv antigo, no novo.

[Maicondoze 1]

tbm ta acontecendo isso cmg, a unica coisa q fiz foi mudar os lib pra tira o bug de compra de graça ai começo tbm otro problema:

 

 

[02/12/2010 16:40:26] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 33211 / 31791 / 007 )

[02/12/2010 16:40:26] [Error - IOMapSerialize::loadMapRelational] Unserialization of invalid tile at position ( 33214 / 31791 / 007 )

...............

mas n tem nd de mais nesses locais

[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.