Database error in vBulletin 3.6.8:

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, September 22nd 2007 @ 11:19:12 AM
Script : http://gjilaniforum.altervista.org/forumi/newthread.php?do=postthread&f=91
Referrer : http://gjilaniforum.altervista.org/forumi/newthread.php?do=newthread&f=91
IP Address : 82.114.72.186
Username : smartness
Classname : vb_database

any solution

i forgot to say that i get this error wen i try to post a new thread...

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

Try this UPDATE session SET newposts = newposts+1 WHERE newposts !NULL;

update session set newposts=newposts+1 where newposts != 0;

Plz Help!
This is happening to me as well. What should I do guys,
I have been working on my forum, and I just had a new INSTALLATION on of the old VBULLETIN, Where should I past this line in MYQSL:

UPDATE session SET newposts = newposts+1 WHERE newposts !NULL;

and HOW?

Plz Help!

By Mikloe