Error loading NPCs from database. Bad query.
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) |
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; |
| All times are GMT -4. The time now is 05:22 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.