Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Column Jump to first unread post cannot be left blank

Quote Reply
Column Jump to first unread post cannot be left blank
I went in and changed an old user ID's status via the admin tool, when I told it to apply the changes I got:

"Column Jump to first unread post cannot be left blank."

This makes me wonder what all the old user ID"s are defaulted to? And is there a query to change that column to "yes" for those old ID's?
Quote Reply
Re: [HeavyBombers] Column Jump to first unread post cannot be left blank In reply to
That's odd - you shouldn't get a blank value for it as the column should be NOT NULL. In any event:

UPDATE gforum_User set user_jump_to_unread = 1 where user_jump_to_unread = NULL;

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com