|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Archive::Windows Servers Archive area for Windows Servers's posts that were moved here after an inactivity period of 90 days. |
 |
|
 |
08-08-2004, 04:57 PM
|
|
Fire Beetle
|
|
Join Date: Apr 2004
Posts: 20
|
|
Error loading NPCs from database. Bad query.
Here's a log from zone.exe -
[Status] Weather should change in 2488 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 = 55; Time Offset = 0
Reading zhdr file './cfg/akanon.cfg'
Using database for safe coords.
Zone safe coords are x = -35; y = 47; z= 4
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
Error in LoadGroundSpawns query 'SELECT max_x,max_y,max_z,min_x,min_y,heading,na
me,item,max_allowed,respawn_timer from ground_spawns where zoneid=55 limit 50' #
1054: Unknown column 'respawn_timer' in 'field list'
[Status] Loading doors for akanon ...
[Status] Done loading doors for akanon ...
[Status] Zone Bootup: akanon (55)
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from 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 [08:11 am]
[Status] Zone Shutdown: akanon (55)
Any fix will be appreciated.
|
 |
|
 |
08-08-2004, 05:58 PM
|
|
Demi-God
|
|
Join Date: May 2004
Posts: 1,177
|
|
what database and source are you using? sounds like your database is fux0red....
theres no respawn_timer field on your groundspawns table.
Code:
Error in LoadGroundSpawns query 'SELECT max_x,max_y,max_z,min_x,min_y,heading,na
me,item,max_allowed,respawn_timer from ground_spawns where zoneid=55 limit 50' #
1054: Unknown column 'respawn_timer' in 'field list'
thats what its complaining about. |
08-08-2004, 06:06 PM
|
|
Fire Beetle
|
|
Join Date: Apr 2004
Posts: 20
|
|
Right now I deleted the database and am starting over. I'll keep updating.
|
08-08-2004, 06:37 PM
|
|
Banned
|
|
Join Date: Nov 2003
Posts: 335
|
|
if i were you i would keep each database and just make more for each new try, that way if you found something different, you'd know what it was.
|
|
|
|
08-08-2004, 08:16 PM
|
|
Fire Beetle
|
|
Join Date: Apr 2004
Posts: 20
|
|
Fixed part of it. Here it is now:
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR6
[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 Doors from database...
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5061
[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] 167 commands loaded
[Status] Loading embedded perl
[Status] Loading perlemb plugins.
[Status] Warning - plugin.pl: Perl runtime error: open 'plugin.pl' No such file
or directory at (eval 3) line 1.
[Status] Entering sleep mode
Connected to worldserver: localhost:9000
[Status] Weather should change in 13748 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 = 55; Time Offset = 0
Reading zhdr file './cfg/akanon.cfg'
Using database for safe coords.
Zone safe coords are x = -35; y = 47; z= 4
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for akanon ...
[Status] Done loading doors for akanon ...
[Status] Zone Bootup: akanon (55)
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from 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] Zone Shutdown: akanon (55)
Edit: I'm using MW_057DR2_alpha_1.sql as the db.
Edit2: Also there's an error when I run newitemsdump.sql after a while.
|
|
|
|
08-09-2004, 03:06 AM
|
|
Hill Giant
|
|
Join Date: May 2004
Posts: 238
|
|
U need to add the AC column
ALTER TABLE `npc_types` ADD `AC` smallint(5) not null default 0;
and that shoud work for you.
|
08-09-2004, 03:14 AM
|
|
Demi-God
|
|
Join Date: May 2004
Posts: 1,177
|
|
As far as the items. i'd recommend to delete your items table. then download the allitems file from
http://www.peqserver.com
simply source it in AFTER deleting entirely your items table from your database. it will create it for you. |
08-09-2004, 08:24 AM
|
|
Fire Beetle
|
|
Join Date: Apr 2004
Posts: 20
|
|
Everything is fixed!!!! Except for one thing -
Whenever I log in on my own server it kicks me out saying server is not responding, then you have been disconnected. No error messages either. Anyone know what's wrong?
|
08-09-2004, 08:25 AM
|
|
Banned
|
|
Join Date: Nov 2003
Posts: 335
|
|
on the code you posted, it said that no plugin.pl was found. did you put the plugin.pl in the eqemu directory also?
|
08-09-2004, 08:35 AM
|
|
Fire Beetle
|
|
Join Date: Apr 2004
Posts: 20
|
|
Fixed plugin.pl. Now I just need to fix the server not responding error when I enter.
|
08-09-2004, 10:09 AM
|
|
Fire Beetle
|
|
Join Date: Apr 2004
Posts: 20
|
|
IT WORKS!!! IT'S ALIVEEEEEEE!!!!!!
It looks a lot like EQ live. The problem was on the boot5zones.bat it looked like this:
YourIP 7995 local host
I changed yourip to localhost and it worked! 
Thanks for ALL your help, I appreciate it! |
08-09-2004, 11:52 AM
|
|
Banned
|
|
Join Date: Nov 2003
Posts: 335
|
|
You might not want to do that, because if its localhost then Only your computer can login =/ . are you behind a router? because if you are thats the problem. you need to forward your ports and/or enable DMZ routing. I have a linksys router to do this go to windows explorer and type 192.168.1.1 . I had the same problem.
|
08-09-2004, 02:04 PM
|
|
Fire Beetle
|
|
Join Date: Apr 2004
Posts: 20
|
|
I have a linksys router and whenever I go to forward it, it requires me to login. I try admin in the password and it never works.
|
08-09-2004, 03:45 PM
|
|
Demi-God
|
|
Join Date: May 2004
Posts: 1,177
|
|
Code:
You might not want to do that, because if its localhost then Only your computer can login
I'm pretty sure that's not true. but i do have mine set with the actual ip.
Your problem is probably with the ports. You need to go to applications and games in your router panel. and open up any port you see the zone / world referencing.
there are a number of variations for logins.
try these.
admin:password
admin:admin
(blank):admin
if none work, call linksys tech support they can help you log in. |
08-10-2004, 06:35 AM
|
|
Sarnak
|
|
Join Date: Jul 2004
Location: Kearns, UT
Posts: 55
|
|
When the code refers to localhost as the zone.exe file, it tried to find the file on the users computer. It needs to be set to an actual IP for other computers not running a zone.exe to play on it. It might be possible to play on another server with localhost specified as the host if you have a null server running, but that really wouldn't make much sense. What sotonin said about the ports is most likely true, verify your router is allowing those ports to be open.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 12:11 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Linear Mode
