Helpful Information
 
 
Category: Advanced Warning System (AWS)
3.1.6 Problem

When editing options:

Database error in vBulletin 3.0.6:

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

mysql error number: 1054

Never mind.... figured it out. The 3.1.6 installer does not have the database upgrade in it.

When editing options:

Database error in vBulletin 3.0.6:

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

mysql error number: 1054

Never mind.... figured it out. The 3.1.6 installer does not have the database upgrade in it.
Sorry for that, but as soon as I had zipped the files for upload, my attention was drawn to a bug and didn't double-check everything. Fixed now.

Rgds










privacy (GDPR)