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!)
