Need help...

[gater1234]

Using database 'eq' at localhost
When I try to load boot5zones.Win9x it gives me an error saying:

Loading items & NPCs...DB Query Error
Error #1054:Unknown column 'banish' in 'field list'
Error in LoadNPCTypes query 'SELECT id, name, level, race, class, hp, gender, texture, helmtexture, size, loottable_id, banish, mindmg, maxdmg, npcspecialattacks FROM npc_types' #1054: Unknown column 'banish' in 'field list' done.
Spells loaded from 'spdat.eff'.
Loading guild ranks...done.
Loading faction data...done.

Worldserver connect: Connecting to the server failed. Error: 10060
InitWorldServer failed
Entering sleep mode

what can I do to fix this?

[agent73]

I had this problem before when trying to use minilogin. I put all the .ini's to have 127.0.0.1 instead of the word "localhost" and it fixed my problem. I also reinstalled mysql and did the database over from scratch.

Hope this helps..

-aGeNt73

[Shawn319]

Did you get the new DB? it looks like you dont have some of the new table structure columns that are in the new 0.3.0 db.sql.

This can also be caused by world.exe not getting a good connection with the mysql DB. Make sure the mysql password is correct and if it doesnt work then, try changing host to say 127.0.0.1 (that sometimes helps people)

[gater1234]

Got it to work, thanks. Argh, but now when I try to load EQEmu Admin tool it says:

Exception: Got error 127 from table handler

The admin tool wasn't able to connect to table account
in database "eq" at host 127.0.0.1
Please go to the Preferences dialog and set the username, password, database, and host values. If they are correct, this error may signify an error in that table that the tool's database components cannont handle.

I checked and the database/host/password/username values ARE correct.. it got screwed up after I tried to change my account to server-op status.. and now I don't know what to do heh. Is there anything I can do besides redo the whole database?