Server is running... But databases appear to be in trouble

[Tyler]

I ran my server last night for the first time and things seemed to be working, but there were several problems.

When I attempted to spawn various items, I got an error stating the item (itemID?) did not exist.

I was not able to learn various skills such as Flight Form, even with the appropriate riding skill/money/level.

When I attempted to learn spells via .learn all command, I received error messages for the vast majority of spells stating that the spell did not exist.

Many NPCs did not path correctly.

I was able to enter 5 man instances, but was not able to initialize any dialogues or initiate any scripted encounters (ie ToC 5 man). I was however able to interact with trainers to learn [most] new abilities.

I was not able to enter any Northrend raids, even while in a raid group. Running into raid portals simply did nothing (I tried ToC and ICC on reg 25 man). I did not receive any error messages such as "There is no ____ difficulty for this dungeon" or "You have not unlocked the _____ version of this dungeon yet."

I tried to enter Sunwell with raid difficulty set to 25 player, but got an error message "There is no heroic difficulty setting available for this dungeon". But when I set Raid Difficulty to 10 player, I was able to enter. I was not able to initialize any scripted encounters/events inside Sunwell. I noticed inside Sunwell there were random NPCs with names such as "NPC_NO_THREAT_TABLE" or inside M'uru's room NPCS with names like "NPC_SPAWN_VOID_SENTINEL_HERE". All of these NPCs had the default Fel Infernal model. After .tele'ing to Durotar, I believe I noticed several more similar NPCs, but I could have been delusional at 4 AM.

Several NPCs, such as the Ymirheim Defender would attack normally when approached or attacked. But others, such as the elites that patrol the ramparts do not even respond to attacks.

Now today upon launching my server, there were a ton of error messages:

2009-04-29 20:54:47 Table `gameobject` have gameobject (GUID: 82933 Entry: 201848) with invalid coordinates, skip
2009-04-29 20:54:47 Table `gameobject` have gameobject (GUID: 82934 Entry: 201592) with invalid coordinates, skip
2009-04-29 20:54:47 Table `gameobject` have gameobject (GUID: 82935 Entry: 201592) with invalid coordinates, skip
2009-04-29 20:54:47 Table `gameobject` have gameobject (GUID: 82936 Entry: 201592) with invalid coordinates, skip
2009-04-29 20:54:47 Table `gameobject` have gameobject (GUID: 82937 Entry: 201592) with invalid coordinates, skip
2009-04-29 20:54:47 Table `gameobject` have gameobject (GUID: 82938 Entry: 201592) with invalid coordinates, skip
2009-04-29 20:54:47 Table `gameobject` have gameobject (GUID: 82939 Entry: 201592) with invalid coordinates, skip

2009-04-29 20:55:04 SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM script_texts
2009-04-29 20:55:04 query ERROR: Table 'realmd.script_texts' doesn't exist
2009-04-29 20:55:04 SQL: SELECT entry, sound, type, language, emote FROM script_texts
2009-04-29 20:55:04 query ERROR: Table 'realmd.script_texts' doesn't exist
2009-04-29 20:55:04 SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM custom_texts
2009-04-29 20:55:04 query ERROR: Table 'realmd.custom_texts' doesn't exist
2009-04-29 20:55:04 SQL: SELECT entry, sound, type, language, emote FROM custom_texts
2009-04-29 20:55:04 query ERROR: Table 'realmd.custom_texts' doesn't exist

2009-04-29 21:35:55 Table `game_graveyard_zone` incomplete: Zone 0 Team 67 does not have a linked graveyard.
2009-04-29 21:35:56 Table `game_graveyard_zone` incomplete: Zone 0 Team 67 does not have a linked graveyard.
2009-04-29 21:35:56 Table `game_graveyard_zone` incomplete: Zone 0 Team 67 does not have a linked graveyard.
2009-04-29 21:35:57 Table `game_graveyard_zone` incomplete: Zone 0 Team 67 does not have a linked graveyard.
2009-04-29 21:35:57 Table `game_graveyard_zone` incomplete: Zone 0 Team 67 does not have a linked graveyard.
2009-04-29 21:35:58 Table `game_graveyard_zone` incomplete: Zone 0 Team 67 does not have a linked graveyard.
2009-04-29 21:35:58 Table `game_graveyard_zone` incomplete: Zone 0 Team 67 does not have a linked graveyard.
2009-04-29 21:35:59 Table `game_graveyard_zone` incomplete: Zone 0 Team 67 does not have a linked graveyard.

2009-04-29 22:21:02 WORLD: CMSG_ITEM_NAME_QUERY for item 51696 failed (item listed in Item.dbc but not exist in DB)
2009-04-29 22:21:02 WORLD: CMSG_ITEM_NAME_QUERY for item 51695 failed (item listed in Item.dbc but not exist in DB)
2009-04-29 22:21:02 WORLD: CMSG_ITEM_NAME_QUERY for item 51694 failed (item listed in Item.dbc but not exist in DB)

2009-04-30 15:57:02 Table `creature` have creature (GUID: 152123 Entry: 17257) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2009-04-30 15:57:02 Table `creature` have creature (GUID: 152123 Entry: 17257) with `MovementType`=0 (idle) have `spawndist`<>0, set to 0.
2009-04-30 15:57:02 Table `creature` have creature (GUID: 152124 Entry: 25315) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2009-04-30 15:57:02 Table `creature` have creature (GUID: 152124 Entry: 25315) with `MovementType`=0 (idle) have `spawndist`<>0, set to 0.
2009-04-30 15:57:02 Table `creature` have creature (GUID: 152125 Entry: 25315) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.
2009-04-30 15:57:02 Table `creature` have creature (GUID: 152125 Entry: 25315) with `MovementType`=0 (idle) have `spawndist`<>0, set to 0.
2009-04-30 15:57:02 Table `creature` have creature (GUID: 152126 Entry: 25315) with `creature_template`.`flags_extra` including CREATURE_FLAG_EXTRA_INSTANCE_BIND but creature are not in instance.

2009-04-30 15:57:51 Table `gameobject` have gameobject (GUID: 82933 Entry: 201848) with invalid coordinates, skip
2009-04-30 15:57:51 Table `gameobject` have gameobject (GUID: 82934 Entry: 201592) with invalid coordinates, skip
2009-04-30 15:57:51 Table `gameobject` have gameobject (GUID: 82935 Entry: 201592) with invalid coordinates, skip
2009-04-30 15:57:51 Table `gameobject` have gameobject (GUID: 82936 Entry: 201592) with invalid coordinates, skip
2009-04-30 15:57:51 Table `gameobject` have gameobject (GUID: 82937 Entry: 201592) with invalid coordinates, skip
2009-04-30 15:57:51 Table `gameobject` have gameobject (GUID: 82938 Entry: 201592) with invalid coordinates, skip

2009-04-30 15:58:54 Table 'creature_loot_template' entry 30424 isn't creature entry and not referenced from loot, and then useless.
2009-04-30 15:59:16 Table 'reference_loot_template' entry 45031 (reference id) not exist but used as loot id in DB.
2009-04-30 15:59:16 Table 'reference_loot_template' entry 45029 (reference id) not exist but used as loot id in DB.
2009-04-30 15:59:16 Table 'reference_loot_template' entry 45032 (reference id) not exist but used as loot id in DB.
2009-04-30 16:00:00 SQL: SELECT version FROM sd2_db_version LIMIT 1

All I would like to know is what database is causing these errors.

MaNGOS/0.16.0-DEV (* * Revision 9800 - *) for Win32 (little-endian)

Using script library: Revision [1679] 2010-04-24 20:42:21 (Win32)

Using World DB: UDB 0.12.0 (390) for MaNGOS 9763 with SD2 SQL for rev. 1667

Using creature EventAI: ACID 3.0.3 - Full Release for Mangos (3.3.0a Client)

Online players: 0 (max: 0) Queued players: 0 (max: 0)

Server uptime: 41 Minute(s) 56 Second(s)

[Tyler]

The edit button won't work for me, so I'm putting this in a reply.

I can enter every instance in the game except for ToC (10 or 25) and ICC (10 or 25). Nothing happens when I go through the portal.

I can enter Naxx, OS, etc on 10 and 25. But if I enter Ulduar on 25 man, there are no NPCs.

None of the NPCs in Ulduar (10 or 25) have any working scripts, so I am unable to start even the FL encounter. I can talk to the NPCs, but they just say "Hello, <Name>." There are no interactions available.

[Ceris]

about scripted encounters:

For working scripted encounters you must download scriptdev/ACID scripts. Check http://www.scriptdev2.com/

Scripted encounters doesnt work "out of the blue", but someone must first script them, then they could be reviewed by sd2 team and added to sources. That is why ToC, ICC and Ulduar is not working.

[Tyler]

I was under the impression that "FULL RELEASE FOR 3.3.2 and 3.3.0a CLIENTS" meant that all the content up to that point was scripted.

But anyway, is there somewhere I can go to download scripted encounters for these instances? I assume the SD2 forums would be the best place since the SD2 team is also in charge of ACID. (right?) If so, that would also be the place to go to learn to do it myself.

[Tyler]

Updated to newest ACID, so Uld 25 isn't empty now.

Still need help with those error messages though.

[Patman128]

Sounds like database-specific problems to me.

[Tyler]

So a problem with my Mangos database means I would have to reapply the most recent Corepatch? The most recent Updatepack? Or do I need to scrap the entire database?