Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > Advanced Warning System (AWS)
Reload this Page Error, need Help
Register FAQ Community Calendar Today's Posts Search

Closed Thread
 
Thread Tools
Error, need Help Details »»
Error, need Help
Version: , by TRStealth TRStealth is offline
Developer Last Online: Mar 2008 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 03-02-2005 Last Update: Never Installs: 0
 
No support by the author.

I've installed a fresh version of the AWS.

When I try to edit the options, I get the following error:

Code:
Database error in vBulletin 3.0.7:

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

mysql error number: 1054

Date: Wednesday 02nd of March 2005 05:27:41 PM
Script: http://forums.enclave1.net/admincp/admin_warn.php
Referer: http://forums.enclave1.net/admincp/admin_warn.php?act=manageoptions
Username: Stealth
IP Address: xx.xx.xx.xx

Show Your Support

  • If you like to thanks you by the author -> Click Thanks to the Author
  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 03-02-2005, 07:58 PM
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Location: Landen(Belgium)
Posts: 1,335
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by TRStealth
I've installed a fresh version of the AWS.

When I try to edit the options, I get the following error:

Code:
Database error in vBulletin 3.0.7:

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

mysql error number: 1054

Date: Wednesday 02nd of March 2005 05:27:41 PM
Script: http://forums.enclave1.net/admincp/admin_warn.php
Referer: http://forums.enclave1.net/admincp/admin_warn.php?act=manageoptions
Username: Stealth
IP Address: xx.xx.xx.xx

the autocomments is missing in your warning_options table you can add it by

Code:
ALTER TABLE warning_options ADD COLUMN autocomments char(3);
  #3  
Old 03-03-2005, 02:21 AM
TRStealth's Avatar
TRStealth TRStealth is offline
 
Join Date: Oct 2002
Posts: 112
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
ok, but now I'm getting this:

Code:
Database error in vBulletin 3.0.7:

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

mysql error number: 1054

Date: Thursday 03rd of March 2005 04:18:56 AM
Script: http://www.enclave1.net/forums/admincp/admin_warn.php
Referer: http://www.enclave1.net/forums/admincp/admin_warn.php?act=manageoptions
Username: Stealth
IP Address: xx.xx.xx.xx
  #4  
Old 03-03-2005, 05:57 AM
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Location: Landen(Belgium)
Posts: 1,335
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
hi,

those database fields where added agers always use the latest zip .... whet version of aws do you have ? you need to update i guess

Code:
ALTER TABLE warning_options ADD COLUMN collector int(10) UNSIGNED;
download the latest zip and look in install_warn.php there you can find these things
  #5  
Old 03-03-2005, 02:08 PM
TRStealth's Avatar
TRStealth TRStealth is offline
 
Join Date: Oct 2002
Posts: 112
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I just installed 3.1.8

[Edit]
Thanks for the help, I just ran the query to create a table again for warning_options, it seems to be working.
  #6  
Old 03-03-2005, 03:14 PM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thanks for helping me out Delphi!

My question however, is why were not these columns created with the initial installation. Let me check the file again. Everything seems to be OK.

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 04:45 PM.

Contact Us - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.9.0
Copyright ©2000 - 2017, vBulletin Solutions Inc.