[sv1cec]

Originally Posted by rinkrat

Just installed and when I save my settings in admincp I get

mysql error: Unknown column 'collector' in 'field list'


Database error in vBulletin 3.0.5:

Invalid SQL: update warning_options set
hierarchical='Yes',
automatic='No',
automaticpm='No',
autocomments='No',
warner='8040',
automatic_warner='LGKbot',
collector='rinkrat',
banned_limit='14',
points_before_banned='5',
banned_usergroup_id='17',
troll_usergroup_id='16',
protected_usergroups='6|5|6|7',
aprotected_usergroups='5|6|7',
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='Yes',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='20'
where oid='1'
mysql error: Unknown column 'collector' in 'field list'

mysql error number: 1054

Date: Sunday 09th of January 2005 11:43:33 PM
Script: http://www.letsgokings.com/bbs/admincp/admin_warn.php
Referer: http://www.letsgokings.com/bbs/admin...=manageoptions
Username: RinkRat

Obviously, for some reason that column does not exist in your table. Just add it, with the following SQL query:

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN `collector` int(10) unsigned AFTER warner WHERE oid=1

Remember to remove ".TABLE_PREFIX." if you are not using one.

Also, from your error message, I see that you are not .... following the instructions. The warners and collector are supposed to be user ids not user names.

Also, there is not version column in your table. What version are you trying to install?

Rgds