Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 03-22-2006, 02:30 PM
brianvu brianvu is offline
 
Join Date: Feb 2006
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default SQL error ! database error in vbulletin 3.5.4


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 .


Code:
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
Reply With Quote
  #2  
Old 03-22-2006, 08:41 PM
DrewM DrewM is offline
 
Join Date: Oct 2005
Posts: 564
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

have u edited any files any plugins?
Reply With Quote
  #3  
Old 03-22-2006, 09:10 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the post table is not joined....
Reply With Quote
  #4  
Old 03-23-2006, 01:11 PM
brianvu brianvu is offline
 
Join Date: Feb 2006
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Larrysw
have u edited any files any plugins?
i think i have not edited any files or any plugins
Reply With Quote
  #5  
Old 03-23-2006, 04:11 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think maybe you have a plugin linked to the forumdisplay_query_threadid hook that is adding the ",post.pagetext" to the query.
Reply With Quote
  #6  
Old 03-23-2006, 05:19 PM
brianvu brianvu is offline
 
Join Date: Feb 2006
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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:

Code:
$hook_query_fields = ',post.pagetext';
so how can i fix this code . please post a fix code here for me , thanxs people !
Reply With Quote
  #7  
Old 03-23-2006, 05:46 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #8  
Old 03-23-2006, 06:11 PM
brianvu brianvu is offline
 
Join Date: Feb 2006
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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
Reply With Quote
  #9  
Old 03-23-2006, 07:49 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

below:

PHP Code:
$hook_query_fields ',post.pagetext'
a
PHP Code:
$hook_query_joins 'INNER JOIN post ON (post.postid = thread.firstpostid)'
should help
Reply With Quote
  #10  
Old 03-23-2006, 07:55 PM
brianvu brianvu is offline
 
Join Date: Feb 2006
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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 !
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:33 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04158 seconds
  • Memory Usage 2,263KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_code
  • (4)bbcode_php
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete