[Release] Mangos WotLK Core 3.0.2.8905

[s3ph1roth]

Hi, I've got an error, it is:

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

When i try to run the item_template_update.sql it says :

[Err] 1064 - Error in the syntax on query SQL near '* ADD COLUMN `unk_flag1` mediumint(10) unsigned NOT NULL default '0' AFTER stat_' linea 2
[Msg] Finished - Unsuccessfully

I'm using Navicat. Can anybody explain this problem to me? Thanks in advance!
:wave:

[grey69]

Typo in the command, column "stat_" doesn't exist hence why it cannot execute.
"stat_value10" should be present in your table, you can check manually.
Try;

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


If you still get the error even after "Finished - successfully" it means there are more columns needed to match the core execution, simply redo the command but add a random column name like test1, data1, etc


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

Hi, I've got an error, it is:

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

When i try to run the item_template_update.sql it says :

[Err] 1064 - Error in the syntax on query SQL near '* ADD COLUMN `unk_flag1` mediumint(10) unsigned NOT NULL default '0' AFTER stat_' linea 2
[Msg] Finished - Unsuccessfully

I'm using Navicat. Can anybody explain this problem to me? Thanks in advance!
:wave:

[s3ph1roth]

I still can't get it to work... I've created "mangos" database again, I've re-executed "mangos.sql"... but it doesn't let me query that command

[predattak]

well i can't type anything in game ... server says i don't know that language.... any help plz??

[zackorion15]

Download the first link, and run per instructions, with one change being to run just 3 of the included sql's - realm, characters and scriptdev2

Download from the 5th link and extract just the FDB sql from it.

This combo works best (imo)

What is the 5th link? I only see 2-3 on the main post.

[grey69]

I had this too, try this out

character_spell table, import it into characters database
Filebeam - Free Fast File Hosting

If not fixed try;

Filebeam - Free Fast File Hosting

Putting files because my characters database is mixed with mangos so i can't just export the characters.

Shutdown mysql
copy all the files from language fix.rar into your characters folder example (C:\Program files\MySql\data\characters), overwriting the existing files.

I couldn't sort out the specific entry that caused the bug but i had a backup of all those files from client 8788 that worked so restoring those files to my DB, has fixed this bug. Make sure you delete your WoW cache and if it fails, delete the characters you created ingame and create a new one.

well i can't type anything in game ... server says i don't know that language.... any help plz??

[grey69]

Oh and another thing.. about the "1h weapon + shield bug".

Equipping a shield first

Then equip a 2 hander is now possible... a fix sorta

lol weird setup but you now have Titan's Grip for the poor! hehe

I think it's just the 2 handers slot id got mixed up with the 1 handers...

[Deathtrooper]

LAST PATCH IS OUT TODAY 9/30/08... expect an update to core soon!

Hopefully once the full version of the game comes out we can get some good emulation going here without so many bugs!!

[tippythop]

So is the download link gonna become available? just wondering or will you put it up tomorrow? and whats fixed in the patch hehe

[zackorion15]

LAST PATCH IS OUT TODAY 9/30/08... expect an update to core soon!

Hopefully once the full version of the game comes out we can get some good emulation going here without so many bugs!!

Yay I hope you could make an ez guide to come with.

[tippythop]

Not to be mean but he shouldnt have to include a guide lol i mean this isnt hard at all well not for me ive been hostin servers for 2 years anywaysss just go to wow apprentice or wowps they show guides this is really simple though just have ur core folder with all the server files which runs the whole operation and have a database >.>

[zackorion15]

Well the only issue I have is knowing which sql files out of the 100s his download has. I tried the normal ones I did for the other 3 betas I did but it still did not work for this one. I don't mean to say guide, just which sql files do you import to make it to work. Plus not everyone has done it as long as you have. I am no idiot, I did what all guides said and used common sense and it still gave me an error on starting the server.

For example I used the files and I get this error when starting it.
ERROR:Error in item_template table, probably sql file format was updated (there should be 142 fields in sql).

-edit-
Yay I feel good, I tried a post I saw above and it fixed the error above.

I made 2 .sql files and imported them to the mangos database and it got the server up! (It showed a LOT of errors while loading but after I loaded again those were gone, still lots of other errors, but it is beta).

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

2.)
ALTER TABLE `item_template`
ADD COLUMN `test1` mediumint(10) unsigned NOT NULL default '0' AFTER stat_value10;

[tippythop]

Ok what Id suggest to you is to start clean and the 100's of sqls YOUR talking about is UPDATES to tables and what not things to fix the server the MAIN ones that need to be executed is the mangos realmd characters and scriptdev2 when u get those executed THEN its the time to do those "100's" of sqls those will definitely help in the long run like i said those 100's of sqls ur talkin about are updates just run each and everyone of those if you get errors while executing them see if u can fix it and maybe execute it again if not LIKE ME just ignore it and go to the next one its really not hard

[defife]

The "items_update.sql" works fine.
But i have a problem with the command "setbc".
I can't get authorization for the burning crusade and the WTLK without that command.

[zackorion15]

You mean do every single one? Including the ones that say for older versions?