Thread: Major Additions - [DBTech] vBSlider v3 (vB4)
View Single Post
  #47  
Old 01-22-2012, 03:08 AM
Mukashi's Avatar
Mukashi Mukashi is offline
 
Join Date: Jan 2004
Location: Brisbane, Australia
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by DragonByte Tech View Post
Just as a test, set all of the counts for threads and blogs, etc., to 0 and see if it still does it. It shouldn't matter, but just trying to see if its getting hung up in some other way.
Well now, that's very interesting. Turning it on for forumhome and setting all the counts to 0 stops the eternal loading....and instead gives me a mySQL error.

Code:
Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT blog.blogid, blog.title, blog.dateline AS publishdate, blog_text.blogtextid, blog_text.pagetext AS message, attachment.attachmentid as previewimage, contenttype.class
        FROM blog AS blog
        INNER JOIN blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
        LEFT JOIN blog_categoryuser AS cu ON (cu.blogid = blog.blogid)
		LEFT JOIN contenttype as contenttype ON (contenttype.class = 'BlogEntry')
		LEFT JOIN attachment AS attachment ON ( attachment.contentid = blog.blogid ) AND ( contenttype.contenttypeid = attachment.contenttypeid )
        WHERE 1=1
        
        AND blog.dateline <= 1327205138
       	AND thread.postuserid NOT IN (427,6970,6593,13617,13616,13633,14112,14113,22403,24657,25946,26114,26491,27774,27895,36854,39776,44671,44662,44323,45801,45838,45939) 
		GROUP BY blog.blogid
        ORDER BY blog.dateline DESC
        LIMIT 0,0;

MySQL Error   : Unknown column 'thread.postuserid' in 'where clause'
Error Number  : 1054
Request Date  : Sunday, January 22nd 2012 @ 04:05:38 AM
Error Date    : Sunday, January 22nd 2012 @ 04:05:38 AM
Script        : (URLTOTESTFORUMREMOVED)/forum.php
Referrer      : (URLTOTESTFORUMREMOVED)/admincp/index.php?do=head
IP Address    : 186.32.167.66
Username      : (USERNAMEREMOVED)
Classname     : vB_Database
MySQL Version : 5.0.92-community-log
Quote:
Originally Posted by DragonByte Tech View Post
Without having access to the site, I doubt I can help unfortunately.
I can arrange access if you think it would assist.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01644 seconds
  • Memory Usage 1,768KB
  • 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
  • (2)bbcode_quote
  • (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