vb.org Archive - Administrative and Maintenance Tools

Page 4 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)

jian	08-23-2006 11:37 AM

It doesn't work properly.

Whenever I try to change something in the admincp for a user, it gives.

Invalid SQL:
UPDATE vb3_user SET
### Bitfield: vb3_user.options ###
options = IF(options & 8, options - 8, options),
etc etc etc
MySQL Error : Unknown column 'warns' in 'field list'

Delphiprogrammi

08-23-2006 04:42 PM

Quote:

Originally Posted by jian

hmmmz your warns field is gone ?

Code:

ALTER TABLE vb3_user ADD COLUMN warns INT(5) DEFAULT '0';

outlaw621

08-23-2006 07:09 PM

Quote:

Originally Posted by Delphiprogrammi

Seems there is indeed a problem.If you login as a normal user (registerd without any special rights) a link should be provided to view your own warnings and this is missing.I just spotted this bug trying to fix it right now

problem found and fixed updating zip file ...

Thank you. Updated and will advise if there are any problems.

sv1cec

08-24-2006 07:41 PM

Hey Delphi, congratulations on this! Nice work!

From what I read, you also added some permission features, good! One thing I changed in my forum site, was that I made the name of the Automatic Warning variable. As you may remember, the old AWS required you to create a warning type called "ObsceneWords", for the automatic warnings. With a few changes, it is now up to the admin to decide how this warning type should be called.

Again, nice work buddy!

Mirage Guardian

08-25-2006 04:58 PM

I did the upgrade & the old warnings sill ok.
But I got this database error:

Quote:

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

now what to do?

Delphiprogrammi

08-25-2006 05:59 PM

Quote:

Originally Posted by Mirage Guardian

I did the upgrade & the old warnings sill ok.
But I got this database error:

now what to do?

you did not reimport the product xml.Wheter you set "allow overwrite to" yes or no my guess is that you didn't touched the products system.Because if you try to add a product that's already there (and allow overwrite is set to no) vbulletin will stop you.....

you need to run

Code:

ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';

and you should be up and running again.That error most likely occources when you click the statistics link (warings per user) in the admincp

valuemdsupport

08-26-2006 08:24 AM

Hi,

Can you please look into my problem. The problem is warnings and alerts aren't correct. When i deleted a warning or an alert, the warnings or the alerts didn't decrease. See the attachment, you'll understand my problem. So, can you please tell me how to fix this by myseft or wait for new updates from you.

Thanks.

chipet

08-26-2006 10:26 PM

PHP Code:


		
			
$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
    <title>$vboptions[bbtitle] - $pagetitle</title>
$headinclude
</head>
<body>
$header
$navbar
<BR>
<if condition="$bbuserinfo[userid]=='0'">


<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
    <td class="tcat" colspan="3">Guest - No Permissions</td>
</tr>
<tr>
    <td class="thead">Unable To View</td>
</tr>
<tr>
    <td class="alt1" colspan="1">$vbphrase[aws_nopermissions]</td>
</tr>
</table>
<br/>

<else />


$warn_page
<br />
</if>

$footer
</body>
</html>

This is the WARN style templet, whats wrong? Because I cant se the warn person text in the threads. :(
should it look like this in the 3.6.0 version?

Delphiprogrammi

08-27-2006 02:25 PM

Quote:

Originally Posted by valuemdsupport

can i ask ? when you deleted the warnings did you used the checkboxes and click the "complete removal" button or did you did you do it through the confirmation pages all one by one.Seems to be working ok here

Delphiprogrammi

08-27-2006 02:27 PM

Quote:

Originally Posted by chipet

PHP Code:


		
			
$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
    <title>$vboptions[bbtitle] - $pagetitle</title>
$headinclude
</head>
<body>
$header
$navbar
<BR>
<if condition="$bbuserinfo[userid]=='0'">
 
 
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
    <td class="tcat" colspan="3">Guest - No Permissions</td>
</tr>
<tr>
    <td class="thead">Unable To View</td>
</tr>
<tr>
    <td class="alt1" colspan="1">$vbphrase[aws_nopermissions]</td>
</tr>
</table>
<br/>
 
<else />
 
 
$warn_page
<br />
</if>
 
$footer
</body>
</html>

This is the WARN style templet, whats wrong? Because I cant se the warn person text in the threads. :(
should it look like this in the 3.6.0 version?

you should only get that error when you are not logged in ... remember to set the proper permissions for each usergroup

All times are GMT. The time now is 01:45 AM.

Page 4 of 63

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01405 seconds Memory Usage 1,779KB 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 (2)bbcode_php_printable (6)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: