shanxi
11-20-2004, 01:48 PM
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,trigg ertype,dest_zone,dest_x,dest_y
,dest_z,dest_heading,door_param,invert_state,incli ne,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
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,trigg ertype,dest_zone,dest_x,dest_y
,dest_z,dest_heading,door_param,invert_state,incli ne,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