Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 14 May 2006, 05:35
Ahsin1 Ahsin1 is offline
 
Join Date: Mar 2006
Real name: Ahsin Khalid
Question Error Number : 1109

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,

thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount


,post.pagetext, firstpostid
FROM vbulltinthread AS thread






WHERE thread.threadid IN (0,570,365,568,442,364,37,579,483,392,402,451,381,431,353,432,400,341,389,327)
ORDER BY sticky DESC, thread.lastpost DESC;

MySQL Error : Unknown table 'post' in field list
Error Number : 1109

Date : Sunday, May 14th 2006 @ 04:17:29 AM



===================================================

any idea wht i should do ?
Reply With Quote
  #2  
Old 14 May 2006, 05:50
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
What version of vb are you using and what is the actual query that was running when that error came? And do you have a table prefix?
Reply With Quote
  #3  
Old 14 May 2006, 05:52
Adrian Schneider's Avatar
Adrian Schneider Adrian Schneider is offline
 
Join Date: Jul 2004
You need to perform a join to retrieve info from the post table...
Reply With Quote
  #4  
Old 14 May 2006, 06:44
Xorlev Xorlev is offline
 
Join Date: May 2006
The problem there seems to be that there is no post table. You may need a table prefix.
Reply With Quote
  #5  
Old 14 May 2006, 07:30
Adrian Schneider's Avatar
Adrian Schneider Adrian Schneider is offline
 
Join Date: Jul 2004
Originally Posted by Xorlev
The problem there seems to be that there is no post table. You may need a table prefix.
No; the problem is that there is no post table in the result set. The only table he is pulling from is 'thread'.

I would add something like:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Last edited by Adrian Schneider; 14 May 2006 at 07:33.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 21:54.

Layout Options | Width: Wide Color: