User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 456,495 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,693 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 583 | Replies: 3
Reply
Join Date: Aug 2007
Posts: 16
Reputation: smartness is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
smartness's Avatar
smartness smartness is offline Offline
Newbie Poster

Database error

  #1  
Sep 22nd, 2007
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/f...ostthread&f=91
Referrer : http://gjilaniforum.altervista.org/f...newthread&f=91
IP Address : 82.114.72.186
Username : smartness
Classname : vb_database

any solution
Last edited by smartness : Sep 22nd, 2007 at 6:21 am.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Aug 2007
Posts: 16
Reputation: smartness is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
smartness's Avatar
smartness smartness is offline Offline
Newbie Poster

Re: Database error

  #2  
Sep 22nd, 2007
i forgot to say that i get this error wen i try to post a new thread...
Reply With Quote  
Join Date: Aug 2007
Location: Morrisdale, PA
Posts: 52
Reputation: JeniF is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 5
JeniF's Avatar
JeniF JeniF is offline Offline
Junior Poster in Training

Solution Re: Database error

  #3  
Sep 22nd, 2007
UPDATE session SET newposts = newposts+1 WHERE NOT ISNULL(newposts);

Try this

UPDATE session SET newposts = newposts+1 WHERE newposts !NULL;
I keep hitting "escape", but I'm still here!!!!
:}
Reply With Quote  
Join Date: Aug 2007
Location: Cavite,Philippines
Posts: 508
Reputation: ryan_vietnow is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 68
ryan_vietnow's Avatar
ryan_vietnow ryan_vietnow is offline Offline
Posting Pro

Re: Database error

  #4  
Sep 22nd, 2007
update session set newposts=newposts+1 where newposts != 0;
"death is the cure of all diseases..."
http://ryantetek.wordpress.com
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb PHP Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the PHP Forum

All times are GMT -4. The time now is 3:25 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC