Error, need Help

I've installed a fresh version of the AWS.

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

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

[Delphiprogrammi]

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:

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

ALTER TABLE warning_options ADD COLUMN autocomments char(3);

[TRStealth]

ok, but now I'm getting this:

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

[Delphiprogrammi]

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

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

[TRStealth]

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.

[sv1cec]

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