PDA

View Full Version : Error, need Help


TRStealth
03-02-2005, 03:29 PM
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
03-02-2005, 07:58 PM
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
03-03-2005, 02:21 AM
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
03-03-2005, 05:57 AM
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
03-03-2005, 02:08 PM
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
03-03-2005, 03:14 PM
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