I ran this compare tool from vb.org (http://www.vbulletin.org/forum/showthread.php?t=209890) on my site and deleted some database tables it said shouldn't be there. Afterwards, I was browsing the forums and tried to mark the forums read and got this database error.
Obviously, this is my fault for not backing up my forums before doing things with the database, but what do I need to do to make this work again? I know I need to re-add one of the items I deleted, but what kind of query do I need to run to make sure I get that back in the right place?
Edit:
I think I've got it. I added a 'newpost' field at the end of 'vb_session' and was then able to mark the forums read. Hopefully I won't run into any other problems with some of the things I deleted.
Code:
Database error in vBulletin 3.8.4: Invalid SQL: UPDATE vb_session SET newposts = NULL WHERE userid = 1; MySQL Error : Unknown column 'newposts' in 'field list' Error Number : 1054 Request Date : Saturday, October 24th 2009 @ 09:40:24 PM Error Date : Saturday, October 24th 2009 @ 09:40:24 PM Script : http://www.braves-nation.com/forums/forumdisplay.php?do=markread Referrer : http://www.braves-nation.com/forums/
Edit:
I think I've got it. I added a 'newpost' field at the end of 'vb_session' and was then able to mark the forums read. Hopefully I won't run into any other problems with some of the things I deleted.