Server up, login fine, no doors or NPCs [error code inside]

[shanxi]

Ok, once again, I need some help hehe, more specific this time. I can log into my server and all, but there isnt any doors or npcs.

I am using the latest Kunark_upgrade DB from the peq site.

I cant find the doors_update anywhere, and I would like those just to be on the safe side. I have doors.sql but not the update.

All the posts on fixing the lack of mobs that I have read thru seem to either never get an answer, other folks post saying they have the same problem, or the post is capped with something like:

Thanks for the help but I figured it out finally

without detailing what they did.

I am getting these errors:

World.exe

[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=36965
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Breaking bards...done
TCP listening on: localhost:9000
World server listening on: localhost:9000
Connected to LoginServer: newlogin1.eqemulator.net:5994
26015 New TCP connection: 127.0.0.1:4298
New zoneserver: #1 127.0.0.1:4298
Zoneserver SetConnectInfo: 127.0.0.1:4298: localhost:7995
55828 New client from ip: 127.0.0.1 port: 4300
Logged in: FirstLogin LS#64382: shanxi
Received unknown opcode: 0x02eb size:0 bytes
Read group ID for 'Shanxi': 0
   0: 2C 30 2C 2E 53 68 61 6E - 78 69 2C 30 36 37 61 37  | ,0,.Shanxi,067a7
  16: 39 64 34 00                                        | 9d4.
Attempting autobootup of rivervale (19) for Shanxi
Zoneserver SetZone: localhost:7995 rivervale (19)
Enter world: Shanxi: rivervale (19)
Broadcasting a world time update
Zoneserver SetZone: localhost:7995 rivervale (19)
Received unknown opcode: 0x0376 size:0 bytes
Client disconnected
Removing client from ip:127.0.0.1 port:4300

Zone.exe 7995: rivervale, 1 clients

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
Error in DBLoadDoors query 'SELECT id,doorid,zone,name,pos_x,pos_y,pos_z,heading
,opentype,guild,lockpick,keyitem,triggerdoor,triggertype,dest_zone,dest_x,dest_y
,dest_z,dest_heading,door_param,invert_state,incline,size from doors' #1054: Unk
nown column 'door_param' in 'field list'
If you get an error about door_param and size, run the following queries:
ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4)  DEFAULT "0" NOT NUL
L;
ALTER TABLE `doors` ADD `size` SMALLINT(5)  UNSIGNED DEFAULT "100" NOT NULL;
Error: EMuShareMem: DLLLoadDoors: !cbDBLoadDoors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 6299
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 172 commands loaded
[Status] Entering sleep mode
Connected to worldserver: localhost:9000
Map header: 21658 faces, 217 nodes, 29875 facelists
Loaded map: 64974 vertices, 21658 faces
Map BB: (-673.72 -> 203.91, -431.81 -> 511.78, -47.97 -> 599.75)
Map ./Maps/rivervale.map loaded.
[Status] Weather should change in 7536 seconds
Error loading NPCs from database. Bad query.
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 19; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for rivervale ...
[Status] Done loading doors for rivervale ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
Error in LoadTempMerchantData query 'select ml.npcid,ml.slot,ml.itemid,ml.charge
s from merchantlist_temp ml, npc_types nt, spawnentry se, spawn2 s2 where nt.id=
ml.npcid and nt.id=se.npcid and se.spawngroupid=s2.spawngroupid and s2.zone='riv
ervale' group by ml.npcid,slot order by npcid,slot asc' #1146: Table 'eq.merchan
tlist_temp' doesn't exist
[Status] Zone Bootup: rivervale (19)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [08:04 pm]
[Status] 58141 New client from ip:127.0.0.1 port:4302
Read group ID for 'Shanxi': 0
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
/
/ about a good hundred more of these in here, deleted them for size purposes
/
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
 opcode: 0x02f5, size: 4
Unexpected packet during CLIENT_CONNECTING: OpCode: 0x02f5, size: 4
   0: 48 1F 73 00                                        | H.s.
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
 opcode: 0x0355, size: 4
Unexpected packet during CLIENT_CONNECTING: OpCode: 0x0355, size: 4
   0: 48 1F 73 00                                        | H.s.

I know others have had this problem prior to getting their servers up, I would appreciate any info leading to what you did, for as far as this is, im stumped. I dont even have a remote clue how I fix anything that goes thru the world.exe or boot5zones.exe

[Doodman]

For doors, look for door_update.sql and source it.

For merchant temp list, look for merchant_templist.sql (or something similar).

For NPCS, do:

ALTER TABLE npc_types ADD npc_aggro TINYINT NOT NULL DEFAULT '0';

Enjoy

[shanxi]

EDIT: disregard what I wrote before, I was looking in the wrong place.

EDIT2: I can zone in oldworld zones it seems, just not anything past kunark. I am going to look and make sure my expansions are enabled to 255, im pretty sure they were.

Should I be using:

http://www.peqserver.com/download.php?id=772 (Kunark_release)

as opposed to:

http://www.peqserver.com/download.php?id=773 (Kunark_upgrade)?

[Doodman]

Well, considering you're using a Kunark database, it would make sense that you cannot zone to zones past Kunark (as they are not in the database).

[shanxi]

Well i dont quite understand how I was able to zone into pop zones and such on other servers but not the one I made? I think i used all the same DB and everything. I guess im just tired. *blinks* heh

Originally Posted by shanxi

Well i dont quite understand how I was able to zone into pop zones and such on other servers but not the one I made? I think i used all the same DB and everything. I guess im just tired. *blinks* heh

because they enabled the other zones and you didnt.

[shanxi]

Lol but thats what i was asking =( How do I enable them?

in my database, expansions = 255

Other than enabling my expansions, everything except the agro is working perfectly now =) And im starting to dream in code ><

UPDATE 'npc_types' SET 'npc_aggro'=50 WHERE 'id'=1000;
UPDATE 'npc_types' SET 'npc_aggro'=50 WHERE 'id'=1001;
UPDATE 'npc_types' SET 'npc_aggro'=50 WHERE 'id'=1002;
UPDATE 'npc_types' SET 'npc_aggro'=50 WHERE 'id'=1003;

theres only a bazillion mobs I have to change that in. I hope that makes em attack whatever they dont like that comes within 50 feet of em >)

I wanna thank all you guys for putting up with my insistent questions, I am starting to understand how this is all set up, and im learning the mysql coding.

I am editing my database with mysql front (EQAdmin is too difficult even though it has a better GUI)

Now as you can see from above, thats what im putting in a .txt file...
UPDATE 'npc_types' SET 'npc_aggro'=50 WHERE 'id'=1000;
pasted it about 400,000 times and now im just changing the last number to one higher. (IE 100,1001,1002,1003,1004)
Long and arduous as it may be, I dont know how to make it so that it just changes to the next higher number.

I even tried to read the mysql manual which is confusing as hell, I was wondering if there was anyone of you that has a lot of knowledge in the coding area and a little spare time that could maybe sit down (figuratively) and somehow teach me a little bit about the basics of coding (commands, stings, etc) Through emails, PM, IM, or whatnot? I am sure I could find a way to repay for my learning experience, say, try to work on some database problem or something?

I can probably do texturing or minimal level design maybe. I am relatively new to all this but I do have graphic skills =)

Basically all im trying to say is a scratch my back ill scratch yours theory hehe.

All i have been doing is asking for help a lot, Id like to give back to the community somehow =D

[Xorith]

http://www.eqemulator.net/forums/viewtopic.php?t=18511

Found with the Search feature.

Will enable your zones.

-- Xorith

[shanxi]

Gah I use search all the time but for some reason I would not have thought to look mysql commands up. >< Thanks for that link too

[Xorith]

Anything that involves information for the server will be in MySQL. Keep that in mind If you have no NPCs, it's MySQL. If you have no doors, items, ect. Same.