View Single Post
  #146  
Old 02-19-2005, 05:10 PM
TunerNetwork TunerNetwork is offline
 
Join Date: Jul 2004
Location: CT
Posts: 153
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok bud, thanks, that worked! now...I get this....

Database error in vBulletin 3.0.6:

Invalid SQL:
ALTER TABLE `user` ADD `teamid` INT( 10 ) DEFAULT '1' NOT NULL ,
ADD `teamadmin` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `team_chat_pref_font_face` VARCHAR( 255 ) NOT NULL ,
ADD `team_chat_pref_font_color` VARCHAR( 255 ) NOT NULL ,
ADD `team_chat_pref_user_ignore` TEXT NOT NULL ,
ADD `team_chat_pref_status` VARCHAR( 10 ) NOT NULL ,
ADD `team_chat_pref_auto_on` TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD `team_chat_pref_auto_msg` VARCHAR( 255 ) NOT NULL ;

mysql error: Duplicate column name 'teamid'

mysql error number: 1060

So...then I try to add a new team and I get this:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT *
FROM forum
WHERE `teamid` !=0

mysql error: Unknown column 'teamid' in 'where clause'

mysql error number: 1054

If someone can please just help me get this damn hack working,lol. Ive tried alot to get it going and need it for my site. So please pm me if you can help, thanks!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01120 seconds
  • Memory Usage 1,761KB
  • 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)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