No announcement yet.

Database Error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Error

    I ran this compare tool from ( 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.

    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        :
    Referrer      :
    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?

    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.