Databse error. Please advise
 

Database error in vBulletin 3.5.3:

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
FROM thread AS thread






WHERE thread.threadid IN
(0,521,440,381,463,504,339,438,435,433,492,490,467 ,468,481,461,375,471,470,466,281,359)

ORDER BY sticky DESC, thread.lastpost DESC;

MySQL Error : Unknown table 'post' in field list
Error Number : 1109
Date : Saturday, February 11th 2006 @ 10:06:05 PM
Script : http://www.example.com/forumdisplay.php?f=2
Referrer : http://www.example.com/
IP Address : xxx.xxx.xxxx.xx
Username : Unregistered
Classname : vb_database

Please help me, I got about 1000 emails today in my admin email as users are getting this error. Anybody please help

Me thinks this is coz of the gap in the query. It's not advisable so get rid of all the sapce/text/junk between the two bits of the query and try again.

Please explain i am newbie. ho to do that?

Something that you have installed has required a file edit in the middle of a SQL query. You need to make sure that there is no commented text in the query otherwise it causes errors

I installed bunch of crap today. now i am not sure which one did caused the problem.. now uninstalling one by on... hope it will fix it..