I feeel SO noob -DB issues-

Auntie Mangos · January 1, 1970

OK soo i recompiled a new update of Mangos/ahbot the same as always ( i decided to try ahbot )

i get

========== Build: 12 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

but i see this in the output which always happens ( their are other warnings but in the end no failurs)

11>..\\..\\dep\\src\\gsoap\\stdsoap2.cpp(835): warning C4244: 'return' : conversion from 'std::streamsize' to 'size_t', possible loss of data

Any way checking the ah version vs the master version it seems the AH version is uptodate based on the master version ok should be good their

Time to SVN update S2D Nice and ez slight updates..

Completed: At revision: 1892

time to compile

scriptVC100.sln -> compile 32 bit due to consistancys and same error

C:\\Mangos\\src\\bindings\\Scriptdev2\\VC100\\100ScriptDev2.vcxproj : warning : Platform 'x64' referenced in the project file 'ScriptDev2' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

Yay sucess

========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

( and no warnings)

OK so now to move the happy files to their new homes...

copy -> replace

------- excert from install guide -------------------------------------------------------------------------------------------------------

http://getmangos.eu/community/topic/13121/world-of-warcraft-server-for-windows-installation-guide/

Email PMRe: World of Warcraft Server for Windows - Installation GuidePART 9 - INSTALLING MANGOS

• Transfer the files from your compile folder into C:\\Mangos

** They should be in C:\\Mangos\\bin\\Win32_Release

• Go to C:\\Mangos\\src\\mangosd and copy "mangosd.conf.dist.in" to "mangosd.conf" in C:\\Mangos

• Go to C:\\Mangos\\src\\realmd and copy "realmd.conf.dist.in" to "realmd.conf" in C:\\Mangos

• Go to C:\\Mangos\\src\\bindings\\ScriptDev2 and copy "scriptdev2.conf.dist.in" to "scriptdev2.conf" in C:\\Mangos

-------------------------------------------------------------------------------------------------------------------------------------

re modify .conf files

OK thats done ..

time to update the sql's

ooh look new files... ahh do i update the sd2 first or the mangos -- go back and review install info--

** First thing to do is to determine your databases versions

OK SOO ahhhh....

Char.....

required_10664_01_characters_arena_team_statsbit(1) NULL

soo wait i need to fix this i guess ....um yea how to fix this with out messing it up

Query : ALTER TABLE character_db_version CHANGE COLUMN required_10160_01_characters_character_aura required_10160_02_characters_pet_aura...

Error Code : 1054

Unknown column 'required_10160_01_characters_character_aura' in 'character_db_version'

grr ok so ... i gotta go all the way back ... i thought the mass update thing was supposed to update to more current versions OH well time to load a ton of sql's

Auntie Mangos · January 1, 1970

OK so finaly back on track. I have my mangos installed my "mysql" reinstalled and using this guide

http://getmangos.eu/community/topic/13121/world-of-warcraft-server-for-windows-installation-guide/

unfortunatly i don't have a lot of time to work on it in general due to needing to find a house lol trying to buy a house is a pain in the ......... any way will try to update asap

raven7931 · November 26, 2010

OK soo i've got the whole thing "working" how ever their are many things "broken" during the instilation of updates (the sql files) i get errors like "feild scrips dosent exist"

--note after the fact looks like i need to "dowgrade" my s2d or "upgrade" my mangos but i thought i was using the newest version. Sigh

I just want it to work right for a nice safe place for my kids to play and with out being broken for my family to enjoy. Guess I'm just getting to old lol

Any way if any one can help me get all the right parts for a nice working stable 3.3.5a version i would be ever so greatfull. ANd explain it like you were telling an OLD guy

UDB 0.12.1 (393) for MaNGOS 10545 with SD2 SQL for rev. 1833

ACID 3.0.7 - Full Release for Mangos (3.3.5a Client)

(catch id) 393

ScriptDev2 (for MaNGOS 10761+)

Arrg do i have the wrong stuff ... just noticed the seemingly incapatability here... ( i tryed to get ALL the newest versions )

I do not envy you pros this is a lot of stuff to memorize and stuff i wanna pull out my hair

Auntie Mangos · November 27, 2010

The first thing to do: calm down, and relax.

On which operating system do you plan to run mangos? Windows, Mac OS X, Linux?

No worries, I understand the feeling of being to old for all this stuff

I'll guide you step by step.

raven7931 · November 27, 2010

I compile every thing in 32bit because the 64 bit compiling seems to be buggy

please don't look down on my dell i support them even though some have bad experances i have always had great experances

Operating System: Windows 7 Ultimate 64-bit (6.1, Build 7600) (7600.win7_gdr.100618-1621)

Language: English (Regional Setting: English)

System Manufacturer: Dell Inc.

System Model: Studio XPS 7100

BIOS: Default System BIOS

Processor: AMD Phenom II X6 1035T Processor (6 CPUs), ~2.6GHz

Memory: 8192MB RAM

Available OS Memory: 8192MB RAM

Page File: 2446MB used, 13934MB available

Windows Dir: C:\\Windows

DirectX Version: DirectX 11

DX Setup Parameters: Not found

User DPI Setting: Using System DPI

System DPI Setting: 96 DPI (100 percent)

DWM DPI Scaling: Disabled

DxDiag Version: 6.01.7600.16385 64bit Unicod

davemm · November 27, 2010

It would be much more helpful if you were to post the exact error message you are getting, and when.

raven7931 · November 27, 2010

I will post some for instances... during mangosd start up / server log

2010-11-27 08:40:12 ERROR:SD2: Script registering but ScriptName npc_barrett_ramsey is not assigned in database. Script will not be used.

2010-11-27 08:40:12 ERROR:SD2: Script registering but ScriptName mob_parasitic_shadowfiend is not assigned in database. Script will not be used.

2010-11-27 08:40:12 ERROR:SD2: Script registering but ScriptName mob_shadowy_construct is not assigned in database. Script will not be used.

------------------------------

2010-11-27 13:08:40 ERROR:Table 'item_loot_template' entry 5523 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 13:08:40 ERROR:Table 'item_loot_template' entry 5524 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 13:08:40 ERROR:Table 'item_loot_template' entry 6712 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 13:08:40 ERROR:Table 'item_loot_template' entry 7973 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 13:08:40 ERROR:Table 'item_loot_template' entry 15874 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 13:08:40 ERROR:Table 'item_loot_template' entry 24476 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

------------------------------------

2010-11-27 13:08:43 ERROR:Quest 4921 has `SpecialFlags` = 8, above max flags not allowed for database.

2010-11-27 13:08:43 ERROR:Quest 5929 has `SpecialFlags` = 10, above max flags not allowed for database.

2010-11-27 13:08:43 ERROR:Quest 5930 has `SpecialFlags` = 10, above max flags not allowed for database.

2010-11-27 13:08:43 ERROR:Quest 10040 has `SpecialFlags` = 140, above max flags not allowed for database.

2010-11-27 13:08:43 ERROR:Monthly quest 10040 not marked as repeatable in `SpecialFlags`, added.

2010-11-27 13:08:43 ERROR:Quest 10041 has `SpecialFlags` = 140, above max flags not allowed for database.

2010-11-27 13:08:43 ERROR:Monthly quest 10041 not marked as repeatable in `SpecialFlags`, added.

2010-11-27 13:08:43 ERROR:Spell (id: 33824) have SPELL_EFFECT_QUEST_COMPLETE for quest 10162 , but quest does not have SpecialFlags QUEST_SPECIAL_FLAG_EXPLORATION_OR_EVENT (2) set. Quest SpecialFlags should be corrected to enable this objective.

---------

During updates of .sql's i get errors like "feild" "script" dose not exist

I will get more exact errors when i have a chance to "reload the .sql's

----------------------------------

DB error log

2010-11-27 08:32:30 Item (Entry: 90000) not correct (not listed in list of existing items).

2010-11-27 08:32:30 >> Loaded 0 Item converts . DB table `item_convert` is empty.

2010-11-27 08:32:35 Table `creature` have creature (GUID: 46833 Entry: 11798) with low current mana (0), `creature_template`.`minmana`=2790.

2010-11-27 08:32:41 Quest 4921 has `SpecialFlags` = 8, above max flags not allowed for database.

2010-11-27 08:32:41 Quest 5929 has `SpecialFlags` = 10, above max flags not allowed for database.

2010-11-27 08:32:41 Quest 5930 has `SpecialFlags` = 10, above max flags not allowed for database.

2010-11-27 08:32:41 Quest 10040 has `SpecialFlags` = 140, above max flags not allowed for database.

2010-11-27 08:32:41 Monthly quest 10040 not marked as repeatable in `SpecialFlags`, added.

2010-11-27 08:32:41 Quest 10041 has `SpecialFlags` = 140, above max flags not allowed for database.

2010-11-27 08:32:41 Monthly quest 10041 not marked as repeatable in `SpecialFlags`, added.

2010-11-27 08:32:41 Spell (id: 33824) have SPELL_EFFECT_QUEST_COMPLETE for quest 10162 , but quest does not have SpecialFlags QUEST_SPECIAL_FLAG_EXPLORATION_OR_EVENT (2) set. Quest SpecialFlags should be corrected to enable this objective.

2010-11-27 08:32:49 Table 'item_loot_template' entry 5523 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:32:49 Table 'item_loot_template' entry 5524 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:32:49 Table 'item_loot_template' entry 6712 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:32:49 Table 'item_loot_template' entry 7973 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:32:49 Table 'item_loot_template' entry 15874 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:32:49 Table 'item_loot_template' entry 24476 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:32:49 Table 'milling_loot_template' entry 36902 isn't item entry (herb) and not referenced from loot, and then useless.

2010-11-27 08:32:53 Creature (Entry: 3921) has gossip_menu_id = 3033 for nonexistent menu

2010-11-27 08:32:53 Gossip menu option (MenuId: 2343 Id: 2) have action_menu_id = 11422 for nonexistent menu

2010-11-27 08:32:53 Gossip menu option (MenuId: 2343 Id: 3) have action_menu_id = 11422 for nonexistent menu

2010-11-27 08:32:53 Table gossip_menu_option for menu 5602, id 0 has `npc_option_npcflag` = 1 but creatures using this menu does not have corresponding`npcflag`. Option will not accessible in game.

2010-11-27 08:32:53 Table gossip_menu_option for menu 10662, id 0 has `npc_option_npcflag` = 1048576 but creatures using this menu does not have corresponding`npcflag`. Option will not accessible in game.

2010-11-27 08:36:09 Item (Entry: 90000) not correct (not listed in list of existing items).

2010-11-27 08:36:09 >> Loaded 0 Item converts . DB table `item_convert` is empty.

2010-11-27 08:36:14 Table `creature` have creature (GUID: 46833 Entry: 11798) with low current mana (0), `creature_template`.`minmana`=2790.

2010-11-27 08:36:19 Quest 4921 has `SpecialFlags` = 8, above max flags not allowed for database.

2010-11-27 08:36:19 Quest 5929 has `SpecialFlags` = 10, above max flags not allowed for database.

2010-11-27 08:36:19 Quest 5930 has `SpecialFlags` = 10, above max flags not allowed for database.

2010-11-27 08:36:19 Quest 10040 has `SpecialFlags` = 140, above max flags not allowed for database.

2010-11-27 08:36:19 Monthly quest 10040 not marked as repeatable in `SpecialFlags`, added.

2010-11-27 08:36:19 Quest 10041 has `SpecialFlags` = 140, above max flags not allowed for database.

2010-11-27 08:36:19 Monthly quest 10041 not marked as repeatable in `SpecialFlags`, added.

2010-11-27 08:36:19 Spell (id: 33824) have SPELL_EFFECT_QUEST_COMPLETE for quest 10162 , but quest does not have SpecialFlags QUEST_SPECIAL_FLAG_EXPLORATION_OR_EVENT (2) set. Quest SpecialFlags should be corrected to enable this objective.

2010-11-27 08:36:28 Table 'item_loot_template' entry 5523 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:36:28 Table 'item_loot_template' entry 5524 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:36:28 Table 'item_loot_template' entry 6712 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:36:28 Table 'item_loot_template' entry 7973 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:36:28 Table 'item_loot_template' entry 15874 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:36:28 Table 'item_loot_template' entry 24476 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:36:28 Table 'milling_loot_template' entry 36902 isn't item entry (herb) and not referenced from loot, and then useless.

2010-11-27 08:36:32 Creature (Entry: 3921) has gossip_menu_id = 3033 for nonexistent menu

2010-11-27 08:36:32 Gossip menu option (MenuId: 2343 Id: 2) have action_menu_id = 11422 for nonexistent menu

2010-11-27 08:36:32 Gossip menu option (MenuId: 2343 Id: 3) have action_menu_id = 11422 for nonexistent menu

2010-11-27 08:36:33 Table gossip_menu_option for menu 5602, id 0 has `npc_option_npcflag` = 1 but creatures using this menu does not have corresponding`npcflag`. Option will not accessible in game.

2010-11-27 08:36:33 Table gossip_menu_option for menu 10662, id 0 has `npc_option_npcflag` = 1048576 but creatures using this menu does not have corresponding`npcflag`. Option will not accessible in game.

2010-11-27 08:39:41 Item (Entry: 90000) not correct (not listed in list of existing items).

2010-11-27 08:39:41 >> Loaded 0 Item converts . DB table `item_convert` is empty.

2010-11-27 08:39:46 Table `creature` have creature (GUID: 46833 Entry: 11798) with low current mana (0), `creature_template`.`minmana`=2790.

2010-11-27 08:39:52 Quest 4921 has `SpecialFlags` = 8, above max flags not allowed for database.

2010-11-27 08:39:52 Quest 5929 has `SpecialFlags` = 10, above max flags not allowed for database.

2010-11-27 08:39:52 Quest 5930 has `SpecialFlags` = 10, above max flags not allowed for database.

2010-11-27 08:39:52 Quest 10040 has `SpecialFlags` = 140, above max flags not allowed for database.

2010-11-27 08:39:52 Monthly quest 10040 not marked as repeatable in `SpecialFlags`, added.

2010-11-27 08:39:52 Quest 10041 has `SpecialFlags` = 140, above max flags not allowed for database.

2010-11-27 08:39:52 Monthly quest 10041 not marked as repeatable in `SpecialFlags`, added.

2010-11-27 08:39:52 Spell (id: 33824) have SPELL_EFFECT_QUEST_COMPLETE for quest 10162 , but quest does not have SpecialFlags QUEST_SPECIAL_FLAG_EXPLORATION_OR_EVENT (2) set. Quest SpecialFlags should be corrected to enable this objective.

2010-11-27 08:40:00 Table 'item_loot_template' entry 5523 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:40:00 Table 'item_loot_template' entry 5524 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:40:00 Table 'item_loot_template' entry 6712 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:40:00 Table 'item_loot_template' entry 7973 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:40:00 Table 'item_loot_template' entry 15874 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:40:00 Table 'item_loot_template' entry 24476 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 08:40:01 Table 'milling_loot_template' entry 36902 isn't item entry (herb) and not referenced from loot, and then useless.

2010-11-27 08:40:05 Creature (Entry: 3921) has gossip_menu_id = 3033 for nonexistent menu

2010-11-27 08:40:05 Gossip menu option (MenuId: 2343 Id: 2) have action_menu_id = 11422 for nonexistent menu

2010-11-27 08:40:05 Gossip menu option (MenuId: 2343 Id: 3) have action_menu_id = 11422 for nonexistent menu

2010-11-27 08:40:05 Table gossip_menu_option for menu 5602, id 0 has `npc_option_npcflag` = 1 but creatures using this menu does not have corresponding`npcflag`. Option will not accessible in game.

2010-11-27 08:40:05 Table gossip_menu_option for menu 10662, id 0 has `npc_option_npcflag` = 1048576 but creatures using this menu does not have corresponding`npcflag`. Option will not accessible in game.

2010-11-27 12:24:26 WORLD: CMSG_ITEM_NAME_QUERY for item 46279 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 12:24:26 WORLD: CMSG_ITEM_NAME_QUERY for item 46281 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 12:24:26 WORLD: CMSG_ITEM_NAME_QUERY for item 46283 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 12:24:26 WORLD: CMSG_ITEM_NAME_QUERY for item 46284 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 12:24:26 WORLD: CMSG_ITEM_NAME_QUERY for item 46286 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 13:02:35 Summoned pet (Entry: 32751) not have pet stats data in DB

2010-11-27 13:08:40 Table 'item_loot_template' entry 5523 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 13:08:40 Table 'item_loot_template' entry 5524 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 13:08:40 Table 'item_loot_template' entry 6712 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 13:08:40 Table 'item_loot_template' entry 7973 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 13:08:40 Table 'item_loot_template' entry 15874 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 13:08:40 Table 'item_loot_template' entry 24476 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2010-11-27 13:08:40 Table 'milling_loot_template' entry 36902 isn't item entry (herb) and not referenced from loot, and then useless.

2010-11-27 13:08:43 Quest 4921 has `SpecialFlags` = 8, above max flags not allowed for database.

2010-11-27 13:08:43 Quest 5929 has `SpecialFlags` = 10, above max flags not allowed for database.

2010-11-27 13:08:43 Quest 5930 has `SpecialFlags` = 10, above max flags not allowed for database.

2010-11-27 13:08:43 Quest 10040 has `SpecialFlags` = 140, above max flags not allowed for database.

2010-11-27 13:08:43 Monthly quest 10040 not marked as repeatable in `SpecialFlags`, added.

2010-11-27 13:08:43 Quest 10041 has `SpecialFlags` = 140, above max flags not allowed for database.

2010-11-27 13:08:43 Monthly quest 10041 not marked as repeatable in `SpecialFlags`, added.

2010-11-27 13:08:43 Spell (id: 33824) have SPELL_EFFECT_QUEST_COMPLETE for quest 10162 , but quest does not have SpecialFlags QUEST_SPECIAL_FLAG_EXPLORATION_OR_EVENT (2) set. Quest SpecialFlags should be corrected to enable this objective.

2010-11-27 13:08:45 >> Loaded 0 Item converts . DB table `item_convert` is empty.

2010-11-27 13:08:46 Creature (Entry: 3921) has gossip_menu_id = 3033 for nonexistent menu

2010-11-27 13:08:46 Gossip menu option (MenuId: 2343 Id: 2) have action_menu_id = 11422 for nonexistent menu

2010-11-27 13:08:46 Gossip menu option (MenuId: 2343 Id: 3) have action_menu_id = 11422 for nonexistent menu

2010-11-27 13:08:46 Table gossip_menu_option for menu 5602, id 0 has `npc_option_npcflag` = 1 but creatures using this menu does not have corresponding`npcflag`. Option will not accessible in game.

2010-11-27 13:08:46 Table gossip_menu_option for menu 10662, id 0 has `npc_option_npcflag` = 1048576 but creatures using this menu does not have corresponding`npcflag`. Option will not accessible in game.

2010-11-27 13:39:01 WORLD: CMSG_ITEM_NAME_QUERY for item 46279 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 13:39:01 WORLD: CMSG_ITEM_NAME_QUERY for item 46281 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 13:39:01 WORLD: CMSG_ITEM_NAME_QUERY for item 46283 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 13:39:01 WORLD: CMSG_ITEM_NAME_QUERY for item 46284 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 13:39:01 WORLD: CMSG_ITEM_NAME_QUERY for item 46286 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 14:05:31 Table `game_graveyard_zone` incomplete: Zone 3455 Team 67 does not have a linked graveyard.

2010-11-27 14:06:45 Summoned pet (Entry: 32751) not have pet stats data in DB

2010-11-27 14:14:40 Summoned pet (Entry: 32751) not have pet stats data in DB

2010-11-27 14:34:06 Creature 104806 (Entry: 33996) have UNIT_NPC_FLAG_TRAINER but have empty trainer spell list.

2010-11-27 14:37:07 WORLD: CMSG_ITEM_NAME_QUERY for item 48769 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 14:37:07 WORLD: CMSG_ITEM_NAME_QUERY for item 48770 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 14:37:07 WORLD: CMSG_ITEM_NAME_QUERY for item 48771 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 14:37:07 WORLD: CMSG_ITEM_NAME_QUERY for item 48772 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 14:37:07 WORLD: CMSG_ITEM_NAME_QUERY for item 48773 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 14:37:07 WORLD: CMSG_ITEM_NAME_QUERY for item 51696 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 14:37:07 WORLD: CMSG_ITEM_NAME_QUERY for item 51695 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 14:37:07 WORLD: CMSG_ITEM_NAME_QUERY for item 51694 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 14:37:07 WORLD: CMSG_ITEM_NAME_QUERY for item 51693 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 14:37:07 WORLD: CMSG_ITEM_NAME_QUERY for item 51692 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 14:50:29 Summoned pet (Entry: 32751) not have pet stats data in DB

2010-11-27 15:10:05 WORLD: CMSG_ITEM_NAME_QUERY for item 46279 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 15:10:05 WORLD: CMSG_ITEM_NAME_QUERY for item 46281 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 15:10:05 WORLD: CMSG_ITEM_NAME_QUERY for item 46283 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 15:10:05 WORLD: CMSG_ITEM_NAME_QUERY for item 46284 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 15:10:05 WORLD: CMSG_ITEM_NAME_QUERY for item 46286 failed (item listed in Item.dbc but not exist in DB)

2010-11-27 15:34:44 Summoned pet (Entry: 32751) not have pet stats data in DB

2010-11-27 15:50:13 Spell (ID: 49210) has effect EffectImplicitTargetA/EffectImplicitTargetB = TARGET_SCRIPT or TARGET_SCRIPT_COORDINATES, but does not have record in `spell_script_target`

2010-11-27 16:47:53 Table `game_graveyard_zone` incomplete: Zone 3455 Team 67 does not have a linked graveyard.

2010-11-27 17:54:31 Summoned pet (Entry: 32751) not have pet stats data in DB

raven7931 · November 28, 2010

i'm starting from Squear 1... using the install guide again hopefully get every thing on the same page..

BTW this is why i am using 32 bit not 64 ... wile compileing .. using

Microsoft Visual C++ 2010 Express

with the mangosdvc100.sln

C:\\Mangos\\win\\VC100\\game.vcxproj : warning : Platform 'x64' referenced in the project file 'game' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

C:\\Mangos\\win\\VC100\\shared.vcxproj : warning : Platform 'x64' referenced in the project file 'shared' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

C:\\Mangos\\win\\VC100\\mangosd.vcxproj : warning : Platform 'x64' referenced in the project file 'mangosd' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

C:\\Mangos\\win\\VC100\\zlib.vcxproj : warning : Platform 'x64' referenced in the project file 'zlib' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

C:\\Mangos\\win\\VC100\\framework.vcxproj : warning : Platform 'x64' referenced in the project file 'framework' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

C:\\Mangos\\win\\VC100\\realmd.vcxproj : warning : Platform 'x64' referenced in the project file 'realmd' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

C:\\Mangos\\win\\VC100\\script.vcxproj : warning : Platform 'x64' referenced in the project file 'script' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

C:\\Mangos\\win\\VC100\\g3dlite.vcxproj : warning : Platform 'x64' referenced in the project file 'g3dlite' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

C:\\Mangos\\win\\VC100\\genrevision.vcxproj : warning : Platform 'x64' referenced in the project file 'genrevision' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

C:\\Mangos\\win\\VC100\\ACE_vc10.vcxproj : warning : Platform 'x64' referenced in the project file 'ACE_Wrappers' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

C:\\Mangos\\win\\VC100\\tbbmalloc.vcxproj : warning : Platform 'x64' referenced in the project file 'tbbmalloc' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

C:\\Mangos\\win\\VC100\\tbb.vcxproj : warning : Platform 'x64' referenced in the project file 'tbb' cannot be found. Please make sure you have it installed under '%VCTargetsPath%\\Platforms\\x64'.

raven7931 · November 28, 2010

FRELL wtf.... i backed up my characteds as an sql dump then tryed "reinstalling the sqls ..now all the toons are gone ... OMG my friends are going to be ticked cause their toons (characters ) all gone and the back up won't restore the characters wtf did i do wrong

raven7931 · November 28, 2010

wtf ok still getting stuff like

Error Code : 1054

Unknown column 'required_10051_01_characters_character_aura' in 'character_db_version'

so i keep going to the earler versions to "update" but really am i updateing if theirs NOTHING THERE IN THE FIRST PLACE?

i thought the origonal file i "installed" was supposed to bring me to a semi updated version ? what am i doing wrong ?

Auntie Mangos · November 28, 2010

so i keep going to the earler versions to "update" but really am i updateing if theirs NOTHING THERE IN THE FIRST PLACE?

DO NOT JUST EXECUTE the updates. Check your character database, and have a look at the character_db_version table. Executing

DESCRIBE yourcharacterdb.character_db_version;

should show your the required_... columns current name.

Search the update folder for the SQL files (there should be two) containing that column name.

Use the 2nd file that starts from your column name, not the 1st one that creates the column.

And then go slow, step by step.

It sounds like you are actually mixing different database version from mangos, UDB, and scriptdev2, plus another version on your characters db.

Do it database by database, each will need to updated on its own. If you use the last UDB release, you will have to execute a few update scripts.

In common, you should never be in a hurry when updating mangos and especially not when updating, or backing up your databases.

As for world, scripts, and realm database: these are easy to restore and update, and you can't loose any of your data.

As for character database: always mysqldump before making changes, and not after failed changes.

If you only have a broken character database, here is a suggestion: create a blank character database, and upgrade it to the recent version.

Create mysqldump files for the blank database and your backup with only the CREATE TABLE statements, and diff them. You should be able to spot the difference and fix it.

raven7931 · November 28, 2010

Ty for the advice MDP... will try to ... make temp DB's and compair

raven7931 · November 28, 2010

sigh i guess the ah bot version dosent go all the way to current versions.. so going to start over yet again delet every thing and start over

davemm · November 28, 2010

I think your issue with the x64 compiling could be due to you using the Express edition of Visual Studio, as it never supported x64 in the past, so i assume it is the same now. I'm not 100% sure as I run on Linux.

Auntie Mangos · November 28, 2010

But the good news is: if you want Windows x64 builds without buying Visual Studio Pro, there is hope.

The Windows SDK for Windows 7 includes free x64 compilers, they only lack optimization features found in the Visual Studio Pro versions. See the discussion on MSDN.

raven7931 · November 28, 2010

thats kinda kewl but i'll stick with the 32 bit seems more "stable" from what i've read

raven7931 · November 29, 2010

OO why can't i delet DB information_schema ( redoing DB from start also )

raven7931 · November 29, 2010

OK so right off the bat

PART 14 - ADDING DATABASES

• In the top left-hand side, right-click "root@(IP here)"

• Click "Create Database" and create the following database:

a) realmd

b) mangos

c) characters

• Select mangos database on the left (any database could do for now)

• Open with notepad

C:\\Mangos\\src\\bindings\\ScriptDev2\\sql\\scriptdev2_create_database.sql

• Empty the "query" textbox to the right of SQLyog and paste the contents of the .sql file

• Select all the text in the textbox (Ctrl-A), then press the play button (F9) in the toolbar at the top of SQLyog

Query : GRANT ALL PRIVILEGES ON `scriptdev2` . * TO 'mangos'@'localhost' WITH GRANT OPTION

Error Code : 1146

Table 'mysql.user' doesn't exist

Auntie Mangos · November 29, 2010

thats kinda kewl but i'll stick with the 32 bit seems more "stable" from what i've read

Well, that is a thing of the past. I am running only 64bit instances of mangos since a year now, and haven't had any stability issues. Consider that an ancient rumor, and use 64bit if you want.

OO why can't i delet DB information_schema ( redoing DB from start also )

You should not delete this. This is sort of MySQL's global brain and memory. Redoing databases should only touch the realm, world, scripts, and character databases. Not anything else, and especially not information_schema table.

Auntie Mangos · November 29, 2010

Query : GRANT ALL PRIVILEGES ON `scriptdev2` . * TO 'mangos'@'localhost' WITH GRANT OPTION

Error Code : 1146

Table 'mysql.user' doesn't exist

Well, in your effort to reset MySQL you apparently have dumped the MySQL database itself, which means you just killed MySQL and have to reinstall MySQL.

Never touch the databases mysql and information_schema. These are the heart of any MySQL installation and killing them kills your installation.

raven7931 · November 29, 2010

LOL really LMFAO ok so reinstalling mysql it is when i have time lol TY ALL .. for your very kind offerings of whisdome and advice and pardon my ignorance please this is all new to me

Auntie Mangos · November 29, 2010

The one thing you should have learned is: a little patience goes a long way.

Since you are new to all this, take your time, read and ask before you actually do stuff.

When it comes to getting mangos, UDB, and scriptdev2 databases sorted out, it is always best to first start with UDB and scriptdev2 data, since their releases are usually a few revisions below the database in mangos itself.

From there on, it is step by step upgrades. The README file in mangos/sql/updates has a tiny but helpful ASCII art describing how to read the filenames, and how to use this.

In common, installing and configuring mangos on Windows is a bit harder than on Linux. E.g. I find it much more pleasant to have a Linux server with Debian or Ubuntu server running a 64-bit version of mangos, which I then access via SSH from my notebook.

The final hint I can give here is: mysqldump should always be part of what you do. Backup every step of changes you make, and if you want to be extra safe, store your database inside a git or Mercurial repository (github/bitbucket both have free packages), and you will hardly ever run into trouble because there is a safe rollback available.

Auntie Mangos · December 8, 2010

And we are still here. Good luck, and I am curious to see how your journey towards a working installation continues.

raven7931 · December 8, 2010

Ok clone mangos step 5 and clone sd2 step 6 finished and no errors ..

Step 7 is skipped due to the use of Microsoft Visual C++ 2010 Express and those options being pre regulated ( I think )

Will be back later to continue time to do homework with the children

raven7931 · December 9, 2010

Part 8 Compiling

Mangos

========== Build: 12 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

SD2

========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

Part 9 Installing

No problems here

Part 10 verifying version

Version 0.17

* Under discussion.

* ACE Framework updated to ACE 5.8.2.

* MySQL client libs updated to MySQL 5.1.49.

* Upgrade to client version 3.3.5a (build 12340).

• Download newest UDB database and the latest UDB update packs

https://unifieddb.svn.sourceforge.net/svnroot/unifieddb/trunk/Full_DB/ForCleanInstallOnly/

unifieddb - Revision 394: /trunk/Full_DB/ForCleanInstallOnly

Characters.sql

Create database sd2.sql

Create mysql.sql

Realmd.sql

UDB_0.12.1.393_mangos_10545_SD2_1833.zip

• Update your World of Warcraft client to the supported version

3.3.5a (3.3.5 – 12340)

PART 11 - EXTRACTING FILES FROM YOUR CLIENT

Ok I have these files sourced so I'll copy the MAPS and the DBC then run the assembler

Easy as pie

PART 12 - INSTALLING AND CONFIGURING MYSQL

Already done no problems

PART 13 - SETTING UP THE SQL CONNECTION

Again np hear

More to come ......

Sign In

I feeel SO noob -DB issues-

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Recently Browsing 0 members

Contact Us

Repositories

Important Information