Error loading NPCs from database. Bad query.

Ranger65 · #1 06-15-2004, 04:23 AM

Hi all,
First off, thank all of you that have been so helpful to a n00b like me. I have spent a great deal of time combing the posts, but no one seems to be having the same problems. I am pretty sure that my database is hosed, and would like to know if there is one place to download all of the operational DB components from.
I get into my Live server now (/bow Ultimatex), create a character, try to log in, but end up back at the loging screen. I have tried different zones, but get the same error. Below is a dump from the zone.exe window.

Thanks in advance,
Mike

[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.102:9000
[Status] Weather should change in 10930 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 = 49; Time Offset = 0
Couldn't find/read ./cfg/oggok.cfg. (returning -1)
Couldn't find/read ./cfg/.cfg. (returning -1)
Corrupt (or nonexistant) zhdr file ./cfg/.cfg -- fread count = -1 (should be 588
)
Using default zone header data...
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for oggok ...
[Status] Done loading doors for oggok ...
[Status] Zone Bootup: oggok (49)
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.
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [12:41 pm]
[Status] Zone Shutdown: oggok (49)

ultimatex · #2 06-15-2004, 05:13 AM

Yup I know how to fix this one to bud. Next time just ask me

There is a problem with the AC collumn. THERE ISNT ONE. But there is a fix for it.

there is a SQL here to add the AC collumn, and the vallues.

http://www.eqemulator.net/forums/vie...1&highlight=ac

If there is a problem. you may have to add the collumn manually. But i have the code for that too.

Type in

Code:

ALTER TABLE npc_types ADD ac int;

and then try sourcing it again.