XML parsing error

[Jabantiz]

Don't forget to try the loginstructs.xml just one post above the log you posted

[Cynnar]

would the missing loginstructs.xml file cause the struct errors?

17:07:32 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
17:07:32 E Packet: Could not find struct named 'WS_QuestExamineInfoHeader'

[Skywalker646]

oh i missed that one. here is the new info

21:03:32 W Misc: Error parsing log config. Log setting 'Enabled' has invalid value 'FaTruelse'. 'true'/'on' or 'false'/'off' are valid values
21:03:32 I Init: Starting EQ2Emulator WorldServer...
21:03:32 I DB: Using database 'eq2world' at 127.0.0.1
21:03:32 D World: Randomizing World...
21:03:32 D Init: ./LoginServer.ini read...
21:03:32 I Patcher: Connecting to DB PatchServer...
21:03:32 I Patcher: Connected to patch server at updates.eq2emulator.net:9104
21:03:32 E Patcher: You have tried to download updates too quickly and are now locked out, try again later
21:03:32 I World: Loading System Data...
21:03:32 D DBCore: Query Successful, 38 rows returned
21:03:32 D DBCore: Query Successful, 527 rows returned
21:03:32 D DBCore: Query Successful, 527 rows returned
21:03:32 D DBCore: Query Successful, 528 rows returned
21:03:32 D DBCore: Query Successful, 528 rows returned
21:03:32 D DBCore: Query Successful, 528 rows returned
21:03:32 D DBCore: Query Successful, 531 rows returned
21:03:32 D DBCore: Query Successful, 558 rows returned
21:03:32 D DBCore: Query Successful, 558 rows returned
21:03:32 D DBCore: Query Successful, 558 rows returned
21:03:32 D DBCore: Query Successful, 558 rows returned
21:03:32 D DBCore: Query Successful, 558 rows returned
21:03:32 D DBCore: Query Successful, 559 rows returned
21:03:32 D DBCore: Query Successful, 559 rows returned
21:03:32 D DBCore: Query Successful, 558 rows returned
21:03:32 D DBCore: Query Successful, 558 rows returned
21:03:32 D DBCore: Query Successful, 558 rows returned
21:03:32 D DBCore: Query Successful, 558 rows returned
21:03:32 D DBCore: Query Successful, 558 rows returned
21:03:32 D DBCore: Query Successful, 559 rows returned
21:03:32 D DBCore: Query Successful, 559 rows returned
21:03:32 D DBCore: Query Successful, 559 rows returned
21:03:32 D DBCore: Query Successful, 559 rows returned
21:03:32 D DBCore: Query Successful, 559 rows returned
21:03:32 D DBCore: Query Successful, 559 rows returned
21:03:32 D DBCore: Query Successful, 559 rows returned
21:03:32 D DBCore: Query Successful, 559 rows returned
21:03:32 D DBCore: Query Successful, 559 rows returned
21:03:32 D DBCore: Query Successful, 559 rows returned
21:03:32 D DBCore: Query Successful, 560 rows returned
21:03:32 D DBCore: Query Successful, 560 rows returned
21:03:32 D DBCore: Query Successful, 560 rows returned
21:03:32 D DBCore: Query Successful, 560 rows returned
21:03:33 D DBCore: Query Successful, 560 rows returned
21:03:33 D DBCore: Query Successful, 560 rows returned
21:03:33 D DBCore: Query Successful, 560 rows returned
21:03:33 D DBCore: Query Successful, 560 rows returned
21:03:33 D DBCore: Query Successful, 560 rows returned
21:03:33 D DBCore: Query Successful, 560 rows returned
21:03:33 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
21:03:33 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
21:03:33 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
21:03:33 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
21:03:33 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
21:03:33 E Packet: Could not find struct named 'WS_QuestExamineInfoHeader'
21:03:33 E Packet: Could not find struct named 'WS_QuestExamineInfoHeader'
21:03:34 D DBCore: Query Successful, 1 rows returned
21:03:34 D DBCore: Query Successful, 437 rows returned
21:03:34 D DBCore: Query Successful, 69 rows returned
21:03:34 D DBCore: Query Successful, 224 rows returned
21:03:34 D DBCore: Query Successful, 17 rows returned
21:03:34 D DBCore: Query Successful, 175 rows returned
21:03:34 D DBCore: Query Successful, 7 rows returned
21:03:34 D DBCore: Query Successful, 21670 rows returned
21:03:34 D DBCore: Query Successful, 126 rows returned
21:03:34 D DBCore: Query returned no results in DBcore::RunQuery!
update character_details set xp_vitality=100 where (xp_vitality + 0.000000) > 100
21:03:34 D DBCore: Query returned no results in DBcore::RunQuery!
update character_details set xp_vitality=(xp_vitality+0.000000) where (xp_vitality + 0.000000) <= 100
21:03:34 D DBCore: Query returned no results in DBcore::RunQuery!
update variables set variable_value=1544591014 where variable_name='vitalitytimer'
21:03:34 D DBCore: Query Successful, 6 rows returned
21:03:34 D DBCore: Query returned no results in DBcore::RunQuery!
UPDATE characters SET is_online = 0;
21:03:34 D DBCore: Query Successful, 1 rows returned
21:03:34 D DBCore: Query Successful, 82 rows returned
21:03:34 D DBCore: Query Successful, 1 rows returned
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 I World: Loaded System Data (took 2 seconds)
21:03:34 W Threaded: Using Threaded loading of static data...
21:03:34 M Reformat: JA: This is as far as I got reformatting the console logs.
21:03:34 I Guilds: Loading Guilds...
21:03:34 W Thread: Item Loading Thread started.
21:03:34 W Thread: Spell Loading Thread started.
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 I Guilds: Loaded 0 Guild(s)
21:03:34 I Recipes: Loading Recipe Books...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Recipes: Loaded 0 Recipe Books
21:03:34 I Recipes: Loading Recipes...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 I DB: Using database 'eq2world' at 127.0.0.1
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Recipes: Loaded 0 recipes
21:03:34 I Tradeskills: Loading Tradeskill Events...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Tradeskills: Loaded 0 tradeskill events
21:03:34 I AA: Loading Alternate Advancements...
21:03:34 I Items: Loading Items...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 I AA: Loaded 0 Alternate Advancement(s)
21:03:34 I AA: Loading AA Tree Nodes...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 I AA: Loaded 0 AA Tree Nodes
21:03:34 I Titles: Loading Titles...
21:03:34 D Items: Loaded 0 Normal Items
21:03:34 D DBCore: Query Successful, 472 rows returned
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Baubles
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Bags
21:03:34 D Items: Loaded 0 Books
21:03:34 D World: Loaded 472 Titles
21:03:34 I Languages: Loading Languages...
21:03:34 D Items: Loaded 0 Item Sets
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D World: Loaded 0 Languages
21:03:34 I Chat: Loading channels...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 House Items
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Food Items
21:03:34 I LUA: Loading Spawn Scripts...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Weapons
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D LUA: Loaded 0 SpawnScripts
21:03:34 I LUA: Loading Zone Scripts...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Ranged Weapons
21:03:34 D DBCore: Query Successful, 795 rows returned
21:03:34 D LUA: Loaded 6 ZoneScripts
21:03:34 I World: Loading House Zone Data...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Thrown Weapons
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Armor Pieces
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 I World: Loading Heroic OP Data...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Shields
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Skill Items
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 I World: Loading Race Types Data...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Adornment Items
21:03:34 I World: - Loaded 0 Race Types
21:03:34 I World: Waiting for load threads to finish.
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Recipe Book Items
21:03:34 D Items: Loaded 0 House Containers
21:03:34 D Items: Loading Item Appearances...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Item Appearances
21:03:34 D Items: Loading Item Stats...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Item Stats
21:03:34 D Items: Loading Item Effects...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Item Effects
21:03:34 D Items: Loading Item Level Overrides...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Items: Loaded 0 Item Level Overrides
21:03:34 I Items: Loaded 0 Total Items (took 0 seconds)
21:03:34 D DBCore: Query Successful, 1 rows returned
21:03:34 I Collect: Loading Collections...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Collect: Loaded 0 collections
21:03:34 D Collect: Loaded 0 collection items
21:03:34 D Collect: Loaded 0 collection rewards
21:03:34 I Merchants: Loading Merchants...
21:03:34 D Merchant: Clearing Merchant Inventory...
21:03:34 D Merchant: Loading Merchant Inventory...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Merchant: Loaded 0 Merchant Inventory Item(s)
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Merchant: Loaded 0 Merchant List(s)
21:03:34 I Quests: Loading Quests...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Quest: Loaded 0 Quest(s)
21:03:34 W Thread: Item Loading Thread completed.
21:03:34 I DB: Using database 'eq2world' at 127.0.0.1
21:03:34 I Spells: Loading Spells...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Spells: Loading Spell Effects...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Spells: Loaded 0 Spell Effects.
21:03:34 D Spells: Loading Spell LUA Data...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Spells: Loaded 0 Spell LUA Data entries.
21:03:34 D Spells: Loading Spells Scripts...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 D Spells: Loaded 0 SpellScripts
21:03:34 I Spells: Loaded 0 Spells (took 0 seconds)
21:03:34 I Spells: Loading Spell Errors...
21:03:34 D DBCore: Query Successful, 328 rows returned
21:03:34 I Traits: Loading Traits...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 I Traits: Loaded 0 Trait(s)
21:03:34 W Thread: Spell Loading Thread completed.
21:03:34 I World: Load threads finished.
21:03:34 I World: Total World startup time: 2 seconds.
21:03:34 D World: Starting factory Reader
21:03:34 D World: Starting factory Writer
21:03:34 I Net: World server listening on: 127.0.0.1:9000
21:03:34 I Zone: Starting static zones...
21:03:34 D DBCore: Query Successful, 0 rows returned
21:03:34 I IRC: Starting global IRC server...
21:03:34 D IRC: Connecting to IRC server irc.eq2emulator.net:6667.
21:03:34 D IRC: Successfully connected to the global IRC server!
21:03:34 D Thread: Starting console command thread...
21:03:34 I Console: Type 'help' or '?' and press enter for menu options.
21:03:34 D Thread: Starting autoinit loginserver thread...
21:03:34 I World: Connected to LoginServer: 127.0.0.1: 9100
21:03:35 D Opcode: Opcode 0x201C (8220): ServerOP_ZoneUpdates
21:03:35 D Login: Looking for Login Zone Updates...
21:03:35 D DBCore: Query Successful, 0 rows returned
21:03:35 D Opcode: Opcode 0x201D (8221): ServerOP_LoginEquipment
21:03:35 M TODO: Implement map<character id <map<slot id, updatestruct> > method to update Login.
..\..\source\WorldServer\LoginServer.cpp, LoginServer::Process, 242
21:03:35 D Login: Looking for Login Appearance Updates...
21:04:34 D DBCore: Query returned no results in DBcore::RunQuery!
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 101, 1544591014, 1544591014) ON DUPLICATE KEY UPDATE stat_value = 1544591014, stat_date = 1544591014;
21:04:34 D DBCore: Query returned no results in DBcore::RunQuery!
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 102, 0, 1544591014) ON DUPLICATE KEY UPDATE stat_value = 0, stat_date = 1544591014;
21:04:34 D DBCore: Query returned no results in DBcore::RunQuery!
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 107, 0, 1544591014) ON DUPLICATE KEY UPDATE stat_value = 0, stat_date = 1544591014;
21:04:34 D DBCore: Query Successful, 1 rows returned
21:04:34 D DBCore: Query returned no results in DBcore::RunQuery!
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 104, 2, 1544591074) ON DUPLICATE KEY UPDATE stat_value = 2, stat_date = 1544591074;
21:04:34 D DBCore: Query Successful, 1 rows returned
21:04:34 D DBCore: Query returned no results in DBcore::RunQuery!
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 105, 4, 1544591074) ON DUPLICATE KEY UPDATE stat_value = 4, stat_date = 1544591074;
21:04:34 D DBCore: Query Successful, 1 rows returned
21:04:34 D DBCore: Query returned no results in DBcore::RunQuery!
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 106, 1, 1544591074) ON DUPLICATE KEY UPDATE stat_value = 1, stat_date = 1544591074;
21:04:41 D Opcode: Opcode 0xAB00 (43776): ServerOP_UsertoWorldReq
21:04:41 D DBCore: Query Successful, 1 rows returned
21:04:41 D DBCore: Query Successful, 1 rows returned
21:04:41 D DBCore: Query Successful, 1 rows returned
21:04:41 D Net: AddAuth: 2 Key: 1544591081


21:03:27 I DB: Using database 'eq2world' at 127.0.0.1
21:03:27 W Misc: Error parsing log config. Log setting 'Enabled' has invalid value 'FaTruelse'. 'true'/'on' or 'false'/'off' are valid values
21:03:27 I Login: =====================================
21:03:27 I Login: Initializing Minilogin...
21:03:27 I Login: LoginServer.ini read.
21:03:27 I Login: Loading opcodes...
21:03:27 D DBCore: Query Successful, 38 rows returned
21:03:27 D DBCore: Query Successful, 527 rows returned
21:03:27 D DBCore: Query Successful, 527 rows returned
21:03:27 D DBCore: Query Successful, 528 rows returned
21:03:27 D DBCore: Query Successful, 528 rows returned
21:03:27 D DBCore: Query Successful, 528 rows returned
21:03:27 D DBCore: Query Successful, 531 rows returned
21:03:27 D DBCore: Query Successful, 558 rows returned
21:03:27 D DBCore: Query Successful, 558 rows returned
21:03:27 D DBCore: Query Successful, 558 rows returned
21:03:27 D DBCore: Query Successful, 558 rows returned
21:03:27 D DBCore: Query Successful, 558 rows returned
21:03:27 D DBCore: Query Successful, 559 rows returned
21:03:27 D DBCore: Query Successful, 559 rows returned
21:03:27 D DBCore: Query Successful, 558 rows returned
21:03:27 D DBCore: Query Successful, 558 rows returned
21:03:27 D DBCore: Query Successful, 558 rows returned
21:03:27 D DBCore: Query Successful, 558 rows returned
21:03:27 D DBCore: Query Successful, 558 rows returned
21:03:27 D DBCore: Query Successful, 559 rows returned
21:03:27 D DBCore: Query Successful, 559 rows returned
21:03:27 D DBCore: Query Successful, 559 rows returned
21:03:27 D DBCore: Query Successful, 559 rows returned
21:03:27 D DBCore: Query Successful, 559 rows returned
21:03:27 D DBCore: Query Successful, 559 rows returned
21:03:27 D DBCore: Query Successful, 559 rows returned
21:03:27 D DBCore: Query Successful, 559 rows returned
21:03:27 D DBCore: Query Successful, 559 rows returned
21:03:27 D DBCore: Query Successful, 559 rows returned
21:03:27 D DBCore: Query Successful, 560 rows returned
21:03:27 D DBCore: Query Successful, 560 rows returned
21:03:27 D DBCore: Query Successful, 560 rows returned
21:03:27 D DBCore: Query Successful, 560 rows returned
21:03:27 D DBCore: Query Successful, 560 rows returned
21:03:27 D DBCore: Query Successful, 560 rows returned
21:03:27 D DBCore: Query Successful, 560 rows returned
21:03:27 D DBCore: Query Successful, 560 rows returned
21:03:27 D DBCore: Query Successful, 560 rows returned
21:03:27 D DBCore: Query Successful, 560 rows returned
21:03:27 I Login: Loading Structs... SUCCESS!
21:03:27 I Login: Loading world list...
21:03:27 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldstats set world_status=-4, current_players=0, current_zones=0
21:03:27 I Login: Login server listening on port: 9100
21:03:27 D World: Starting factory Reader
21:03:27 D World: Starting factory Writer
21:03:27 I Login: Kickstarting LoginServer Heartbeat...
21:03:27 D DBCore: Query returned no results in DBcore::RunQuery!
UPDATE login_config SET config_value = 1544591007 WHERE config_name = 'login_heartbeat'
21:03:34 I Login: 7066 New Server connection: 127.0.0.1, port: 59589
21:03:34 D Opcode: Opcode 1000 (4096): ServerOP_LSInfo
21:03:34 D DBCore: Query Successful, 1 rows returned
21:03:34 D DBCore: Query Successful, 1 rows returned
21:03:34 D DBCore: Query Successful, 1 rows returned
21:03:34 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldservers set login_version='0.7.3-dev' where id=1
21:03:34 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
21:03:34 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldstats set connected_time=now() where world_id=1 and (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_update)) > 300
21:03:34 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldservers set lastseen=1544591014 where id=1
21:03:34 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldservers set ip_address='127.0.0.1' where id=1
21:03:49 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
21:04:02 I Login: New client from ip: 192.168.1.33, port: 57093
21:04:04 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
21:04:17 I Login: New client from ip: 192.168.1.33, port: 57093
21:04:17 D Opcode: Opcode 0001 (1): ServerOP_LSInfo
21:04:17 D Login: First struct version = 44392
21:04:17 D Login: First struct failed, trying the second
21:04:17 D Login: Second struct version = 60114
21:04:17 D DBCore: Query Successful, 1 rows returned
21:04:17 D DBCore: Query returned no results in DBcore::RunQuery!
UPDATE account SET ip_address='192.168.1.33' WHERE id = 2
21:04:17 I Login: Using Login Packet version: 60114
21:04:17 D Opcode: Opcode 0021 (33): OP_LsClientVerifylogReplyMsg
21:04:17 D Logs: Saving 'Verify Log' log, size of: 1344
21:04:17 D DBCore: Query returned no results in DBcore::RunQuery!
insert into log_messages (log_type, message, account, client_data_version, log_time) values ('Verify Log', 'build=\"SOEBuild=12133L\" version=\"SOEVersionString=2015/8/17 11:12:50\" build_type=\"USER OPTIMIZED\" ls_address=\"none\" zone=\"ZoneScene::onOpen\" loc=\"-124.68 59.82 -890.29\" performance=\"2\" alert=\"G:\\live\\eq2\\framework\\resman\\ResourceManager.cpp(126): Resource leak! (ui/default/images/window_elements_specific.dds)\"\nbuild=\"SOEBuild=12133L\" version=\"SOEVersionString=2015/8/17 11:12:50\" build_type=\"USER OPTIMIZED\" ls_address=\"none\" zone=\"ZoneScene::onOpen\" loc=\"-124.68 59.82 -890.29\" performance=\"2\" alert=\"G:\\live\\eq2\\framework\\resman\\ResourceManager.cpp(126): Resource leak! (ui/default/images/specialelements.dds)\"\nbuild=\"SOEBuild=12133L\" version=\"SOEVersionString=2015/8/17 11:12:50\" build_type=\"USER OPTIMIZED\" ls_address=\"none\" zone=\"<None>\" loc=\" 0.00 0.00 0.00\" performance=\"3\" alert=\"G:\\live\\eq2\\framework\\vdl\\VdlErr.cpp(85): (VDL Parser) runtimevdl/cbaseclasses.vdl(21) : Error, File not found, runtimevdl/services.vdl.\n\"\nbuild=\"SOEBuild=12133L\" version=\"SOEVersionString=2015/8/17 11:12:50\" build_type=\"USER OPTIMIZED\" ls_address=\"none\" zone=\"<None>\" loc=\" 0.00 0.00 0.00\" performance=\"3\" alert=\"G:\\live\\eq2\\framework\\vdl\\VdlErr.cpp(85): (VDL Parser) runtimevdl/cbaseclasses.vdl(22) : Error, File not found, runtimevdl/soemote.vdl.\n\"\n', 'mattgasser', 60114, 1544591057)
21:04:19 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
21:04:34 D DBCore: Query returned no results in DBcore::RunQuery!
insert into login_worldstats (world_id, world_status, current_players, current_zones, last_update, world_max_level) values(1, 1, 0, 0, NOW(), 50) ON DUPLICATE KEY UPDATE current_players=0,current_zones=0,world_max_level=50,world_status=1,last_update=NOW()
21:04:34 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldservers set lastseen=1544591074 where id=1
21:04:34 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
21:04:34 D Opcode: Opcode 0008 (8): OP_AllWSDescRequestMsg
21:04:34 D Opcode: Opcode 000A (10): OP_AllCharactersDescRequestMsg
21:04:34 D DBCore: Query Successful, 2 rows returned
21:04:34 D DBCore: Query Successful, 0 rows returned
21:04:34 D DBCore: Query Successful, 1 rows returned
21:04:34 D DBCore: Query Successful, 47 rows returned
21:04:34 D DBCore: Query Successful, 0 rows returned
21:04:34 D DBCore: Query Successful, 0 rows returned
21:04:34 D DBCore: Query Successful, 1 rows returned
21:04:34 D DBCore: Query Successful, 47 rows returned
21:04:34 D DBCore: Query Successful, 0 rows returned
21:04:41 D Opcode: Opcode 0013 (19): OP_PlayCharacterRequestMsg
21:04:41 D DBCore: Query Successful, 1 rows returned
21:04:41 D Opcode: Opcode AB01 (43777): ServerOP_UsertoWorldResp
21:04:49 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
21:04:52 D World: Removing connection...
21:05:04 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
21:05:12 I Login: New client from ip: 192.168.1.33, port: 57093
21:05:12 D Opcode: Opcode 0001 (1): ServerOP_LSInfo
21:05:12 D Login: First struct version = 44392
21:05:12 D Login: First struct failed, trying the second
21:05:12 D Login: Second struct version = 60114
21:05:12 D DBCore: Query Successful, 1 rows returned
21:05:12 D DBCore: Query returned no results in DBcore::RunQuery!
UPDATE account SET ip_address='192.168.1.33' WHERE id = 2
21:05:12 I Login: Using Login Packet version: 60114
21:05:13 D Opcode: Opcode 0008 (8): OP_AllWSDescRequestMsg
21:05:13 D Opcode: Opcode 000A (10): OP_AllCharactersDescRequestMsg
21:05:13 D DBCore: Query Successful, 2 rows returned
21:05:13 D DBCore: Query Successful, 0 rows returned
21:05:13 D DBCore: Query Successful, 1 rows returned
21:05:13 D DBCore: Query Successful, 47 rows returned
21:05:13 D DBCore: Query Successful, 0 rows returned
21:05:13 D DBCore: Query Successful, 0 rows returned
21:05:13 D DBCore: Query Successful, 1 rows returned
21:05:13 D DBCore: Query Successful, 47 rows returned
21:05:13 D DBCore: Query Successful, 0 rows returned
21:05:19 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus

[Jabantiz]

would the missing loginstructs.xml file cause the struct errors?

nah those are world structs, will have to check them eventually but they should not prevent the client from connecting to the world.

[Jabantiz]

Still can't get into the world? I see the loginstructs was an issue as now I am seeing the client hitting the world like I expected.


Did you compile the world server yourself or did you grab it from somewhere? If you grabbed it from somewhere then where did you get it?

[Skywalker646]

I compiled it from the windows setup in the instructional material. I thought I had done everything correctly but I guess not

[Jabantiz]

And it is still hanging at the connecting to zone server?

[Skywalker646]

Sadly

[Cynnar]

Well this has been a stubborn issue for sure.

What I would do is a second separate server, including database, and start from scratch. If you have you server in C:\EQ2 then add another folder like C:\EQ2_Test or something like that. Same with the database, create a new DB called eq2world_temp. Re-download minilogin from svn I believe the zip files include the eq2ls.sql within them. Be sure to open up the eq2ls.sql in a text editor and change USE `eq2ls`; to point to your database like USE `eq2world_temp`; otherwise loginserver will be looking in the eq2ls database which doesn't exist.

Extract the minilogin zip before moving any structs or any other files over as the minilogin files might be outdated.

Finally recompile the server and move the required world.exe, configs, and structs to that new folder like the C:\EQ2_Test example above.

These should be the structs needed for world.

• CommonStructs.xml
• ItemStructs.xml
• SpawnStructs.xml
• WorldStructs.xml

There is also a struct named EQ2_Structs.xml that I believe needs to be included, but not sure. The Compile a Windows Server Wiki guide doesn't show this struct in the list, so maybe [mention]Jabantiz[/mention] can clarify if it is required or not.

The config file list for world is as follows...

• log_config.xml
• LoginServer.ini
• world_db.ini

Edit the configs and test it out, and hopefully that will work.

A few things stood out when typing this. First is the structs in minilogin might be outdated. Next was that sourcing in the eq2ls.sql looks for a database called eq2ls. It doesn't create one, just uses it if exist. Last was the EQ2_Structs.xml is missing from the list on the wiki.

You might try fixing those issues with your current database and files.

Keep in mind that The LoginServer.ini found on the minilogin zip is not complete to use with world server, so be sure you are using the ini file from the server source configs folder.

Finally don't forget about Jabantiz's LoginStructs.xm file he posted a few post back.

Here is the difference inthe LoginServer.ini files.
From minilogin zip

Code: Select all

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- NOTE: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

This one is from the source code configs

Code: Select all

### --- This file tells world.exe what loginserver to connect to.
### --- Change the account and password fields to the information you used when you created your SERVER account.

### --- NOTE: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=eq2emulator.net
loginport=9100
worldname=WORLD_NAME_HERE
worldaddress=EXTERNAL_IP_HERE
#internalworldaddress=INTERNAL_IP_HERE (If used, otherwise blank)
worldport=9000
locked=false
account=
password=
#autotableupdates retrieves the latest table updates and applies them to your database
#autotableupdates valid options=always, ask, and never
autotableupdates=always
#autotableverbose displays detailed information about the updates; options=true or false
autotableverbose=false
#autotabledata retrieves the latest data for tables like the opcodes table; options=true or false
autotabledata=true

[WorldServer]
Defaultstatus=
Unavailzone=

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9104

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

[Skywalker646]

I will try that on the weekend if nothing else works. In the meantime, i was fiddling with some things and got this error message

18:51:59 E World : Incompatible version: 44392
18:51:59 I World : Removing client from ip: 192.168.1.33 port: 52923
18:52:13 D World : Removing connection...

does that mean anything? i thought the client i had worked ok. I am able to access the primary server with it.

[Skywalker646]

Do the latest updates for the server software have the info for Alter of Malice? I know that there was an issue with my client on the main server at first but i think someone fixed that and it now works so i wondered if that edit had made its way to the other servers. Apologies if this is a dumb question

[Cynnar]

Not a dumb question at all. I believe we got the issues worked out. The biggest issue was it wasn't accepting quest, but it is working now. I believe the changes have made it to the public source and I really cannot comment on all other servers. The Nameless should be, but I'm 100% sure

[Skywalker646]

well was worth a shot:) was trying all possible things i could think of before trying to build a second attempt and the

18:51:59 E World : Incompatible version: 44392 error message had me thinking

thanks!

[Skywalker646]

I tried recreating with the same database and then creating a brand new one and still no success. Its really frustrating since I've been able to set up other private servers with much greater success

[Cynnar]

I really don't have a clue. Is that the only client you have? Maybe try a different client to see if that gives a different result.