View Single Post
  #8  
Old 08-01-2006, 05:26 PM
Elkay
Hill Giant
 
Join Date: Sep 2004
Posts: 184
Default

Ah ok, makes perfect sense.

Anyway, still having some problems post-ppconvert. Now when I try to enter a zone from the char select, I see this in the zone window:

Path File ./Maps/freportw.path not found.
[Status] Weather should change in 6728 seconds
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.wa
lkspeed' in 'field list'
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
Error3 in PopulateZoneLists query 'SELECT spawnentry.spawngroupID, npcid, chance
, spawnentry.spawn_limit AS gsl, npc_types.spawn_limit AS sl FROM spawnentry, s
pawn2 LEFT JOIN npc_types ON spawnentry.npcID = npc_types.id WHERE spawnentry.sp
awngroupID=spawn2.spawngroupID AND zone='freportw' ORDER by chance' #1054: Unkno
wn column 'spawnentry.spawn_limit' in 'field list'
[Error] Loading spawn groups failed.
Zone->Init failed

Now.. I saw someone else had this exact error in another post, and never got an appropriate response back for the fix. My spawnentry table does exist, but it does not have this field. According the the current PEQ schema, that table doesn't have that column, but the spawngroup table does. Also, my npc_type table has walkspeed removed per the logs for the most current build (840). What gives, and what's right? I'm running the 'official' 840 binaries on windows.

EDIT: I got into the game fine with the 833 and 839 builds (just tried them on a hunch). I'm wondering if there's just something flat out wrong with the official 840 build. I get no SQL errors on 833 or 839 and all appears to be working now.

Last edited by Elkay; 08-02-2006 at 01:44 AM..
Reply With Quote