PDA

View Full Version : re-install error


danrak
14 Feb 2005, 05:49
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?

sv1cec
14 Feb 2005, 08:52
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

danrak
15 Feb 2005, 05:35
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.

sv1cec
15 Feb 2005, 13:14
Glad you got it solved.

Rgds