View Single Post
  #160  
Old 09-14-2005, 12:58 PM
HO3R HO3R is offline
 
Join Date: Jul 2004
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi

I installed this portal and it really looks awesome
But i got one error and i really hope this one isnt managed before otherwise i'm sorry for remention it

When i use the module: Latest threads and i've edited it little, just the title of the module and some options. when admins check the page then there is no problem but when unregistered or regular members visit it, they get a database error and i receive this email:

Code:
Database error in vBulletin 3.0.7:

Invalid SQL: 
  		SELECT 
  		
  		thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
  		
			
			, post.pagetext AS preview
			
			FROM thread as thread
			
			
			LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
			LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
			
			WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(3,4,5,6,7,8,9,10,11,12,13,30,31,14,15,16,17,33,44,34,42,18,45,46,19,20,21,22,23,36,27,29,47,48,32,35,41,37,38,39,43,40,24,25,26) Array AND deletionlog.primaryid IS NULL 
			ORDER BY lastpost DESC 
			LIMIT 10
	
mysql error: You have an error in your SQL syntax near 'Array AND deletionlog.primaryid IS NULL 
			ORDER BY lastpost DESC 
			LIMIT 10
' at line 15

mysql error number: 1064
Anyone an idea what it is??
Hope someone can help


Greetz
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01131 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