Error loading NPCs from database. Bad query?

lbc9999 · #1 11-12-2004, 08:15 PM

I am having the "Error loading NPCs from database. Bad query." error. I have tried logging using the mini login and I was able to enter the world but no npcs. I am using the PEQ_Kunark_RC1.sql database and I had to source in tributes.sql and tribute_levels.sql and had to add ALTER TABLE `doors` ADD `size` SMALLINT(5) UNSIGNED DEFAULT "100" NOT NULL;
ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4) DEFAULT "0" NOT NULL;
to fix an error when loading the zones with the doors. I also have tried my own compiled version of eqemu but I am still getting "Error loading NPCs from database. Bad query." or the zone crashes and the client will say disconnected.

Before that it wouldnt even load and i was gettin " Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away"

I had to uninstall the 4.0 of mysql and install the 3.23.58 version to get past that. The MySQL server has gone away thing may have something to do with the new security and service pack 2 for xp

here is what i receive from the world and zone window

Code:

Zone.exe
[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 doors
[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] 174 commands loaded
[Status] Loading embedded perl XS
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Error] Starting command queue Mapping...

[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
Map header: 18109 faces, 242 nodes, 25239 facelists
Loaded map: 54327 vertices, 18109 faces
Map BB: (-371.84 -> 913.63, -848.66 -> 470.81, -184.94 -> 628.75)
Map ./Maps/crushbone.map loaded.
[Status] Weather should change in 190 seconds
Error loading NPCs from database. Bad query.
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 58; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for crushbone ...
[Status] Done loading doors for crushbone ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Zone Bootup: crushbone (58)
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.
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.
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.
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.
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.
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.
[Status] 405531 New client from ip:127.0.0.1 port:4154
Read group ID for 'Truke': 0



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: xxx.xxx.xxx:9000
World server listening on: xxx.xxx.xxx:9000
Connected to LoginServer: newlogin1.eqemulator.net:5994
47375 New TCP connection: 127.0.0.1:4142
New zoneserver: #1 127.0.0.1:4142
Zoneserver SetConnectInfo: 127.0.0.1:4142: 127.0.0.1:8784
47594 New TCP connection: 127.0.0.1:4143
47594 New TCP connection: 127.0.0.1:4144
47594 New TCP connection: 127.0.0.1:4145
47594 New TCP connection: 127.0.0.1:4146
New zoneserver: #2 127.0.0.1:4146
New zoneserver: #3 127.0.0.1:4145
New zoneserver: #4 127.0.0.1:4144
New zoneserver: #5 127.0.0.1:4143
Zoneserver SetConnectInfo: 127.0.0.1:4143: 127.0.0.1:8781
Zoneserver SetConnectInfo: 127.0.0.1:4144: 127.0.0.1:8780
Zoneserver SetConnectInfo: 127.0.0.1:4145: 127.0.0.1:8782
Zoneserver SetConnectInfo: 127.0.0.1:4146: 127.0.0.1:8783
92453 New client from ip: xxx.xxx.xxx port: 4148
Account Attempting to be created:JoeSmoe 0
Logged in: FirstLogin LS#64171: JoeSmoe
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Truke race:4 class:4
Character creation request from JoeSmoe LS#64171 (xxx.xxx.xxx:4148) :
Name: Truke
Race: 4  Class: 4  Gender: 0  Deity: 215  Start zone: 9
STR  STA  AGI  DEX  WIS  INT  CHA    Total
 75   80  105   90   85   75   75     585
Face: 7  Eye colors: 0 0
Hairstyle: 0  Haircolor: 0
Beard: 0  Beardcolor: 0
Validating char creation info...
Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=9 AND player_class=4 AND player_deity=215 AND player_race=4

[Status] Found starting location in start_zones
Current location: Gfaydark  523.00, -447.00, 117.53
Bind location: Gfaydark  523.00, -447.00, 117.53
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 4 or race = 0) AND (class = 4 or class = 0) AND (deityid = 215 or deityid=0)
 AND (zoneid = 54 or zoneid = 0) AND gm &lt;= 0 ORDER BY id
Character creation successful: Truke
Read group ID for 'Truke': 0
   0: 2C 30 2C 2E 54 72 75 6B - 65 2C 30 36 37 61 37 39  | ,0,.Truke,067a79
  16: 64 34 00                                           | d4.
Attempting autobootup of Gfaydark (54) for Truke
Zoneserver SetZone: 127.0.0.1:8781 Gfaydark (54)
Enter world: Truke: Gfaydark (54)
Zoneserver SetZone: 127.0.0.1:8781 Gfaydark (54)
Received unknown opcode: 0x0376 size:0 bytes
Client disconnected
Removing client from ip:xxx.xxx.xxx port:4148
World: processing ZTZ from egress zone (54) client: Truke
World (54): Successfully booted a zone for Truke
Zoneserver SetZone: 127.0.0.1:8780 crushbone (58)
World: processing ZTZ from ingress zone (58) client: Truke
449047 New client from ip: xxx.xxx.xxx port: 4152
Logged in: FirstLogin LS#64171: JoeSmoe
Zoneserver SetZone: 127.0.0.1:8781  (0)
Read group ID for 'Truke': 0
   0: 2C 30 2C 2E 54 72 75 6B - 65 2C 30 36 37 61 37 39  | ,0,.Truke,067a79
  16: 64 34 00                                           | d4.
Enter world: Truke: crushbone (58)
Zoneserver SetZone: 127.0.0.1:8780 crushbone (58)
Client disconnected
Removing client from ip:xxx.xxx.xxx port:4152

shanen98 · #2 11-13-2004, 02:12 PM

I am getting the exact same error...Please let me know if you find a fix. THanks

**fathernitwit** · #3 11-13-2004, 03:13 PM

per the change log:
ALTER TABLE npc_types ADD npc_aggro TINYINT NOT NULL DEFAULT '0';

lbc9999 · #4 11-13-2004, 07:33 PM

Thank you soooooo much. That did the trick!

IntesstoMic · #5 11-22-2004, 05:56 AM

Have the same error ill try now :)