Unknown table 'post' in field list

[iamnofear]

I got this error. How can I fix it ?

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)
ORDER BY sticky DESC, thread.lastpost DESC;

MySQL Error : Unknown table 'post' in field list
Error Number : 1109
Date : Thursday, August 17th 2006 @ 05:30:35 PM
Script : http://www.mydomain.info/forum/forumdisplay.php?f=46
Referrer : http://www.mydomain.info/forum/
IP Address : 75.32.165.174
Username : guest
Classname : vB_Database

[Steve Machol]

Are you still getting this error? If not, then I would consider it a fluke because if you really were missing your post table your forums wouldn't be working.

[Marco van Herwaarden]

The post table is not mentioned in the FROM-clause, so it is unknown within this query.

This is very likely caused by a modification that you have installed. Please turn off the Plugin system and see if that fixes your problem.

[iamnofear]

well, I still get it, I also have the same question with you. I have tried to optimize and repair, It doesn;t help me

[Marco van Herwaarden]

Please see my reply. Repairing the database will not fix this problem. It is a problem that is probably caused by a modification you have installed.

[YankForum]

i'm getting exact same database error since last night , 200 database errors have been sent to my email address , i'm using version 4.0.1

[Lynne]

i'm getting exact same database error since last night , 200 database errors have been sent to my email address , i'm using version 4.0.1

You are not getting the exact error since the query is from 3.5 and you are running 4.x. You should start your own thread and post the exact error you are getting so we can help you.