PDA

View Full Version : all zones unavailable...


Kintar0
11-08-2004, 01:39 PM
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):

Error 1054: Unknown column unknown008

I've tried (as many other post's suggset):

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:

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