Thanx man, but I got a question also, like noob question, where do I get the 8820 DBC? or is it ur mangos in the file?
Thanx man, but I got a question also, like noob question, where do I get the 8820 DBC? or is it ur mangos in the file?
You extract it with ad.exe
Cmon is there anyone that could help me with my problem PLEASE?!?! See page 5.
question:
i can't create DK , but i've already set the expansion 2 of the acc. it said: Creation of that race requires an account that has been upgraded to the appropriate expansion" what can i do?
Last edited by hksl12991; 08-31-2008 at 04:03 AM.
hi again.
new problem.. i got the whole database imported.. but when i want to use my old characters they dont show up when i log in.. (when i change realms it says i have 6 shars which is correct) but none show up in the character select window.
please help
Yes, i forgot to tell you, if you used characters from 8788 it gotta be wiped.
Since 8820 got completely changed so all chars gotta we wiped.
thats a pity
thanks anyway for an awesome release moffman.
1 other question.. when loading the mangosd.exe i get alot of spell errors. as posted below
SQL: SELECT entry,content_loc1,content_loc2,content_loc3,content_loc4,content_lo
c5,content_loc6,content_loc7,content_loc8 FROM mangos_string WHERE NOT(content_l
oc1 IS NULL AND content_loc2 IS NULL AND content_loc3 IS NULL AND content_loc4 I
S NULL AND content_loc5 IS NULL AND content_loc6 IS NULL AND content_loc7 IS NUL
L AND content_loc8 IS NULL)
query ERROR: Unknown column 'content_loc8' in 'field list'
==================================================== 100%
>> Loaded 0 MaNGOS locale strings. DB table `mangos_string` contains no localiza
tion.
SQL: SELECT entry,name_loc1,subname_loc1,name_loc2,subname_loc2,name_loc3,subnam
e_loc3,name_loc4,subname_loc4,name_loc5,subname_loc5,name_loc6,subname_loc6,name
_loc7,subname_loc7,name_loc8,subname_loc8 FROM locales_creature
query ERROR: Unknown column 'name_loc8' in 'field list'
==================================================== 100%
>> Loaded 0 creature locale strings. DB table `locales_creature` is empty.
SQL: SELECT entry,name_loc1,name_loc2,name_loc3,name_loc4,name_loc5,name_loc6,na
me_loc7,name_loc8,castbarcaption_loc1,castbarcaption_loc2,castbarcaption_loc3,ca
stbarcaption_loc4,castbarcaption_loc5,castbarcaption_loc6,castbarcaption_loc7,ca
stbarcaption_loc8 FROM locales_gameobject
query ERROR: Unknown column 'name_loc8' in 'field list'
==================================================== 100%
>> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.
SQL: SELECT entry,name_loc1,description_loc1,name_loc2,description_loc2,name_loc
3,description_loc3,name_loc4,description_loc4,name_loc5,description_loc5,name_lo
c6,description_loc6,name_loc7,description_loc7,name_loc8,description_loc8 FROM l
ocales_item
query ERROR: Unknown column 'name_loc8' in 'field list'
==================================================== 100%
>> Loaded 0 Item locale strings. DB table `locales_item` is empty.
SQL: SELECT entry,Title_loc1,Details_loc1,Objectives_loc1,OfferRewardText_loc1,R
equestItemsText_loc1,EndText_loc1,ObjectiveText1_loc1,ObjectiveText2_loc1,Object
iveText3_loc1,ObjectiveText4_loc1,Title_loc2,Details_loc2,Objectives_loc2,OfferR
ewardText_loc2,RequestItemsText_loc2,EndText_loc2,ObjectiveText1_loc2,ObjectiveT
ext2_loc2,ObjectiveText3_loc2,ObjectiveText4_loc2,Title_loc3,Details_loc3,Object
ives_loc3,OfferRewardText_loc3,RequestItemsText_loc3,EndText_loc3,ObjectiveText1
_loc3,ObjectiveText2_loc3,ObjectiveText3_loc3,ObjectiveText4_loc3,Title_loc4,Det
ails_loc4,Objectives_loc4,OfferRewardText_loc4,RequestItemsText_loc4,EndText_loc
4,ObjectiveText1_loc4,ObjectiveText2_loc4,ObjectiveText3_loc4,ObjectiveText4_loc
4,Title_loc5,Details_loc5,Objectives_loc5,OfferRewardText_loc5,RequestItemsText_
loc5,EndText_loc5,ObjectiveText1_loc5,ObjectiveText2_loc5,ObjectiveText3_loc5,Ob
jectiveText4_loc5,Title_loc6,Details_loc6,Objectives_loc6,OfferRewardText_loc6,R
equestItemsText_loc6,EndText_loc6,Object
query ERROR: Unknown column 'Title_loc8' in 'field list'
==================================================== 100%
>> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.
SQL: SELECT entry,Text0_0_loc1,Text0_1_loc1,Text1_0_loc1,Text1_1_loc1,Text2_0_lo
c1,Text2_1_loc1,Text3_0_loc1,Text3_1_loc1,Text4_0_loc1,Text4_1_loc1,Text5_0_loc1
,Text5_1_loc1,Text6_0_loc1,Text6_1_loc1,Text7_0_loc1,Text7_1_loc1,Text0_0_loc2,T
ext0_1_loc2,Text1_0_loc2,Text1_1_loc2,Text2_0_loc2,Text2_1_loc2,Text3_0_loc2,Tex
t3_1_loc1,Text4_0_loc2,Text4_1_loc2,Text5_0_loc2,Text5_1_loc2,Text6_0_loc2,Text6
_1_loc2,Text7_0_loc2,Text7_1_loc2,Text0_0_loc3,Text0_1_loc3,Text1_0_loc3,Text1_1
_loc3,Text2_0_loc3,Text2_1_loc3,Text3_0_loc3,Text3_1_loc1,Text4_0_loc3,Text4_1_l
oc3,Text5_0_loc3,Text5_1_loc3,Text6_0_loc3,Text6_1_loc3,Text7_0_loc3,Text7_1_loc
3,Text0_0_loc4,Text0_1_loc4,Text1_0_loc4,Text1_1_loc4,Text2_0_loc4,Text2_1_loc4,
Text3_0_loc4,Text3_1_loc1,Text4_0_loc4,Text4_1_loc4,Text5_0_loc4,Text5_1_loc4,Te
xt6_0_loc4,Text6_1_loc4,Text7_0_loc4,Text7_1_loc4,Text0_0_loc5,Text0_1_loc5,Text
1_0_loc5,Text1_1_loc5,Text2_0_loc5,Text2_1_loc5,Text3_0_loc5,Text3_1_loc1,Text4_
0_loc5,Text4_1_loc5,Text5_0_loc5,Text5_1
query ERROR: Unknown column 'Text0_0_loc8' in 'field list'
==================================================== 100%
>> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty.
SQL: SELECT entry,text_loc1,text_loc2,text_loc3,text_loc4,text_loc5,text_loc6,te
xt_loc7,text_loc8 FROM locales_page_text
query ERROR: Unknown column 'text_loc8' in 'field list'
==================================================== 100%
>> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.
Loading Page Texts...
==================================================== 100%
>> Loaded 1389 page texts
Loading Game Object Templates...
==================================================== 100%
>> Loaded 13634 game object templates
Loading Spell Chain Data...
=Spell 1020 listed in `spell_chain` does not exist = 6%
=Spell 1769 listed in `spell_chain` does not exist = 8%
=Spell 5573 listed in `spell_chain` does not exist = 16%
=Spell 14272 listed in `spell_chain` does not exist= 50%
Spell 14273 listed in `spell_chain` does not exist
Spell 14274 listed in `spell_chain` does not exist
=Spell 15629 listed in `spell_chain` does not exist= 52%
Spell 15630 listed in `spell_chain` does not exist
Spell 15631 listed in `spell_chain` does not exist
Spell 15632 listed in `spell_chain` does not exist
=Spell 19478 listed in `spell_chain` does not exist= 60%
Spell 19655 listed in `spell_chain` does not exist
Spell 19656 listed in `spell_chain` does not exist
Spell 19660 listed in `spell_chain` does not exist
=Spell 23109 listed in `spell_chain` does not exist= 66%
Spell 23110 listed in `spell_chain` does not exist
Spell 23147 listed in `spell_chain` does not exist
Spell 23148 listed in `spell_chain` does not exist
=Spell 24597 listed in `spell_chain` does not exist= 68%
Spell 24603 listed in `spell_chain` does not exist
Spell 24605 listed in `spell_chain` does not exist
=Spell 26177 listed in `spell_chain` does not exist= 74%
Spell 26178 listed in `spell_chain` does not exist
Spell 26179 listed in `spell_chain` does not exist
Spell 26201 listed in `spell_chain` does not exist
=Spell 27015 listed in `spell_chain` does not exist= 78%
Spell 27020 listed in `spell_chain` does not exist
=Spell 27280 listed in `spell_chain` does not exist= 84%
Spell 27685 listed in `spell_chain` does not exist
=Spell 30030 listed in `spell_chain` does not exist= 86%
Spell 30033 listed in `spell_chain` does not exist
=Spell 35296 listed in `spell_chain` does not exist= 92%
Spell 35297 listed in `spell_chain` does not exist
Spell 35298 listed in `spell_chain` does not exist
Spell 38768 listed in `spell_chain` does not exist
Spell 45843 listed in `spell_chain` does not exist
=Spell 47500 listed in `spell_chain` does not exist= 94%
=Spell 49910 listed in `spell_chain` does not exist= 96%
Spell 49911 listed in `spell_chain` does not exist
Spell 49912 listed in `spell_chain` does not exist
=Spell 49932 listed in `spell_chain` does not exist= 98%
Spell 49933 listed in `spell_chain` does not exist
==================================================== 100%
>> Loaded 1896 spell chain records
Loading Spell Elixir types...
==================================================== 100%
>> Loaded 98 spell elixir definitions
Loading Spell Learn Skills...
>> Loaded 97 Spell Learn Skills from DBC
Loading Spell Learn Spells...
==================================================== 100%
>> Loaded 14 spell learn spells + 698 found in DBC
Loading Spell Proc Event conditions...
=Spell 12359 listed in `spell_proc_event` does not exist
Spell 12360 listed in `spell_proc_event` does not exist
=Spell 19478 listed in `spell_proc_event` does not exist
Spell 19655 listed in `spell_proc_event` does not exist
Spell 19656 listed in `spell_proc_event` does not exist
Spell 19660 listed in `spell_proc_event` does not exist
=Spell 24597 listed in `spell_proc_event` does not exist
Spell 24603 listed in `spell_proc_event` does not exist
Spell 24605 listed in `spell_proc_event` does not exist
=Spell 26021 listed in `spell_proc_event` does not exist
=Spell 27280 listed in `spell_proc_event` does not exist
=Spell 28594 listed in `spell_proc_event` does not exist
Spell 28595 listed in `spell_proc_event` does not exist
=Spell 29445 listed in `spell_proc_event` does not exist
Spell 29446 listed in `spell_proc_event` does not exist
=Spell 30030 listed in `spell_proc_event` does not exist
Spell 30033 listed in `spell_proc_event` does not exist
==================================================== 100%
jimei
in your mangos folder where u have mangosd.conf
edit it and where it has
LoginDatabaseInfo = "127.0.0.1;3306;root;root;mangos"
WorldDatabaseInfo = "127.0.0.1;3306;root;root;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;root;mangos"
change the 'mangos' to the name you created and imported the database to.
i think that is your problem.
yeah, im having the same problems. Also, the database is a compilation of more than one?
i know it says world, realmd, character in the database_world+realmd+character.sql filename, so which do execute this onto? I did it on my characters database for now and its taking forever.
and what do i need to edit in these config files?
Everything worked but now when i log in it loads and stays connected... 4 evah.
Any ideas why it stays on connected all the time? Helpthis is probly kickass and i wanted to see DK T4
jimei what did you use to execute the sql in your database?
yeh look at my thread sumwhere, BTW how can i get navicat 8 to go faster i cant find navicat 5 sumone gimme a link