Databse error. Please advise

[icare]

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

[peterska2]

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.

[icare]

Originally Posted by peterska2

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?

[peterska2]

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

[icare]

Originally Posted by peterska2

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..