[Release] Mangos WotLK Core 3.0.2.8905

[grey69]

Oh well, mangos.exe error count before = approx 8000

Now = approx 200

Lol sounds like i'll have to redo client 9014

Yeah
SQL: INSERT INTO character_spell (guid,spell,slot,active,disabled) VALUES
('2', '81', '2','1','0')
SQL ERROR: Unknown column 'disabled' in 'field list'

Means the column "disabled" is missing, it's trying to put all 0 into this column but it must be created first.

ALTER TABLE `character_spell`
ADD COLUMN `disabled` tinyint(3) unsigned NOT NULL default '0' AFTER active;


Thanks Deathtrooper, for the update.

[shellac]

I still cannot get rid of the`item_template` error when launching mangosd.exe. I have tried "restore from sql" into the mangosd database and i still get there. could anyone please give me some advice as to what i am doing wrong?

thanks

[grey69]

Look my post, #243 on page 17

Anyhow, post the error code you get in mangos.exe

I still cannot get rid of the`item_template` error when launching mangosd.exe. I have tried "restore from sql" into the mangosd database and i still get there. could anyone please give me some advice as to what i am doing wrong?

thanks

[Freek2008]

ok on the new patch how can u apply it or do u have to reinstall WOTLK all together to get to 9014 because it shows 0.0.2 8992 to 0.0.2 9014 which my client is at 3.0.2 8992 and says i dont need to apply it.

[Deathtrooper]

ok on the new patch how can u apply it or do u have to reinstall WOTLK all together to get to 9014 because it shows 0.0.2 8992 to 0.0.2 9014 which my client is at 3.0.2 8992 and says i dont need to apply it.

I just downloaded the new patch from wotlkwiki and patched up from 8992 to 9014! U shouldn't have to reinstall or anything!

[grey69]

Wrong download, i don't know who's putting these files but they look like fake updates.

Make sure you download "WoW-3.0.2.8982-to-3.0.2.9014-enUS-patch.exe"

http://jerks-r.us/WotLK/WoW-3.0.2.89...enUS-patch.exe

ok on the new patch how can u apply it or do u have to reinstall WOTLK all together to get to 9014 because it shows 0.0.2 8992 to 0.0.2 9014 which my client is at 3.0.2 8992 and says i dont need to apply it.

[grey69]

Update to the bug "You cannot speak this language" missing spells etc

After more research i found the table to edit.

character_spell

Basically the faulty one has too many missing spells.

working one, execute to your characters database

Filebeam - Free Fast File Hosting

[zackorion15]

Are you saying you can create the character but when you go to play it the character does not show up?

[Deathtrooper]

Wrong download, i don't know who's putting these files but they look like fake updates.

Make sure you download "WoW-3.0.2.8982-to-3.0.2.9014-enUS-patch.exe"

http://jerks-r.us/WotLK/WoW-3.0.2.89...enUS-patch.exe

LMAO... i downloaded it when it was first put up on wotlkwiki and this is what the name was patchover9000.exe.....kinda made me think twice about it but once i scanned it, i just executed it and it worked just fine!

[grey69]

Yeah but i was referring to those files to previous poster had downloaded WoW-0.0.2.8982-to-0.0.2.9014-enUS-patch.exe

I had got the same with patch 8982, the file was the right size but it was WoW-0.0.2
Wouldn't patch even renaming the file to WoW-3.0.2

[zackorion15]

Ok, I got the items_template error and fixed it with (Telling it to continue on errors):

ALTER TABLE `item_template`
ADD COLUMN `unk_flag1` mediumint(10) unsigned NOT NULL default '0' AFTER stat_value10;
ALTER TABLE `item_template`
ADD COLUMN `unk_flag2` mediumint(10) unsigned NOT NULL default '0' AFTER unk_flag1;

Then I got this error :

2008-10-01 21:30:46 Loading Vehicles...
2008-10-01 21:30:46 ERROR:SQL: SELECT MAX(entry) FROM creature_Vehicles
2008-10-01 21:30:46 ERROR:query ERROR: Table 'mangos.creature_vehicles' doesn't exist
2008-10-01 21:30:46 ERROR:Error loading creature_Vehicles table (not exist?)

I fixed that with importing "creature_vehicles.sql" from in the "Updates" folder. Then I figured I would import all files from Updates folder and done just that.

Now when I tried to create a character it did not show up on character list and I saw this error in the server :

2008-10-01 22:05:46 ERROR:SQL: INSERT INTO character_spell (guid,spell,slot,active,disabled) VALUES ('2', '81', '1','1','0')
2008-10-01 22:05:46 ERROR:SQL ERROR: Unknown column 'disabled' in 'field list'

I fixed that with importing "characters.sql" from page 18 Download Link Here

Then I run mangosd.exe and realmd.exe (don't matter what order, just be sure you do them one then the other right away). After it is done preparing you will hear a beep. Once you hear the beep type in the following to make sure you have a user to log in with and be able to use bloodelf and deathknight.

create username password
setgm username 3
setexpansion username 2

Repeat with every user. This will make the account, make the account a gm, and set their expansion to WotLK so they can play with Death Knight.

I hope I am of use.

[Freek2008]

Has any1 had any luck with addons like mangeadmin I cant get working at all it shows up blank box.

[Anthonyrox8]

yo bro getting errors when zoning movement.cpp error

EDit : the error is
ERROR #0 (0x85100000) Assertion Failure
Program: C:\Program Files\Wrath of the Lich King Beta\WoW.exe
File: .\Movement.cpp
Line: 2788
Expr: CMath::fnotequal_(init.runSpeed,0)

[shellac]

ok i think i got it now and understand that I need to import a database.

could anyone please help me to understand how to import frozen's database? I thought I knew how to do it and every guide I have says to just execute it into the mangos db but when I do that I get an error right away and it doesn't import anything.

any advice please?

thanks

[gabee1987]

i get this error when i try to run mangos.exe:

2008-10-02 14:58:55 Class 6 Level 1 does not have health/mana data!

Anyone know how should i fix it?

I tried that characters.sql update but didnt worked...