vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/forumdisplay.php?f=105)
-   -   Error, need Help (https://vborg.vbsupport.ru/showthread.php?t=77338)

TRStealth 03-02-2005 03:29 PM
Error, need Help
 
I've installed a fresh version of the AWS.

When I try to edit the options, I get the following error:

Code:
Database error in vBulletin 3.0.7:

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

mysql error number: 1054

Date: Wednesday 02nd of March 2005 05:27:41 PM
Script: http://forums.enclave1.net/admincp/admin_warn.php
Referer: http://forums.enclave1.net/admincp/admin_warn.php?act=manageoptions
Username: Stealth
IP Address: xx.xx.xx.xx

Delphiprogrammi 03-02-2005 07:58 PM
Quote:
Originally Posted by TRStealth
I've installed a fresh version of the AWS.

When I try to edit the options, I get the following error:

Code:
Database error in vBulletin 3.0.7:

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

mysql error number: 1054

Date: Wednesday 02nd of March 2005 05:27:41 PM
Script: http://forums.enclave1.net/admincp/admin_warn.php
Referer: http://forums.enclave1.net/admincp/admin_warn.php?act=manageoptions
Username: Stealth
IP Address: xx.xx.xx.xx

the autocomments is missing in your warning_options table you can add it by

Code:
ALTER TABLE warning_options ADD COLUMN autocomments char(3);

TRStealth 03-03-2005 02:21 AM
ok, but now I'm getting this:

Code:
Database error in vBulletin 3.0.7:

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

mysql error number: 1054

Date: Thursday 03rd of March 2005 04:18:56 AM
Script: http://www.enclave1.net/forums/admincp/admin_warn.php
Referer: http://www.enclave1.net/forums/admincp/admin_warn.php?act=manageoptions
Username: Stealth
IP Address: xx.xx.xx.xx

Delphiprogrammi 03-03-2005 05:57 AM
hi,

those database fields where added agers always use the latest zip .... whet version of aws do you have ? you need to update i guess

Code:
ALTER TABLE warning_options ADD COLUMN collector int(10) UNSIGNED;
download the latest zip and look in install_warn.php there you can find these things

TRStealth 03-03-2005 02:08 PM
I just installed 3.1.8

[Edit]
Thanks for the help, I just ran the query to create a table again for warning_options, it seems to be working.

sv1cec 03-03-2005 03:14 PM
Thanks for helping me out Delphi!

My question however, is why were not these columns created with the initial installation. Let me check the file again. Everything seems to be OK.

Rgds


All times are GMT. The time now is 11:22 PM.

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.00998 seconds
  • Memory Usage 1,734KB
  • 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
  • (5)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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