View Single Post
  #2105  
Old 12-29-2004, 11:49 AM
Exernon Exernon is offline
 
Join Date: Oct 2004
Location: 127.0.0.1
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I just bought a licensed copy of vBulletin. And upon installation of vBulletin, I went straight here to get some hacks. I found this one and I got excited about this fine work so I installed it immediately. Well, I installed it successfully (I think), but when I enabled the blocks. A database error occured:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: 
		## GET NEWS ##
		SELECT thread.*,thread.iconid AS threadiconid, threadpost.pagetext AS pagetext,
		threadpost.attach AS attachcount,
		
		
		IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
		FROM thread AS thread
		LEFT JOIN user AS user ON (thread.postuserid = user.userid)
		LEFT JOIN post AS threadpost ON (thread.firstpostid = threadpost.postid)
		LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
		
		
		WHERE forumid IN ()
		AND deletionlog.primaryid IS NULL
		AND forumid NOT IN (0)
		AND thread.open <> 10
		AND thread.visible = '1'
		
		
		ORDER BY  thread.dateline DESC
		LIMIT 0
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 ')
		AND deletionlog.primaryid IS NULL
		AND forumid NOT IN (0)


mysql error number: 1064

Date: Wednesday 29th of December 2004 07:45:01 AM
Script: http://www.xxxxxxx.com/
Referer: 
Username: xxxxx
IP Address: xxx.xxx.xxx.xxx
How do I solve this?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01141 seconds
  • Memory Usage 1,766KB
  • 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