PDA

View Full Version : SQL error ! database error in vbulletin 3.5.4

brianvu
03-22-2006, 02:30 PM
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
03-22-2006, 08:41 PM
have u edited any files any plugins?
Xenon
03-22-2006, 09:10 PM
the post table is not joined....
brianvu
03-23-2006, 01:11 PM
have u edited any files any plugins?

i think i have not edited any files or any plugins
Paul M
03-23-2006, 04:11 PM
I think maybe you have a plugin linked to the forumdisplay_query_threadid hook that is adding the ",post.pagetext" to the query.
brianvu
03-23-2006, 05:19 PM
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
03-23-2006, 05:46 PM
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
03-23-2006, 06:11 PM
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
03-23-2006, 07:49 PM
below:

$hook_query_fields = ',post.pagetext';

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

should help
brianvu
03-23-2006, 07:55 PM
below:

$hook_query_fields = ',post.pagetext';

a $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 !