Announcement

Collapse
No announcement yet.

Database Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Error

    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.

    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/
    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.
    Last edited by McCarroll21; Sat 24 Oct '09, 7:01pm.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X