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

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Server up, login fine, no doors or NPCs [error code inside] (https://www.eqemulator.org/forums/showthread.php?t=17097)

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

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:

Quote:

Thanks for the help but I figured it out finally

without detailing what they did.

I am getting these errors:

World.exe

Code:

[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

Code:

[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

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:

Code:

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

Enjoy

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

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

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

Quote:

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.

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

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

Found with the Search feature.

Will enable your zones.

-- Xorith

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

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.