Hi guys, Well I just reinstalled vBulletin 3.8.6, on top of the other.
I tried to make a new THREAD, after posting it says:

Database error in vBulletin 3.8.6:

Invalid SQL:
UPDATE session SET newposts = newposts+1 WHERE NOT ISNULL(newposts);

MySQL Error : Unknown column 'newposts' in 'where clause'
Error Number : 1054
Request Date : Monday, July 11th 2011 @ 01:01:27 PM
Error Date : Monday, July 11th 2011 @ 01:01:27 PM
Script : ...reezoka.net/newthread.php?do=postthread&f=10
Referrer : ...reezoka.net/newthread.php?do=newthread&f=10
IP Address :
Username : Admin
Classname : vB_Database
MySQL Version : 5.1.57

I have put a picture below, if it helps.
I hope you can help me, cos I have used a lot of time on this

Thank u so much, By MIKLO

Edited by Miklo_jan: n/a

Attachments error.jpg 47.26 KB
7 Years
Discussion Span
Last Post by pritaeas

Check your database if the table and column is there. Run the query from phpMyAdmin or any other tool and see if you get the same error.


Hi, I am totally new in mysql,

Still am locked up, cant move on, any of you can help me, I can provide you my MYSQL PASSWORD and USERNAME

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.