Member Avatar for Miklo_jan

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

error.jpg 47.26 KB
Edited by Miklo_jan because: n/a
  • 2 Contributors
  • 3 Replies
  • 380 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for 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.

Member Avatar for Miklo_jan

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

Member Avatar for pritaeas

Did you ask this in the vBulletin forum ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.