View Single Post
  #150  
Old 06-17-2012, 11:13 AM
Akyeame Kwame Akyeame Kwame is offline
 
Join Date: May 2008
Posts: 111
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hello, I'm getting this error. I originally tried the file edits then came to the end page and saw that file edits. Both ways gave me the same DB error. Any idea what may be causing it?

I'm using my open forum ID 855 like this

855|*
I'd like all the forums to display.

Code:
Database error in vBulletin 4.1.11:

Invalid SQL:

	SELECT COUNT(*) AS threads,
	(
		SELECT COUNT(*) AS newthread
		FROM thread AS thread
		WHERE forumid = 855
		AND lastpost > 1339934749
		AND open <> 10
		AND sticky = 0
		
		 AND visible IN (0,1,2)
		
		
		
		*/ WHERE forumid > 0 AND  (sticky = 0 OR sticky = 1)    AND visible IN (0,1,2)   
	) AS newthread
	
	FROM thread AS thread
	
	/*
	WHERE forumid = 855
	AND sticky = 0
	
	 AND visible IN (0,1,2)
	
	
	
	*/ WHERE forumid > 0 AND  (sticky = 0 OR sticky = 1)    AND visible IN (0,1,2);

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/ WHERE forumid > 0 AND  (sticky = 0 OR sticky = 1)    AND visible IN (0,1,2)  ' at line 14
Error Number  : 1064
Request Date  : Sunday, June 17th 2012 @ 08:09:49 AM
Error Date    : Sunday, June 17th 2012 @ 08:09:50 AM
Script        : http://www.**********.com/forums/forumdisplay.php?f=855
Referrer      : http://www.************.com/forums/forum.php
Classname     : vB_Database
MySQL Version : 5.1.61
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01123 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete