Weird Bug with quest Globals

[LordKahel]

Disregard my post , I found what was causing the problem.

The expdate column was set to not accept NULL values. I changed it to permit NULL and it work perfectly now.

[AndMetal]

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

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).

[cavedude]

Originally Posted by AndMetal

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.

Yeah, that column is correct on CVS but hasn't worked its way into a release yet. The next release of the db will have it current.

[AndMetal]

Actually (and I had to double-check to make sure I saw it correctly), the load_empty_users.sql file from peq-ykesha-release.zip DOES include the change. However, unless you clear out your users, then load them back in (which I personally did NOT do), the change won't be made (which is the problem I had).

I guess the simple solution would be to add a line somewhere to alter the table, like in load_system.sql, etc, to reflect the change. Then again, the "better" thing might be just to post a notice that you may have to change it manually. *shrug*