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)

sv1cec 01-30-2005 08:53 PM

Quote:

Originally Posted by rh2004
Yeah it was around Dec 1ish when I installed it... so how do I un-install it
apart from use the uninstaller... it will be alot easier

Maybe good if you can add the version you are using in the control panel.. :nervous:


I ran the uninstaller.. and now receive this error when I go to /board/

Code:

Database error in vBulletin 3.0.6:

Invalid SQL: select * from warning_options where oid='1'
mysql error: Table 'xx_forums.warning_options' doesn't exist

mysql error number: 1146

Date: Sunday 30th of January 2005 05:41:09 PM
Script: http:///board/
Referer:
Username: xx
IP Address: xx






Doesn't show me anything...

The uninstaller removes some things, the changes to the files remain. The error is because one of the files is trying to read a table which has been erased by the uninstaller. Now run the installation script and you should be OK, as far as the database is concerned. Then check the .php gfiles and make sure that you have all the necessary changes in them.

rh2004 01-30-2005 09:24 PM

Yeah as I did remove all the old stuff last time from the php files.. trying it now

rh2004 01-30-2005 09:42 PM

OK I cannot log in to run the installer

I have replaced the root and includes files with the default vb ones as I thought it would allow me on there but I still get this error


Code:

Database error in vBulletin 3.0.6:

Invalid SQL: select * from warning_options where oid='1'
mysql error: Table 'xx_forums.warning_options' doesn't exist

mysql error number: 1146

Date: Sunday 30th of January 2005 06:39:30 PM
Script: http:///board/
Referer:
Username: x
IP Address: xx


bahawolf 01-30-2005 10:12 PM

Any solution to my problem?

Ganon 01-30-2005 11:16 PM

I installed the hack, followed all the instructions, but when I hit "warn user" I get a blank page, any ideas?

sv1cec 01-31-2005 03:52 AM

Quote:

Originally Posted by bahawolf
Database error in vBulletin 3.0.5:

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

mysql error number: 1054

I got that updating my AWS Options after upgrading to version 3.1.5

Add the 'collector' column, by running this query:

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN collector int(10) unsigned AFTER warner

Rgds

sv1cec 01-31-2005 03:53 AM

Quote:

Originally Posted by rh2004
OK I cannot log in to run the installer

I have replaced the root and includes files with the default vb ones as I thought it would allow me on there but I still get this error


Code:

Database error in vBulletin 3.0.6:

Invalid SQL: select * from warning_options where oid='1'
mysql error: Table 'xx_forums.warning_options' doesn't exist

mysql error number: 1146

Date: Sunday 30th of January 2005 06:39:30 PM
Script: http:///board/
Referer:
Username: x
IP Address: xx


Replace admincp/index.php as well and try again.

sv1cec 01-31-2005 03:54 AM

Quote:

Originally Posted by Ganon
I installed the hack, followed all the instructions, but when I hit "warn user" I get a blank page, any ideas?

Hover your mouse over the link (or button) and look at the bottom line of your browser to tell me what it says (what link it is pointing to). Most probably you have some mistake there.

Rgds

Delphiprogrammi 01-31-2005 04:28 PM

Quote:

Originally Posted by Ganon
I installed the hack, followed all the instructions, but when I hit "warn user" I get a blank page, any ideas?


that happend to me to i sorted it out by making sure all requirerd templated in the currently used style are there.You only need to edit one style templates manually then you can use this hack to copy templates from one style to another

achtungbaby 01-31-2005 04:39 PM

Hello, impressive hack, just installed. Having a small problem with the user groups feature though. I've altered the default user groups on my board and the AWS is classifying a customized group as "Super Moderator"...my question is, do I need to make a change within the AWS files (and if so, which ones), templates or db?


All times are GMT. The time now is 12:45 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.03602 seconds
  • Memory Usage 1,746KB
  • 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