No game server appears in list...
Excellent package overall. Easy to follow instructions. I am having a brain dump today though... My version of the Game Client is 3.3.0a and everything seems to have loaded perfectly fine. When I log into the game... it takes me to the first menu to ask which realm I want to play in (check 'Development' and check any of the others (RP, PVP, etc.)) but it does not bring up any realm or option to continue? What gives?
btw... +rep for the work you did
EDIT:
Thanks,.. I found the error. It was a combination of the optional.conf file being in error and.. my lack of patience in waiting for the world.conf to completely load before trying to logon. Overall... this is a very easy to install repack and very ggod for noobs. Once you have completed all of the instructions, you WILL have to go and modify the optional.conf file (which can be found in the configs folder). Just cut and paste the correction that Catpride provided (above) and save the file...OHhh.. you may want to save the original as 'optional.bkp' just so that you can have the comments to refer to on occassion.
Solution for "unbound auction house npc" ... Sql query failed
CRITICAL ERROR - Sql query failed due to [Unknown column 'ahgroup' in field list 1]...
Everyone seems to have brushed off this error... you can even read where it occurs when arcemu-world starts up (and gets past the long delay of reading spells). In fact, what this error means is that the Database manager for the Auction House can not read the list of auction houses (NPC Auctioneers) in the auctionhouse table in your 'world' folder. It fails to read the last column because (I think) the column is named "group" and the Database Manger is trying to run a mySQL query that is searching for "ahgroup"... and it fails. The end result... the AH just doesnt work in game - and that is a critical problem.
I am trying to trace the query to find out whether or not I can just rename the column.. or is it the query that has to change... Can anyone more talented then me help please.. and post a work-around solution! Thanks
SOLUTION....
Well,... call it a 'band-aid' for now... If you have a database editor...I recommend Navicat... just open up the auctionhouse table in the world folder and edit the table. Two things you should do...
1) create a new field/column called 'ahgroup' and put all the exact same values as the 'group' field has in it for each row;
2) save the new table
This should work... let me know.
Argordon
(Goodness... the most painful part of this process is waiting for those 49200 spells to compile each time I run arcemu-world.. if I ever create my own game from scratch - three spells only! HURT, HEAL, MOVE... sheesh!)