World.exe crashing when somebody joins...

[psalm]

I presume the below is whats causing the disconnect, as it seems to no be able to find the character. I tried creating a new char, and logging straight in, but had the same problem.

World.exe

[Error] in AdventureManager:::GetLeaderboardInfo: Select ch.name, ch.id, adv_stats.* from adventure_stats AS adv_stats left join character_ AS ch on adv_stats.player_id = ch.id; (#1146: Table 'peq.adventure_stats' doesn't exist)
Error in GetCharacterInfo query 'SELECT id, account_id, zonename, instanceid, x, y, z, FROM character_ WHERE name='Gold'' #1054: Unknown column 'instanceid' in field list'

[debug] [WORLD_CLIENT_ERR] mini: Could not get CharInfo for 'Gold'
[debug] [WORLD_CLIENT] mini: Client disconnected (not active in process)

[rencro]

Ok,,,,,,, so you are still using your old player tables from the old install and you did not drop_players when you upgraded peq..

You would'nt want to drop the players if you wanted to preserve existing characters, but I'm thinking in your case there prob arent many existing chars, so best thing is to drop world and players on yor peq db, and install it again, as well as the updated sql 1696..

You could preserve your chars if you wanted, but you would need to apply any sql's that modified those tables from when your db was initially made.

[rencro]

Take a read here for basic info on db

http://www.peqtgc.com/phpBB2/viewtopic.php?t=7112