Thread: Major Additions - [DBTech] vBActivity & Awards v3 (vB4)
View Single Post
  #591  
Old 06-16-2011, 08:45 AM
DragonByte Tech's Avatar
DragonByte Tech DragonByte Tech is offline
 
Join Date: Feb 2010
Location: Scotland
Posts: 8,814
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by RedTrinity View Post
Hi DB_Tech,

Could you please tell me how to reduce the width of the award/achievement boxes in the postbit? At the moment they are automatically stretching out to the right hand side of the profile bit, as far as possible (see screenshot 1) and I'd like to change it so that they cut off earlier if there is less awards set to display (see screenshot 2) as its a bit messy the way it appears at the moment.

Many thanks in advance for your help
Search for <fieldset in the templates, and edit the vBActivity template that shows up related to postbit

Quote:
Originally Posted by just.b.jealous View Post
hello, after updating to the newest version, and following your instructions, I get an error. I can visit the 'Activity Home' but when I click on any of the links to see 'awards' 'achievements' etc, I get this error. I have re-uploaded over and over, I cannot figure it out. I'm not an inexperienced user to vB or using/troubleshooting mods so I've done the usual attempts to fixing myself- deleting it all, unimporting, reuploading, reimporting, triple-check all notes/readme's.


Code:
Database error in vBulletin 4.1.3:

Invalid SQL:

            UPDATE user
            SET dbtech_vbactivity_excluded_tmp = IF(dbtech_vbactivity_excluded = '1'
                OR FIND_IN_SET(8, membergroupids)
                OR usergroupid IN(8), '1', '0');

MySQL Error   : Unknown column 'dbtech_vbactivity_excluded_tmp' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, June 15th 2011 @ 11:06:25 PM
Error Date    : Wednesday, June 15th 2011 @ 11:06:26 PM
Script        : http://**********.com/vbactivity.php?do=medals
Referrer      : 
IP Address    : ********
Username      : Administrator
Classname     : vB_Database
MySQL Version : 5.1.52
How can I fix this?
I really don't understand why the install code for version 2.1.7 fail on a small percentage of forums.

Did you have any errors appear on screen during install?

Code:
ALTER TABLE user ADD dbtech_vbactivity_excluded_tmp ENUM('0', '1') DEFAULT '0'

Fillip
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01221 seconds
  • Memory Usage 1,769KB
  • 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
  • (2)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