PDA

View Full Version : SQL erro after upgrading


nelto
Sat 10th Jun '06, 5:14am
veru simple

Database error in vBulletin 3.6.0 Beta 1:
Invalid SQL:
UPDATE session SET newposts = newposts+1 WHERE NOT ISNULL(newposts);
MySQL Error : Unknown column 'newposts' in 'where clause'
Error Number : 1054
Date : Saturday, June 10th 2006 @ 10:11:21 AM
Script : http://www.virtualtuners.com/forum/newthread.php?do=postthread&f=36
Referrer : http://www.virtualtuners.com/forum/newthread.php?do=newthread&f=36
IP Address : 89.180.24.32
Username : nbento
Classname : vb_database
I can PM, I can preview threads but I cant post.
That error happens when trying to create new threads or replying to posts.
I have photopost on top of the foruns, and GARS... NOT a single hack installed.

nelto
Sat 10th Jun '06, 6:49am
I just found that even trowing that error while submitting a new thread, the sam thread was posted (submitted) now thats weird.
Im going to test a few more times

nelto
Sat 10th Jun '06, 4:28pm
Some help here would be much appreciated

Steve Machol
Sat 10th Jun '06, 6:10pm
There is no 'newposts' column in the default 3.6 session table. This is from a hack or plugin you've installed.