View Single Post
  #1  
Old 05-23-2009, 01:21 PM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default zone_id 'n' not found in database

I attempted to update to the latest SVN + PEQ DB (system only) last week. What I did was compile 553 (I think it was), then point it to a new PEQ DB I sourced in. I moved my "player" data to this new DB, then applied all patches in the 'updates' folder. Lots of errors, because I had been manually applying patches through 443 (the current working version on my server). When I got all done, I had this odd problem everytime I or someone else tried to log in. World reported that it could not find the zone_id for the character currently trying to log in.

Now, disclaimer that I have not been following the tremendous amount of work you all have been doing, so I am not sure what zone_id it is looking for... in the zone table, the zoneidnumber definitely exists. One other problem that I solved had something to do with instZOrgID and flag... the Rev59 file adds them, but a Rev535.sql later, removed them. But the world wanted them... so, I put them back. Where I come from, 59 comes before 535, so I was >assuming< I applied these updates in the right order

Anyway, long story short, I cannot log in after updating to the latest SVN.

So, the grand question is: If I am using SVN for code, should I NOT be using PEQ DB updates to update the DB for said code? Cuz, I think that's where I went wrong.

TIA,
J
Reply With Quote