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
zone_id 'n' not found in database
Threaded Mode
