Someone tell me the cause of this error.

[haytham]

Hi
I know it must be a mod I installed but I uninstalled most mods. The ones I have, I really need. Please look at the eroor and try to tell me what maybe causing it. Thanks
========================
Database error in vBulletin 3.6.5:

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, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount




,post.pagetext
FROM thread AS thread







WHERE thread.threadid IN (0)
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Unknown table 'post' in field list
Error Number : 1109
Date : Monday, March 19th 2007 @ 05:05:54 AM
Script : http://####.com/vb/forumdisplay.php?f=15
Referrer : http://www.google.ae/search?hl=ar&q=...85%D8%A7&meta=
IP Address : 203.22.2.24
Username : unregistered
Classname : vb_database

[Marco van Herwaarden]

De-activate them one-by-one until the error goes away.

[Lynne]

Originally Posted by haytham

,post.pagetext
FROM thread AS thread

If you are selecting post.pagetext, you need to add post into the FROM part of your query.

[haytham]

It appears that the cause was that I chose to prvent visitors from browsing the forum so if they clicked on any forum they'd get the error. Also when searching google and finding a page on my site. they weren't able to see it so they got those error messages.
Now I opened my forum to browsing of visitors and I am not getting any more errors.

Just wanted to share how it was solved in case someone gets the same error.

Haytham

Thanks all

[Marco van Herwaarden]

The error is caused by a modification. You will not get that error with default vBulletin on a closed board.