vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/forumdisplay.php?f=105)
-   -   re-install error (https://vborg.vbsupport.ru/showthread.php?t=76291)

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

Code:
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:
Code:
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 02-14-2005 06:52 AM
Quote:
Originally Posted by danrak
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:

Code:
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:
Code:
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 02-15-2005 03:35 AM
Thank you. I got it installed. Had one other little error about 'warnings' missing, but the following post fixxed it: https://vborg.vbsupport.ru/showthrea...7field+list%27

Thank you again. The mods love this hack.

sv1cec 02-15-2005 11:14 AM
Glad you got it solved.

Rgds


All times are GMT. The time now is 10:39 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01002 seconds
  • Memory Usage 1,724KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete