SQL error ! database error in vbulletin 3.5.4

[brianvu]

hi all people

my following problems is last month i used the vbb 3.5.3 version . its good , but last weekend i have this vbb database error from the vbulletin mail. now i update the vbb 3.5.3 to 3.5.4 the problem is not fix . please anybody know how can i fix this problem , help me to fix this problem . thanxs for your help and support .

Database error in vBulletin 3.5.4:

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         : Wednesday, March 22nd 2006 @ 03:15:38 PM
Script       : http://www.thuytinh.org/forums/forumdisplay.php?f=32
Referrer     : 
IP Address   : 64.229.16.21
Username     : Unregistered
Classname    : vb_database

[DrewM]

have u edited any files any plugins?

[Xenon]

the post table is not joined....

[brianvu]

Originally Posted by Larrysw

have u edited any files any plugins?

i think i have not edited any files or any plugins

[Paul M]

I think maybe you have a plugin linked to the forumdisplay_query_threadid hook that is adding the ",post.pagetext" to the query.

[brianvu]

Originally Posted by Paul M

I think maybe you have a plugin linked to the forumdisplay_query_threadid hook that is adding the ",post.pagetext" to the query.

can i fix this error in the admin cp paul M
php code forumdisplay_query:

$hook_query_fields = ',post.pagetext';

so how can i fix this code . please post a fix code here for me , thanxs people !

[Paul M]

I had a look with the login details you provided.

This was being caused by a product you have installed called "Hide Hack : version 1.00B2". I have disabled that product which will stop the errors. You should contact the author for a fix.

[brianvu]

Originally Posted by Paul M

I had a look with the login details you provided.

This was being caused by a product you have installed called "Hide Hack : version 1.00B2". I have disabled that product which will stop the errors. You should contact the author for a fix.

so what can i do . can you take the new hide hack version for me paul . i see under your nick . you are the hide hack master coder . :cross-eyed:

please help me paul

[Xenon]

below:

PHP Code:

$hook_query_fields = ',post.pagetext'; 


a

PHP Code:

$hook_query_joins = 'INNER JOIN post ON (post.postid = thread.firstpostid)'; 


should help

[brianvu]

Originally Posted by Xenon

below:

PHP Code:

$hook_query_fields = ',post.pagetext'; 


a

PHP Code:

$hook_query_joins = 'INNER JOIN post ON (post.postid = thread.firstpostid)'; 


should help

look me try xenon ! can you check my 4ru m4 me please xenon . i have send the login fo to you !