View Single Post
  #998  
Old 07-07-2004, 05:47 PM
noppid noppid is offline
 
Join Date: Mar 2003
Location: Florida
Posts: 1,875
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

After upgrading to 3.0.2 it seems that the tables for setting and settinggroup were recreated. At least the vbgarage options were no longer in them.

Here's how we enabled it again.

Backup your DataBase First!

edit init.php to this...

PHP Code:
    // Reputation

    
'canseeownrep'             => 256,
    
'canuserep'                => 524288,
    
'canhiderep'               => 1048576,
    
'cannegativerep'           => 2097152,
    
'canseeothersrep'          => 4194304,
    
'canhaverepleft'           => 8388608,
    
// START VBGARAGE HACK
    
'canvbgarage'              => 16777216
    
// END VBGARAGE HACK    
); 
This leaves the vB options in their correct places.

Next run these five queries to repair the vbulletin option menu. We did it in phpmyadmin and do not have table prefixes, if you have table prefixes you must edit the table names.

[sql]
INSERT INTO settinggroup (grouptitle, displayorder, volatile) VALUES ('vbgarage', '650', 1);

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('vbgenable', 'vbgarage', '1', '1', 'yesno', 10, 0, 1);

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('vbgcomments', 'vbgarage', '1', '1', 'yesno', 20, 0, 1);

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('vbgmaxupload', 'vbgarage', '6', '6', '', 30, 0, 1);

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('vbgmaxfilesize', 'vbgarage', '200000', '200000', '', 40, 0, 1);

[/sql]

All of the queries are from the install script.

Good Luck.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01286 seconds
  • Memory Usage 1,773KB
  • 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_php
  • (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