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/...hp?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. |
الساعة الآن 03:54 AM |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir