View Single Post
  #3  
Old 12-14-2007, 06:52 AM
AndMetal
Developer
 
Join Date: Mar 2007
Location: Ohio
Posts: 648
Default

I was actually running into the same issue. As a matter of fact, after looking through the zone logs, I saw this line:

Code:
setglobal error inserting pop_poj_mauvin : #1048: Column 'expdate' cannot be null
After doing some research, it appears that the "expdate" column was changed in the PEQ DB on 11/14/2007 (see Diff of /peq_db/quest_globals.sql) to accept NULL values. However, it is part of the "load_empty_users.sql" file, which I know I didn't run when updating my DB.

After changing the column in the database manually to accept NULL values (while the server was still running), my quests globals were able to update for quests that use the F duration (PoP flags, etc).
__________________
GM-Impossible of 'A work in progress'
A non-legit PEQ DB server
How to create your own non-legit server

My Contributions to the Wiki
Reply With Quote