Thread: Forum Display Enhancements - Global Threads for VB4
View Single Post
  #24  
Old 02-01-2011, 02:32 PM
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
Senior Member
 
Join Date: Jun 2008
Location: New York
Posts: 10,610
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Taurus1 View Post
I am getting the following database error with this enabled:

Database error in vBulletin 4.1.1:

Invalid SQL:

SELECT
...

MySQL Error : Unknown column 'modification.mod_installcount' in 'field list'
Error Number : 1054
Request Date : Tuesday, February 1st 2011 @ 05:38:58 AM
Error Date : Tuesday, February 1st 2011 @ 05:38:58 AM
Script : http://creativx.net/forums/forumdisplay.php?f=25
Referrer : http://creativx.net/forums/
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.54

Please help.
Hi, I see the problem... I forgot to remove 1 hook from the code and another modification you have is interfering with the query.

I will release an update to fix this bug shortly. In the mean time if you want to fix it you can go to Plugin Manager -> Edit the plugin titled: Query Global Threads
Find this line:
Code:
$hook_query_fields
And simply erase it, hit save, and it should work.

Or wait for my next update later today.

Quote:
Originally Posted by BadgerDog View Post
Installed on 4.04pl1 for testing with thanks ... :up:

Regards,
Doug

Edit: Set-up as per instructions (see attached pic), added "Global Messages Forum" and ENABLED mod.

Created a post in the new "Global Messages Forum" and hit submit ....

Nothing appears in any of the forums specified, however post appears in "Global Messages Forum".
Is the mod still enabled? If so please give me the forumid of your global forum. I will take a look.

My guess off hand is you have the permissions set wrong- users need to be able to view the forum and threads... here is a screenshot of proper forum permissions:
Attached Images
File Type: jpg permissions_ss.jpg (111.5 KB, 0 views)
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01107 seconds
  • Memory Usage 1,793KB
  • Queries Executed 12 (?)
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_attachment
  • (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_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete