[SOLVED] problems with mangos zero

[sgt_McMuffin]

so i just recently got mangos zero built and running (32bit version built on 8/20/2013 using visual studio express 2012) and i'm have problem with mangosd.exe randomly getting a random run time library debug error which looks like this

I attached the server.log file. the error seems to be occurring at random, or when ever i log out or exit the game client, and when i log back in i find all my items, skills, spells, and spent talent points are gone. any help on the matter would be appreciated.

[attachment deleted by admin]

[TheLuda]

As per your error log, you either have configured no character database in mangosd.conf, or deleted a few tables.

Check your character database, and compare it with the dump included, and check if you have properly set all configuration values in mangosd.conf.

[sgt_McMuffin]

so i checked my characters database found one missing table put it in, now i'm still getting the debug error on log out or at random intervals, but when i log back in i my character isn't empty any more

[lfxgroove]

There's at least 2 missing tables from what the Server.log would tell: character_inventory and character_reputation. Are you sure you've added them both in? Are these events totally random or can you pinpoint something specific you were doing when it happened except for logging out?

[sgt_McMuffin]

from what i can tell the error seems to occur for logging/exiting, using the .save and .saveall commands, occasionally it seem to happen with me just running through orgrimmar, or when using the taxi waypoints,

[TheLuda]

Of course it will happen frequently, because the server frequently will try to save your character state.

You should have these tables in the character database:

• 
  [li]auction[/li]
  [li]bugreport[/li]
  [li]character_action[/li]
  [li]character_aura[/li]
  [li]character_battleground_data[/li]
  [li]character_db_version[/li]
  [li]character_gifts[/li]
  [li]character_homebind[/li]
  [li]character_honor_cp[/li]
  [li]character_instance[/li]
  [li]character_inventory[/li]
  [li]character_pet[/li]
  [li]character_queststatus[/li]
  [li]character_reputation[/li]
  [li]character_skills[/li]
  [li]character_social[/li]
  [li]character_spell[/li]
  [li]character_spell_cooldown[/li]
  [li]character_stats[/li]
  [li]character_ticket[/li]
  [li]character_tutorial[/li]
  [li]characters[/li]
  [li]corpse[/li]
  [li]creature_respawn[/li]
  [li]game_event_status[/li]
  [li]gameobject_respawn[/li]
  [li]group_instance[/li]
  [li]group_member[/li]
  [li]groups[/li]
  [li]guild[/li]
  [li]guild_eventlog[/li]
  [li]guild_member[/li]
  [li]guild_rank[/li]
  [li]instance[/li]
  [li]instance_reset[/li]
  [li]item_instance[/li]
  [li]item_loot[/li]
  [li]item_text[/li]
  [li]mail[/li]
  [li]mail_items[/li]
  [li]pet_aura[/li]
  [li]pet_spell[/li]
  [li]pet_spell_cooldown[/li]
  [li]petition[/li]
  [li]petition_sign[/li]
  [li]saved_variables[/li]
  [li]world[/li]
  

Executing SHOW TABLES; in MySQL should show these. If not, import the missing tables, or if you are upgrading from a very very much older mangos-zero version, apply the updates.

[sgt_McMuffin]

ok so i found the missing tables and added them all and every thing's stable now, thanks for all the help! ;D