vb.org Archive - Administrative and Maintenance Tools

Page 61 of 63

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Administrative and Maintenance Tools - Advanced Warning System 3.6.7 (https://vborg.vbsupport.ru/showthread.php?t=124477)

HossMon

01-07-2009 02:11 PM

I'm just upgrading my forums to v3.6 from 3.5 (not going to 3.7 just yet)
I had this installed and working on v3.5. After installing on 3.6 I now get this database error when selecting "Statistics - Warnings Per User" in the ACP

Quote:

Invalid SQL:
SELECT COUNT(*) AS users FROM user WHERE warns > 0 OR alerts > 0 OR warning_bans > 0;

MySQL Error : Unknown column 'warns' in 'where clause'

Any ideas?
As this is just a test upgrade and not my live board, I have time to work thru this problem, but...

sv1cec

01-07-2009 02:38 PM

Try changing that statement to:

Code:

SELECT COUNT(*) AS users FROM user WHERE warnings > 0 OR alerts > 0 OR warning_bans > 0;

HossMon

01-07-2009 04:03 PM

Should I run it as a query or thru PHPmyAdmin?
Also, if I'm reading correctly this is in the User table, correct?

HossMon

01-07-2009 04:12 PM

Actually after further examination I think I see the problem. Though what the "proper" solution is, I'm not so sure of.

From the AWS xml file there is this

Quote:

$install[] = "ALTER TABLE " . TABLE_PREFIX . "user
ADD COLUMN warns INT(5) DEFAULT '0',
ADD COLUMN warning_level INT(15) DEFAULT '0',
ADD COLUMN warning_bans INT(2) DEFAULT '0',
ADD COLUMN alerts INT(5) DEFAULT '0',
ADD COLUMN warn_notes SMALLINT DEFAULT '0'

However in my user table I have a column named warnings
But none named warns

Solved!
SHould anyone else run into this...
In phpmyadmin > select the user table > look for column named warns > tick the box and select/click the "change" operation > rename to warnings and save.

HossMon

01-08-2009 06:46 PM

Hey sv1cec if your around today.
I had all sorts of problems with this version. DB errors and way too many items to list. I'm not complaining, as I love AWS, but I uninstalled it and went back to the 3.5.4 version.
Which I did get to work using TMS and modifying a few of the template edits to work with vB 3.6.9

I have 1 problem that I've found so far. I'm getting the

Quote:

The administrator has not specified any groups that contain banned users.

Please do so using the usergroup editor.

Error in ACP when trying to "View Banned Users". Which after reading thru the 3.5.4 thread I never did see a way to resolve. Is there a solution?

And before I run off, I'd just like to say thanks to both you and Delphi for all the work you two have put into this mod! :tup:

sv1cec

01-08-2009 07:06 PM

Well, I am not sure, there is no such message in the code I've written. so I guess:

1. Make sure there is at least one banned users usergroup.
2. Make sure you enter that usergroup in the appropriate area in the Warning Options, in the Admin CP.

HossMon

01-09-2009 02:53 AM

Thanks John
As it turns out... as in an old thread by yourself that I read after posting this... The link in the ACP > AWS area does not work.
However, the lin in the ACP Users > View Banned Users does!
I can live with that. :D

Thanks again

sv1cec

01-09-2009 07:03 AM

See?! How bright of me to write new code for viewing banned users, when there was already a script doing it? LoRL.

Just go into your admincp and change the link, in the AWS menu to the one that the Users menu points to.

tehPARADOX

01-17-2009 12:42 PM

Does anybody have a working kill_warns script that actually removes matured warnings?

ViciousCode

01-18-2009 05:16 PM

is there a mod like this for 3.7x?

All times are GMT. The time now is 03:20 AM.

Page 61 of 63

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01923 seconds Memory Usage 1,740KB 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 (1)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)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
Messages: