Problems with zoning and No NPC's

[mannyfresh]

I just got server up today and I want to get a few things fixed.

I seem to be missing some things in my DB.
I am using Eqemu 0.6.4-dr1 on Win xp

When I try to zone It starts to load then returns me to the previous area and tries to load again. Over and over and over.

Also I have no NPC's. These things are apparent to me in the following which came from Zone.exe but how to fix them is what I'm having trouble with. I found a good bit of similar things in the forums but I haven't seen anything that seems to apply to my situation.

BTW I am using peq-velious-rc1.zip as my DB. I am logging in through Minilogin6.2 with everything on one machine.

ZONE.EXE

[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
[Status] Loading spawn2 points...
[Status] Loading player corpses...
[Status] Loading traps...
[Status] Loading ground spawns...
[Status] Loading Ground Spawns from DB...
[Status] Loading World Objects from DB...
[Status] Loading Objects from DB...
[Status] Loading doors for felwithea ...
[Status] Loading Doors from database...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Successfully loaded Zone Config.
[Status] Loading timezone data...
[Status] Init Finished: ZoneID = 61, Time Offset = 0
[Status] Zone Bootup: felwithea (61)
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.ST
R' in 'field list'
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.ST
R' in 'field list'
[Status] 1337719 New client from ip:127.0.0.1 port:3981
[Error] MySQL Error while trying to load zone flags for Bobby: #1146: Table 'eq.
zone_flags' doesn't exist
[Status] WARNING: Closest zone point for zone id 62 is 649394.500000, you might
need to update your zone_points table if you dont arrive at the right spot.
Error in GetSafePoint query 'SELECT safe_x, safe_y, safe_z, min_status, min_leve
l, flag_needed FROM zone WHERE short_name='felwitheb'' #1054: Unknown column 'fl
ag_needed' in 'field list'
If it errors, run the following querys:
ALTER TABLE `zone` CHANGE `minium_level` `min_level` TINYINT(3) UNSIGNED DEFAUL
T "0" NOT NULL;
ALTER TABLE `zone` CHANGE `minium_status` `min_status` TINYINT(3) UNSIGNED DEFA
ULT "0" NOT NULL;
ALTER TABLE `zone` ADD flag_needed VARCHAR(12 NOT NULL DEFAULT '';
[Error] Zoning Bobby: Unable to get safe coordinates for zone 'felwitheb'.
Dropping client: Process=false, ip=127.0.0.1, port=3981
[Status] 1373844 New client from ip:127.0.0.1 port:3986
[Error] MySQL Error while trying to load zone flags for Bobby: #1146: Table 'eq.
zone_flags' doesn't exist

[fathernitwit]

always read the changelog.txt file when you get new code.

[jimbabwe]

yeah, the 6.4 stuff is in developement so the velious db won't fit perfectly. So you'll have to do what he said to make it work. check out the 6.4 tutorial here
http://www.eqemulator.net/wiki/wikka...indowsServer64 and you can get a sql file that will fix your db up for 6.4-dr1-594

[mannyfresh]

Thanks guys this is the first time I have used eqemu. I was wondering if the pop and sol stuff is missing or if I am doing some thing wrong. I have no pop books and using '#zone bazaar' just zoned me to an empty gray area. BTW I do have the expansions.

[RangerDown]

Luclin mob spawns are still under development (at least with the PEQ database). You will only get up to Velious for now. Stay tuned for updates to that DB.

[kouhei]

Originally Posted by mannyfresh

Thanks guys this is the first time I have used eqemu. I was wondering if the pop and sol stuff is missing or if I am doing some thing wrong. I have no pop books and using '#zone bazaar' just zoned me to an empty gray area. BTW I do have the expansions.

The reason is the the bazaar file you have is the new version on the bazzar. Depending you might have on you computer the old copy of the bazaar take a look and see if you. Do a search and see how many copys of bazaar files you have and check the dates. I forgot the extionsons. If you do a search you might see the thread still here. But anyways all you have to do is del the new file and it will auto back to the old file. Also check lavastorm. That zone was also updated too but check that zone to see if you have changes too. Hope that helps.

[mannyfresh]

You were correct I checked the in game map then used the x,y,z, locations to actually get to the map. It is the new bazaar. Not important though. There isn't any NPC's there and also the scions and Pok books are non-existant. I have found using magelo to be a great tool for finding item id's. I'm sure you have all thought of this or used it but incase you hadn't there you are.

[wraithlord98]

Just would like to point out a common mistake - when you get locs in EQ Live - the locs you get are actually given in Y, X, Z format.. so when you enter it into the Emu dbase - you need to be sure you're entering the correct data into the correct fields.

[Doodman]

Originally Posted by mannyfresh

You were correct I checked the in game map then used the x,y,z, locations to actually get to the map. It is the new bazaar. Not important though. There isn't any NPC's there and also the scions and Pok books are non-existant. I have found using magelo to be a great tool for finding item id's. I'm sure you have all thought of this or used it but incase you hadn't there you are.

For looking up items, I recommend http://eqitems.13th-floor.org it's a lucy-like clone on steroids from one of the guys in #showeq. They are in-game collected items, not user submitted so they should be *VERY* accurate.