View Single Post
  #3  
Old 05-02-2005, 07:01 PM
Vman Vman is offline
 
Join Date: Apr 2004
Posts: 167
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I got the "Warn.php" file to work, but the sql is still not working right here is the error Im getting about I did what you said above:

SQL-query:

ALTER TABLE " . TABLE_PREFIX . "user ADD COLUMN warnings int( 5 ) default '0'

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "user ADD COLUMN warnings int(5) default '0'

I have uninstalled and installed this hack 4 times to get the exact same errors each time...Im ready to give up and give you full access to see if you can find the problem...hheheheheheh

Thanks for the help

Vman

ALso, if I run the cron "Kill Old Bans" this is the error I get:

Database error in vBulletin 3.0.7:

Invalid SQL: update user set warning_bans=-1 where userid=308
mysql error: Unknown column 'warning_bans' in 'field list'

mysql error number: 1054

Date: Monday 02nd of May 2005 01:02:41 PM
Script: http://www.bodybuildingcentral.net/f...cron&cronid=21
Referer: http://www.bodybuildingcentral.net/f....php?do=modify

I attempted to post a test warning on a member and here is the sql database error Im getting:

Database error in vBulletin 3.0.7:

Invalid SQL: update user set warning_level='1', warnings='1' where userid='242'
mysql error: Unknown column 'warnings' in 'field list'

mysql error number: 1054

Date: Monday 02nd of May 2005 01:21:55 PM
Script: http://www.bodybuildingcentral.net/forums/Warn.php
Referer: http://www.bodybuildingcentral.net/f...rNoPost&id=242
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01043 seconds
  • Memory Usage 1,765KB
  • 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