No NPCs
 

Everything runs fine but there are no NPCs. Am running 5.7 DR4 with MW_057DR2_alpha_1 db.

I keep getting this error:
Error loading NPCs from database. Bad query.

Here is whats in my zone.exe

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR4
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0
!
[Status] command_init(): Warning: Command 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] 161 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 192.168.1.100:9000
[Status] Weather should change in 2592 seconds
Error loading NPCs from database. Bad query.
Init: Loading zone lists, zone state or spawn list, player corpses
Zonepoints loaded into memory
, timezone data - Done. ZoneID = 152; Time Offset = 0
Reading zhdr file './cfg/nexus.cfg'
Using database for safe coords.
Zone safe coords are x = 0; y = 0; z= -30
Reading zhdr file './cfg/nexus.cfg'
Using database for safe coords.
Zone safe coords are x = 0; y = 0; z= -30
Using default zone header data...
Converting old zone data...
Attempting to write ./cfg\nexus.cfg
Write complete.
Reading zhdr file './cfg/nexus.cfg'
Using database for safe coords.
Zone safe coords are x = 0; y = 0; z= -30
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for nexus ...
[Status] Done loading doors for nexus ...
[Status] Zone Bootup: nexus (152)
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [02:41 pm]
[Status] 87816 New client from ip:192.168.1.1 port:3297
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x02f4, size: 4
Unknown opcode: 0x01e4 size:8 Client:Devildog
0: 0A 00 00 00 07 8C 2A 58 | ......*X

I think theres something wrong with your configuration files o_O are you using the 5.6 ones?

yea, i followed the guide here http://www.eqemulator.net/forums/viewtopic.php?t=13403 only i am using 5.7 dr4 instead of dr3

Ok, I know this is a big huge query, but try this out on your database. This is what it does when it tries to load all NPC types for a zone (in this example, Nexus).

SELECT npc_types.id,npc_types.name,npc_types.level,
npc_types.race,npc_types.class,npc_types.hp,
npc_types.gender,npc_types.texture,npc_types.helmt exture,
npc_types.size,npc_types.loottable_id,
npc_types.merchant_id,npc_types.banish,npc_types.m indmg,
npc_types.maxdmg,npc_types.npcspecialattks,
npc_types.npc_spells_id,npc_types.d_meele_texture1 ,
npc_types.d_meele_texture2,npc_types.walkspeed,
npc_types.runspeed,npc_types.fixedz,
npc_types.hp_regen_rate,npc_types.mana_regen_rate,
npc_types.aggroradius,npc_types.bodytype,
npc_types.npc_faction_id,npc_types.face,
npc_types.see_invis,npc_types.see_invis_undead,
npc_types.lastname,npc_types.qglobal,npc_types.AC
FROM npc_types,spawn2 WHERE spawn2.zone='nexus'
AND npc_types.id=spawn2.id;

If that reports an error, and it should, it will give a clue as to what the problem querying is.

k this is what i got

mysql> SELECT npc_types.id,npc_types.name,npc_types.level,
-> npc_types.race,npc_types.class,npc_types.hp,
-> npc_types.gender,npc_types.texture,npc_types.helmt exture,
-> npc_types.size,npc_types.loottable_id,
-> npc_types.merchant_id,npc_types.banish,npc_types.m indmg,
-> npc_types.maxdmg,npc_types.npcspecialattks,
-> npc_types.npc_spells_id,npc_types.d_meele_texture1 ,
-> npc_types.d_meele_texture2,npc_types.walkspeed,
-> npc_types.runspeed,npc_types.fixedz,
-> npc_types.hp_regen_rate,npc_types.mana_regen_rate,
-> npc_types.aggroradius,npc_types.bodytype,
-> npc_types.npc_faction_id,npc_types.face,
-> npc_types.see_invis,npc_types.see_invis_undead,
-> npc_types.lastname,npc_types.qglobal,npc_types.AC
-> FROM npc_types,spawn2 WHERE spawn2.zone='nexus'
-> AND npc_types.id=spawn2.id;
ERROR 1054: Unknown column 'npc_types.AC' in 'field list'
mysql>

You need to type use eq ; , or use <whatever your EQ database is called> before typing that query.

hehe yea i noticed that, edited last post while you replied lol

Try putting an AC field in there. I think this is the syntax:

mysql> ALTER TABLE npc_types ADD ac int;

Also, as an aside, there were some changes made to loading of NPC types. They are no longer in shared memory. Each zone only loads what it needs.

k i add the AC column but now i can't get into the world, after selecting a character and trying to enter the world i get a popup box saying that zone is unavailable and a zone.exe shuts off. tried making new toons with diff start zones and none work. can't get a log from zone.exe cause it shuts off but i get this in my world.exe

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR4
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=28731, max id=69304
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
You may already be a winner... of the darwin award.
TCP listening on: 68.46.67.8:9000
World server listening on: 68.46.67.8:9000
Connected to LoginServer: eqlogin3.eqemulator.net:5997
41980 New TCP connection: 192.168.1.100:4098
41980 New TCP connection: 192.168.1.100:4099
41980 New TCP connection: 192.168.1.100:4100
41980 New TCP connection: 192.168.1.100:4101
41980 New TCP connection: 192.168.1.100:4102
New zoneserver: #1 192.168.1.100:4100
New zoneserver: #2 192.168.1.100:4099
New zoneserver: #3 192.168.1.100:4098
Zoneserver SetConnectInfo: 192.168.1.100:4098: 68.46.67.8:7999
New zoneserver: #4 192.168.1.100:4102
New zoneserver: #5 192.168.1.100:4101
Zoneserver SetConnectInfo: 192.168.1.100:4099: 68.46.67.8:7996
Zoneserver SetConnectInfo: 192.168.1.100:4100: 68.46.67.8:7998
Zoneserver SetConnectInfo: 192.168.1.100:4101: 68.46.67.8:7997
Zoneserver SetConnectInfo: 192.168.1.100:4102: 68.46.67.8:7995
87235 New client from ip: 192.168.1.1 port: 4104
Logged in: FirstLogin LS#54806: devild0g
Received unknown opcode: 0x02ea size:0 bytes
Attempting autobootup of nexus (152) for Devildog
Received unknown opcode: 0x02ea size:0 bytes
Attempting autobootup of nexus (152) for Devildog
192.168.1.100:4101: TCPConnection::RecvData(): Error: 10053
Removing zoneserver from ip:0.0.0.0 port:0 (68.46.67.8:7997)
Hold Zones mode is ON - rebooting lost zone
178507 New TCP connection: 192.168.1.100:4108
New zoneserver: #6 192.168.1.100:4108
Zoneserver SetConnectInfo: 192.168.1.100:4108: 68.46.67.8:7997
Received unknown opcode: 0x02ea size:0 bytes
192.168.1.100:4102: TCPConnection::RecvData(): Error: 10053
Removing zoneserver from ip:0.0.0.0 port:0 (68.46.67.8:7995)
Hold Zones mode is ON - rebooting lost zone
220066 New TCP connection: 192.168.1.100:4110
New zoneserver: #7 192.168.1.100:4110
Zoneserver SetConnectInfo: 192.168.1.100:4110: 68.46.67.8:7995
Name approval request for:Deviltank race:8 class:3
Character creation request from devild0g LS#54806 (192.168.1.1:4104) :
Name: Deviltank
Race: 8 Class: 3 Gender: 0 Deity: 202 Start zone: 8
STR STA AGI DEX WIS INT CHA Total
100 115 70 90 88 60 55 578
Face: 4 Eye colors: 2 2
Hairstyle: 255 Haircolor: 255
Beard: 255 Beardcolor: 255
Validating char creation info...
Found 0 errors in character creation request
No start_zones entry in database, using defaults
Current location: kaladima -2.00, -18.00, 3.75
Bind location: butcher -700.00, 2550.00, 2.90
Character creation successful: Deviltank
Telling client to continue session with: Devildog
Attempting autobootup of kaladima (60) for Deviltank
Received unknown opcode: 0x02ea size:0 bytes
192.168.1.100:4110: TCPConnection::RecvData(): Error: 10053
Removing zoneserver from ip:0.0.0.0 port:0 (68.46.67.8:7995)
Hold Zones mode is ON - rebooting lost zone
313471 New TCP connection: 192.168.1.100:4120
New zoneserver: #8 192.168.1.100:4120
Zoneserver SetConnectInfo: 192.168.1.100:4120: 68.46.67.8:7995
Client disconnected
Removing client from ip:192.168.1.1 port:4104

well when i made the ac column the values were set to NULL, i changed that so they are all 0 now and it worked, a little... zone.exe doesn't crash now but it seems eq itselfs is, i'm still messing around with it some

k beats me but i rebooted my pc and now everything works fine lol and i got my npcs back :)

ok so i am getting the EXACT same problem as above. with all the same stuff as above.

I got through most of it... But I am not so lucky. So i assume it was setting the NULL Vallues to 0 is what helped..

all i need to know is how do you set those NULL vallues to 0? my SQL knowlege is not up that high yet..

Edit: Nevermind, I found the command and stuff.... it works now yay! I have spawns again

ok, I screwed up.. I was able to log into my server sourced the DBs, and didnt have any NPCs on my new db... so for some stupid reason I put in

ALTER TABLE npc_types ADD ac int;

thinking from reading above that this would fix the NPC problem and now when I log into my server the zone server crashes and tells me zones not available after character select..

Can anyone tell me how to subtract this command?

tks

if you used all the same stuff as above. and had no spawns just like above. and added the AC column with no errors. Then yes you need to set the Null values to 0.

Use this command in the sql command line

This has worked for me, and a friend.

edit : By the way, let us know how it works.

edit: Also one more thing, I believe that this command will set the AC vallues of the mobs to 0.

But i think i may have found an alright solution. check out this post

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

Trying this now, hope it works. :\

yup
 

I had the same exact problem and it worked for me, thanks for sharing.