vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Advanced Warning System (Beta Version) (https://vborg.vbsupport.ru/showthread.php?t=95921)

sv1cec 03-24-2006 05:34 AM

Delphi, check this out https://vborg.vbsupport.ru/showpost....&postcount=740

Delphiprogrammi 03-24-2006 06:55 AM

Quote:

Originally Posted by sv1cec

yeah i did that automatic warning work fine from private messages but they refuse to work from post / threads i already did that step described there.I even disabled all other products i have installed to sensure it isn't conflicting nope it's insane

Borisch 03-24-2006 07:16 AM

Hey,

I've been trying to get this one working all night but to no avail. All the files have been uploaded correctly and the templates have been changed accordingly. The problem is when installing the xml file. It seems as though none of the tables are created. At first I figured that it might be so that it stops on some SQL (ie a table already exists) and doesn't resume. However, this happens even if I make sure that there are no offending tables and columns in the database.

So I tried creating the tables and columns manually by simply executing the sql that the installation is supposed to take care of. However, this doesn't help since I still can't warn anyone. I get errors that the column doesn't exist.

Here is an excerpt of errors I get:

This is what I get when trying to warn someone:
Code:

Database error in vBulletin 3.5.3:
 
Invalid SQL:
update user set warning_level='4', warnings='1' where userid='111';
 
MySQL Error  : Unknown column 'warnings' in 'field list'

This is what I get when trying to view some statistics in the control panel:
Code:

Database error in vBulletin 3.5.3:
 
Invalid SQL:
SELECT COUNT(*) AS users FROM user AS user where warnings>0 OR alerts>0;
 
MySQL Error  : Unknown column 'warnings' in 'where clause'

And so on and so forth. Now, some things works. I can add different warning types and change options and such. But I have no idea where this values are saved. If I create a warning type, it's not saved in the warning_types table as it is completely empty at all times. Even searching for the warning type in the database turns up empty. It's very strange and I have no idea what might be causing this. Has anyone else experienced these kinds of issues and been able to solve them somehow?

As can be seen from the error messages, I'm running vB 3.5.3. I'm also using the latest files posted in this thread.

sv1cec 03-24-2006 08:53 AM

Delphi,

Try using this plugin instead of the standard "AWS: Check Post-Title/Message for censored Words" one. Also, try using this functions_warning.php file, I do not remember if I've done any changes to it.

sv1cec 03-24-2006 08:53 AM

Are you using a table prefix, by any chance?

Borisch 03-24-2006 10:06 AM

Where do I check that?

EDIT: Nevermind, in config.php obviously. It's empty, so no, I', not using a table prefix.

What's really baking my noodle is why isn't the installer creating the proper tables? Is there some log which I can check for errors?

Delphiprogrammi 03-24-2006 10:50 AM

Quote:

Originally Posted by Borisch
Where do I check that?

EDIT: Nevermind, in config.php obviously. It's empty, so no, I', not using a table prefix.

What's really baking my noodle is why isn't the installer creating the proper tables? Is there some log which I can check for errors?

you could try and open product-aws.xml and just before the SQL queries put this code

PHP Code:

$db->reporterror=

that should show you all errors occuerd when tryting to import the product.Do the same in the unistall code.When you get an error message from MySQL post it here .....

Delphiprogrammi 03-24-2006 10:53 AM

Quote:

Originally Posted by sv1cec
Delphi,

Try using this plugin instead of the standard "AWS: Check Post-Title/Message for censored Words" one. Also, try using this functions_warning.php file, I do not remember if I've done any changes to it.

thank you John but it still refuses to work it's insane not your fault and not that big problem either.I think it has something todo with vbportal just guessing here but it worked fine before i purchased and installed vbportal

Borisch 03-24-2006 12:06 PM

Quote:

Originally Posted by Delphiprogrammi
When you get an error message from MySQL post it here .....

Thanks for putting effort into helping me. However, I'm sad to admit that I don't get any error messages. At least not immediat errors. Are these errors supposed to show while your installing or in some log? The installation just looks as previously, ie. as it's supposed to look I presume.

GoTTi 03-25-2006 12:05 AM

question: this is upgradeable from 3.0.x correct?

if yes, whats the details on that for upgrading.

if no, what should i do about the current version of aws on my 308?


All times are GMT. The time now is 01:21 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.02329 seconds
  • Memory Usage 1,747KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (4)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