[Release] Mangos WotLK Core 3.0.2.8905

[Radzael]

I still have a problem with player_classlevelstats.sql file. I've executed the fix, but i have this new message now : Race 1 class 6 level 1 does not have stats data!
What should i do? Thanks in advance !

[shellac]

I'm sorry to ask such a horrible noob question...but what version number of the beta should I be using to make a server using this current core?

[predattak]

i'm sorry to ask such a horrible noob question...but what version number of the beta should i be using to make a server using this current core?

3.0.2 8982

[grey69]

Tip for updating database with several .sql files, using navicat you can only apply a file at a time

1 - put all the .sql files into the same folder applying for their filename (characters updates, mangos updates) so files like 5651_characters_characters.sql is into "characters updates".

2 - create inside these folders a textfile batch.txt

3 - enter this text inside the file and save it as batch.bat

type *.sql >> fixes.txt
rename fixes.txt fixes.sql

4 - double-click batch.bat in the 2 folders, it will create a "fixes.sql" file in each of them

5 - execute all the fixes.sql in their right databases with navicat etc select "continue on errors" because it will find duplicates etc.


Saved me lot of clicks

[zackorion15]

Well if we should import every sql maybe someone with time can use grey's method and gather all the Characters, RealmD, and Mangos sql's then make them in to 3 sql's characters.sql, realmd.sql, and mangos.sql then upload them

That could help a lot of people and get rep easy.

[smidigt]

I still have a problem with player_classlevelstats.sql file. I've executed the fix, but i have this new message now : Race 1 class 6 level 1 does not have stats data!
What should i do? Thanks in advance !

I have the same error, any ideas?

EDIT
Nvm, i removed all my current databases and started all over, now it works with the fixes i applied...

[Deathtrooper]

1st post updated 10/01/08

3.0.2.9014 Repack!!

Some simple instructions this time around!!

I ask that u remember one thing when running this.... IT'S STILL BETA! So some errors are to be expected!!

Enjoy!!

[Nanos]

1st post updated 10/01/08

3.0.2.9014 Repack!!

Some simple instructions this time around!!

I ask that u remember one thing when running this.... IT'S STILL BETA! So some errors are to be expected!!

Enjoy!!

Awesome, much appreciated! One day after client patch is pretty quick!

Also noted the additional attention to documentation

One quick question, for those of us upgrading from a previous release. Do we just need the core binaries to upgrade or are there also updates/changes in the .config files and DB that we should also be aware of?

Thanks,

[Deathtrooper]

Awesome, much appreciated! One day after client patch is pretty quick!

Also noted the additional attention to documentation

One quick question, for those of us upgrading from a previous release. Do we just need the core binaries to upgrade or are there also updates/changes in the .config files and DB that we should also be aware of?

Thanks,

I don't recommend upgrading anything... start fresh! Upgrading just causes problems.

[Nanos]

I don't recommend upgrading anything... start fresh! Upgrading just causes problems.

Okay starting fresh I get hit with the old

ERROR:Error in item_template table, probably sql file format was updated (there should be 142 fields in sql).

I know how to fix this, however the "item_update.sql" file was not included in this 9014 release and the previous releases (one of which contained the file) have been removed from the first post. Might want to include that fix somewhere in the first post in case other people don't have the file anymore.

[Deathtrooper]

Okay starting fresh I get hit with the old



I know how to fix this, however the "item_update.sql" file was not included in this 9014 release and the previous releases (one of which contained the file) have been removed from the first post. Might want to include that fix somewhere in the first post in case other people don't have the file anymore.

A link to that specific file is located in this thread somehwere... page 14 or so.. not sure let me take a look!

EDIT** Yep, page 14 post #206

.......or u can just execute this into ur DB

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;

[ananhaid]

create characters cant display,it should be the same way to fix it?

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

[zackorion15]

I love you deathtrooper. I am gonna go try this hot baby our right now!

[Deathtrooper]

create characters cant display,it should be the same way to fix it?

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

Try this updated characters.sql


characters.rar<----------no need for this anymore, repack updated to reflect the new up to date characters sql

[ananhaid]

Try this updated characters.sql


characters.rar

it works fine, thanks lol.