vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/showthread.php?t=71992)

Ganon 02-01-2005 03:51 PM

Quote:

Originally Posted by sv1cec
Can't work without them, can it?

Let me know if you have problems.

I re-ran the installer and double checked the install file and they're still not there..... Is there a way I can manually add them? The installer said it did, but they're not there.

sv1cec 02-01-2005 04:21 PM

Quote:

Originally Posted by Ganon
I re-ran the installer and double checked the install file and they're still not there..... Is there a way I can manually add them? The installer said it did, but they're not there.

That's wierd. Are you sure you are running the install in the standard style? Are you sure you do not have a template category called "Advanced Warning System Templates"? It's towards the end of the list.

Rgds

Ganon 02-01-2005 04:29 PM

It said it added it to all styles, but I guess I can check each individual style to see if for some reason it installed to one but not the others.

EDIT: I found one style that has the group in there, but all that's in the group is a template called warn, which I'm guessing isn't enough, since the install file said there's 20 of them total.

sv1cec 02-01-2005 05:52 PM

Quote:

Originally Posted by Ganon
It said it added it to all styles, but I guess I can check each individual style to see if for some reason it installed to one but not the others.

EDIT: I found one style that has the group in there, but all that's in the group is a template called warn, which I'm guessing isn't enough, since the install file said there's 20 of them total.

I am not sure what to tell you. There should be 22 templates in there. Some how I think it has to do with the fact that you have more than one styles. The hack is designed to install the templates and everything in the style with id equals to $vboptions[styleid]. I am not sure what will happen if that's not the case, or if you have more styles.

I am sure there was a post which explained these issues some time at the beginning of this thread, so I would suggest you find all the patience you can get and start going over the pages, looking for some help. I can't assist you on that, as I have only one style on my system and I am not sure how the styles work.

Rgds

mikexxx 02-01-2005 06:17 PM

This is wat I get if I update form 3.1.1 to 3.1.5 (upgrade_warn.php)

Database error in vBulletin 3.0.6:

Invalid SQL: alter table warnings
add `warned_status` char(1), add `removed_by` int(15), add `removed_date` int(15)
mysql error: Duplicate column name 'warned_status'

mysql error number: 1060

sv1cec 02-02-2005 03:53 AM

Quote:

Originally Posted by mikexxx
This is wat I get if I update form 3.1.1 to 3.1.5 (upgrade_warn.php)

Database error in vBulletin 3.0.6:

Invalid SQL: alter table warnings
add `warned_status` char(1), add `removed_by` int(15), add `removed_date` int(15)
mysql error: Duplicate column name 'warned_status'

mysql error number: 1060

Please read the instructions carefully. Upgrade_warn.php is to upgrade from ZT hack to mine.

Read the UpgradeToLatestVersion.txt file on how to upgrade from one version to the next.

JazzleBug 02-02-2005 06:50 AM

Having a bit of trouble here with...

mysql error: Unknown column 'textbutoption' in 'field list'

Everything is working with the exception of the Manage Warning Options in my ACP.

Code:

Database error in vBulletin 3.0.6:

Invalid SQL: update warning_options set
        hierarchical='Yes',
        automatic='No',
        automaticpm='No',
        autocomments='No',
        warner='1',
        automatic_warner='',
        collector='',
        banned_limit='14',
        points_before_banned='6',
        warnings_before_banned='0',
        banned_usergroup_id='8',
        troll_usergroup_id='8',
        protected_usergroups='6',
        aprotected_usergroups='',
        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'
        where oid='1'
mysql error: Unknown column 'textbutoption' in 'field list'

mysql error number: 1054

Anyone have any thoughts?

Steph

JazzleBug 02-02-2005 05:36 PM

Got antsy and worked it out myself. I think it was a little too easy. :o

Code:

ALTER TABLE `warning_options` ADD COLUMN  textbutoption char(10) AFTER  warnings_per_page
Killer script. Thanks so much!

sv1cec 02-02-2005 05:36 PM

Quote:

Originally Posted by JazzleBug
Having a bit of trouble here with...

mysql error: Unknown column 'textbutoption' in 'field list'

Everything is working with the exception of the Manage Warning Options in my ACP.

Code:

Database error in vBulletin 3.0.6:

Invalid SQL: update warning_options set
        hierarchical='Yes',
        automatic='No',
        automaticpm='No',
        autocomments='No',
        warner='1',
        automatic_warner='',
        collector='',
        banned_limit='14',
        points_before_banned='6',
        warnings_before_banned='0',
        banned_usergroup_id='8',
        troll_usergroup_id='8',
        protected_usergroups='6',
        aprotected_usergroups='',
        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'
        where oid='1'
mysql error: Unknown column 'textbutoption' in 'field list'

mysql error number: 1054

Anyone have any thoughts?

Steph

Obviously this column does not exist in your database. Why? I have no idea. Did you try installing from scratch? Did you upgrade from an earlier version?

In any case, you can add that column, by using the following query:

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN textbutoption char(10)

Rgds

sv1cec 02-02-2005 05:37 PM

From now on, please use this link to go to AWS special forum.

https://vborg.vbsupport.ru/forumdisplay.php?f=105

Post your questions there, as new threads.

Thank you


All times are GMT. The time now is 03:54 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.03469 seconds
  • Memory Usage 1,755KB
  • 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
  • (3)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete