Member Avatar for smartness

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
  • 234 Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by Miklo_jan

Recommended Answers

All 4 Replies

Member Avatar for smartness

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

Member Avatar for JeniF

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

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

Member Avatar for ryan_vietnow

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

Member Avatar for Miklo_jan

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

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.