Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > Advanced Warning System (AWS)
Reload this Page re-install error
FAQ Community Calendar Today's Posts Search

Closed Thread
 
Thread Tools
re-install error Details »»
re-install error
Version: , by danrak danrak is offline
Developer Last Online: Apr 2014 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 02-14-2005 Last Update: Never Installs: 0
 
No support by the author.

After upgrading to vb 3.0.6 and then trying to update the script I get the following error when clicking on the manage warning error in the admincp:

Code:
Invalid SQL: update warning_options set
	hierarchical='Yes',
	automatic='No',
	automaticpm='No',
	autocomments='No',
	warner='0',
	automatic_warner='',
	collector='',
	banned_limit='7',
	points_before_banned='10',
	warnings_before_banned='',
	banned_usergroup_id='8',
	troll_usergroup_id='8',
	protected_usergroups='6',
	aprotected_usergroups='',
	restore_groupid='0',
	incr_ban_days='Yes',
	max_no_bans='3',
	bans_mature='',
	viewoption='All',
	multiple_per_post='Yes',
	send_pm_warning='Yes',
	send_em_warning='No',
	email_on_ban='No',
	historical='Yes',
	allowoffpost='Yes',
	warnings_per_page='10',
	textbutoption='Text',
	modoption='All'
	where oid='1'
mysql error: Unknown column 'automatic' in 'field list'

mysql error number: 1054
So I tried running the uninstall script to do a fresh install and get this error:
Code:
Invalid SQL: ALTER TABLE `user` 
DROP COLUMN `warnings`,
DROP COLUMN `warning_level`, 
DROP COLUMN `warning_bans`
mysql error: Can't DROP 'warnings'. Check that column/key exists

mysql error number: 1091
How can I get around this to do a fresh install?

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 02-14-2005, 06:52 AM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by danrak
After upgrading to vb 3.0.6 and then trying to update the script I get the following error when clicking on the manage warning error in the admincp:

Code:
Invalid SQL: update warning_options set
	hierarchical='Yes',
	automatic='No',
	automaticpm='No',
	autocomments='No',
	warner='0',
	automatic_warner='',
	collector='',
	banned_limit='7',
	points_before_banned='10',
	warnings_before_banned='',
	banned_usergroup_id='8',
	troll_usergroup_id='8',
	protected_usergroups='6',
	aprotected_usergroups='',
	restore_groupid='0',
	incr_ban_days='Yes',
	max_no_bans='3',
	bans_mature='',
	viewoption='All',
	multiple_per_post='Yes',
	send_pm_warning='Yes',
	send_em_warning='No',
	email_on_ban='No',
	historical='Yes',
	allowoffpost='Yes',
	warnings_per_page='10',
	textbutoption='Text',
	modoption='All'
	where oid='1'
mysql error: Unknown column 'automatic' in 'field list'

mysql error number: 1054
So I tried running the uninstall script to do a fresh install and get this error:
Code:
Invalid SQL: ALTER TABLE `user` 
DROP COLUMN `warnings`,
DROP COLUMN `warning_level`, 
DROP COLUMN `warning_bans`
mysql error: Can't DROP 'warnings'. Check that column/key exists

mysql error number: 1091
How can I get around this to do a fresh install?
If you are using the uninstaller from the latest zip file, it shouldn't stop at these errors. Try downloading the latest zip, upload all the files, and then run the uninstaller. Let me know if it works.

Rgds
  #3  
Old 02-15-2005, 03:35 AM
danrak danrak is offline
 
Join Date: Dec 2001
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thank you. I got it installed. Had one other little error about 'warnings' missing, but the following post fixxed it: https://vborg.vbsupport.ru/showthrea...7field+list%27

Thank you again. The mods love this hack.
  #4  
Old 02-15-2005, 11:14 AM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Glad you got it solved.

Rgds
Closed Thread

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 06:42 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03922 seconds
  • Memory Usage 2,230KB
  • Queries Executed 19 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (4)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (3)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete