0

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

4
Contributors
4
Replies
5
Views
10 Years
Discussion Span
Last Post by Miklo_jan
0

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

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

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

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.