Helpful Information
 
 
Category: Advanced Warning System (AWS)
re-install error

After upgrading to vb 3.0.6 and then trying to update the script I get the following error when clicking on the manage warning error in the admincp:


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

mysql error number: 1054


So I tried running the uninstall script to do a fresh install and get this error:

Invalid SQL: ALTER TABLE `user`
DROP COLUMN `warnings`,
DROP COLUMN `warning_level`,
DROP COLUMN `warning_bans`
mysql error: Can't DROP 'warnings'. Check that column/key exists

mysql error number: 1091


How can I get around this to do a fresh install?

After upgrading to vb 3.0.6 and then trying to update the script I get the following error when clicking on the manage warning error in the admincp:


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

mysql error number: 1054


So I tried running the uninstall script to do a fresh install and get this error:

Invalid SQL: ALTER TABLE `user`
DROP COLUMN `warnings`,
DROP COLUMN `warning_level`,
DROP COLUMN `warning_bans`
mysql error: Can't DROP 'warnings'. Check that column/key exists

mysql error number: 1091


How can I get around this to do a fresh install?
If you are using the uninstaller from the latest zip file, it shouldn't stop at these errors. Try downloading the latest zip, upload all the files, and then run the uninstaller. Let me know if it works.

Rgds

Thank you. I got it installed. Had one other little error about 'warnings' missing, but the following post fixxed it: http://www.vbulletin.org/forum/showthread.php?t=75789&highlight=Unknown+column+%27warnings%27+%27field+list%27

Thank you again. The mods love this hack.

Glad you got it solved.

Rgds










privacy (GDPR)