EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   all zones unavailable... (https://www.eqemulator.org/forums/showthread.php?t=16892)

Kintar0 11-08-2004 01:39 PM

all zones unavailable...
 
So I got most things working. I can log onto my server and create a char, but when I log in, it says zone unavailable. From what I gather while searching and reading, the prob may be (from world.exe):

Quote:

Error 1054: Unknown column unknown008
I've tried (as many other post's suggset):

Code:

ALTER TABLE item CHANGE `unknown008` `SpellCharges` INT(11) DEFAULT "0" NOT NULL;
But all I get is, Error 1054: Unknown column `unknown008` in `items`

The code above seems to fix it for everyone but I just get more errors. I'm using the PEQ Kunark Release package if that helps any. Can anyone shed some light on this? Thanks.

Kintar0 11-10-2004 12:27 AM

anyone?

Darkened 11-10-2004 03:31 AM

the unavailable zone error is just because sometimes the zone server can't keep up and u have to try again.

all you have to do , is keep trying to enter the world after it tells u the zone is unavailable and it'll work.

Kintar0 11-10-2004 07:50 AM

Ok so does the unknown008 effect my gameplay? I did try a few times on multiple zones and couldn't get in. I hope that's the case.

Darkened 11-10-2004 01:25 PM

you have to make the change from unknown008 to SpellCharges yeah , your just entering the query incorrectly as far as i can tell.

Kintar0 11-11-2004 02:35 PM

as i said in my original post, i TRIED that. i get the error, Error 1054: Unknown column `unknown008` in `items`

I get that when I try to change it to spellcharges. Now what?

Echoes 11-11-2004 03:20 PM

dont mean to change topic, i had the zones not available problem too.
and yes it was my zone.exe lagging behind. but when i try to log onto my server, i always go ld, everything loads perfectly though.

Sarepean 11-11-2004 03:56 PM

Okay, two things--- if you go LD on zone into the game, it's possible that you have a database problem.

Now, for the guy above, omit all single quotes. So your SQL query should look something like:

Quote:

ALTER TABLE item CHANGE unknown008 SpellCharges INT(11) DEFAULT "0" NOT NULL;
I know it may not seem like a lot, but that's how I have had to input every query to get it to work.

If that doesn't help, redownload the Kunark Database (Full version, not to add to pre-existing) and source an entirely new database.

-Sarepean

ubatch 09-08-2005 09:17 AM

im getting the error 1054 as well, unknown column...Im trying to use the Velious DB though, is everything alright with that? 6.0 server too...Let me know if im doing anything wrong...Any help would be appreciated :)


All times are GMT -4. The time now is 05:44 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.