Originally Posted by The Realist

BUT..........

I have 1 member already in my banned section and when I run http://www.yourforumsite.com/admincp..._ban_dates.php it says ban_dates table updated from userban but it does not work?

Also I noticed that when I click in admin cp the view banned users it says "The administrator has not specified any groups that contain banned users. Please do so using the usergroup editor" but I have already done this and changed the settings in the warnings options stating what the banned usergroup is.

Any ideas?

Originally Posted by Delphiprogrammi

they work fine ....

Originally Posted by sv1cec

Obviously this column does not exist in your database. Why? I have no idea. Did you try installing from scratch? Did you upgrade from an earlier version?

In any case, you can add that column, by using the following query:

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN textbutoption char(10)

Rgds

Originally Posted by sv1cec

Try using :

ALTER TABLE etc. (add the word TABLE, after ALTER)

I've uploaded a new zip with the queries corrected.

Rgds

Originally Posted by Kruppa

Hi, I saw someone posted his error and solved it by adding the missing column. But I<m not sure if mine requires a char(10):


Database error in vBulletin 3.0.6:

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

mysql error number: 1054



So I'm I looking at:

ALTER TABLE `warning_options` ADD COLUMN modoption (then what?)


If anyone has any ideas, please share. It was so long to install all of this to be snipped at the final step.