danrak
02-14-2005, 03:49 AM
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?
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?