$pnotes are the warn_notes they are embedded into the product (they can be disabled in the settings) you must edit both templates postbit and postbit_legacy if you want them to appaer

how do I add a warning.
I am trying to warn someone but there is nothing to select in "Warning Selection"
I see the attachement https://vborg.vbsupport.ru/attachmen...7&d=1101243281 but how do I add them in the "Warning selection"
Thanks

<a href="http://www.vbulletin.com/forum/showthread.php?p=1209982" target="_blank">http://www.vbulletin.com/forum/showthread.php?p=1209982</a>

anyone with a clue??
(concerns AWS)

admincp => advanced Warning System => manage warning types add at least one(1) non post related ...

that's not true AWS does not interfere with infractions

Looks like you are wrong:
http://www.vbulletin.com/forum/showp...2&postcount=20

I found that a user's warning level was not lowering after 60 day (the maturity date I set. I checked the users account and found that the warning level was at 5, but the warnings were blank (no number). When I tried to correct the issue I received the following db error:

I marked private on some of the user's info. What can I do to repair this problem? Do I go directly into MySQL and add the warns amount?

I am getting the above error message when ever I try to save anything for any person in the User Manager. Could this be related to the 3.5.0 issue I mentioned earlier (below)? From the above error message does it look like the db tables for the warning system didn't update?

nope

infractions working fine .....

hmmmz since more users complain about this type of errors i need to check the system.why on earth is your warns field missing ????

i will check that

normal users can't see anything besides there own warnings (mod and up can see all (if you allow them you can also choose to restrict mods so they can only see warnings they issued themself)

??? :confused:
Was that in response to me?

Let me know if I can be of any help in duplicating the error. Right now I can't make any changes to anyones account or warn anyone because of this error. I am going to try to re-upload 3.6.0 files and reinstall the xml file.

I removed all the aws files and re-uploaded the files from a new download of the aws 3.6.0 zip file. I also reimported the xml file and enabled overwrite. Didn't fix my problem. I also went into vBulletin Options and the version still reported 3.5.0. I noticed that this filed could be edited so I changed 3.5.0 to 3.6.0 and clicked save.

Let me know when you figure out the warn field issue. Thanks!

i have been busy with testing this.The warns field is there every time i install .... I have no idea why yours disappaerd if with database errors on there is no error message

That version number is 3.6.0 by default are you installing the 3.5.x port ? that should be impossible

Well since vBulletin 3.6.0 has this sort of "warning system" I won't be using this any more.

However it was very useful to me until. Don't think this will be much used by 3.6.0 users.

If it is helpful I can give you access to our message board. Feel free to PM me if this would help.

Otherwise, is there a command I can give the database to set everything up correctly?

Not sure if this makes a difference. We are running PHP 5.1.4 - has this mod/upgrade been tested on PHP 5?

No i don't have php 5 availible to test it on.I used to be on a dedicated server however that became a little costly so a while back i downgraded back to shared hosting.And yes it is possible your problem is caused by php 5

beautiful hack love it.Installed..Is there a solution About the avatar i read members talking about it but no one answered...my members wants the avatar to show...but i'll wait for the answer:surprised:

if you want to ALWAYS allow members to keep there avatar simply set the avatar cut off setting to 0 (zero) and submit the form.This setting is under the "additional restrictions" header in the manage warning options page

no more issues for over a week i have taken away the beta tag ooh well issues i'm able to reproduce anyway i mean.

hi, when i try to manage the warning types, i get the following DB error:

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM warning_types ORDER BY warn_points,warn_maturity,warn_name;

MySQL Error : Unknown column 'warn_maturity' in 'order clause'
Error Number : 1054
Date : Saturday, September 23rd 2006 @ 07:25:15 PM
Script : http://www.wrestlepower.net/admincp/...rn.php?do=view
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : My IP
Username : Duff
Classname : vb_database


EDIT: Just noticed i also get a DB error when i try to update a user profile as well. I've uninstalled and re-installed to no avail. Its the same one that has been reported earlier.


Any ideas?

are you uising by any chance PHP 5 ?

nope, 4.4.2 acording to my cpanelx.

Also, dont mean to be rude, but what does that code box actually mean? A lot of the guys asking for help are going to be n00bs like myself, and that means nothing to me. Where do i add the code? do i replace something with that code?

thx... very nice hack to have!

That's SQL code that would "maually" add the things missing (your error messages)todo this you will need to open phpMyAdmin select te database you use hit the "SQL" link paste the code into the textbox and hit go.After that you should get a message like "your query has been excuted successfully"

[sql]
ALTER TABLE warning_types ADD COLUM warning_maturity INT(5);
ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';
[/sql]

Hi Delphiprogrammi,

In this new version, the cron jobs are just deactivating warnings? The users will still see that inactive warnings and i have to remove them from admincp completely if i don't want they can see inactive warnings. Is that right? Sorry, this may be a stupid question but i have to know how it works.

Thanks.

Normal users cannot see inactive warnings and yeah they will still show up in the warning log but only to people who have permissions to view the warning log

thanks for explaining that. Anyway, ive run the queries and still get the db error when i try to manage the warning types as well as the second db error when i try to update a user. I've posted the error details again so you dont have to look for them.

When i try to manage warning types, i get;

Invalid SQL:
SELECT * FROM warning_types ORDER BY warn_points,warn_maturity,warn_name;

MySQL Error : Unknown column 'warn_maturity' in 'order clause'
Error Number : 1054
Date : Monday, September 25th 2006 @ 05:57:42 PM
Script : http://www.wrestlepower.net/admincp/...rn.php?do=view
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : My IP
Username : Duff
Classname : vb_database

and when i try to manage a user, i get;
Invalid SQL:


MySQL Error : Unknown column 'alerts' in 'field list'
Error Number : 1054
Date : Monday, September 25th 2006 @ 05:59:17 PM
Script : http://www.wrestlepower.net/admincp/user.php?do=update
Referrer : http://www.wrestlepower.net/admincp/...do=edit&u=1488
IP Address : My IP
Username : Duff
Classname : vb_database



EDIT: Seem to have figured out the first bit about manage warning types. The SQL code you gave said warning_maturity, yet the error i was getting mentioned warn_maturity, so i simply swapped the warning and replaced it with warn, ran the SQL again and it worked. Still stuck with the user changing problems though.

EDIT2: OK, everything seems to be fine now. Again, just swapped the words from the error message i was getting (alerts) with what you had in the SQL (warns) and it all worked out.





OH FFS, i just cant get this right

Getting an error when i go into the warning log.

Invalid SQL:
SELECT w.*,u.username AS wusername,u.userid AS wuserid,wt.*,wuser.username AS warned_username_v,wuser.userid AS warned_userid_v, ruser.username AS removed_by_v, (w.warned_time+wt.warn_maturity*24*60*60) AS maturitydate FROM
warnings w
LEFT JOIN user wuser ON(wuser.userid=w.warned_user)
LEFT JOIN user u ON(u.userid=w.warned_by)
LEFT JOIN user ruser ON(ruser.userid=w.removed_by)
LEFT JOIN warning_types wt ON(wt.tid=w.warned_warning_id) ORDER BY w.warned_time DESC LIMIT 0, 15;

MySQL Error : Unknown column 'w.removed_by' in 'on clause'
Error Number : 1054
Date : Monday, September 25th 2006 @ 06:14:24 PM
Script : http://www.wrestlepower.net/admincp/...hp?do=viewlogs
Referrer : http://www.wrestlepower.net/admincp/index.php?do=nav
IP Address : MY IP
Username : Duff
Classname : vb_database

you are getting way to much errors . I don't have them :confused: are you sure you run vbulletin 3.6.x with the PHP and MySQL version requirements and the system downloadble here (not in any other thread)

yes, running vB 3.6.0 with PHP 4.42, both of which should be fine

Ive checked back through the thread and cant see where you mentioned what SQL version i should be on, but i'm on 4.1.21-standard

As you said, admin will see all active and inactive alerts, active and inactive warnings of users (absolutely). And users can't see their inactive alerts and inactive warnings, just see their active alerts and active warnings. Right?

My problem is users can see both. How will i fix this? I installed this hack from 3.5.x and just upgraded to aws3.6.1 for vb3.6.1. Did i do somethings wrong?

See attachment you will see my problem. Any helps will be appreciated.

Thank you.

ow that's what you mean that can be hidden to mods only letme construct the condition and test it

edit

look at the two pics that information like the amount of warnings/alerts and the warning level is only viewable to usergroups 5,6,7 (standard vbulletin usergroups) (5 = supermoderators 6=Administrators 7 = moderators)

if that is what you want i will tell you howto do that

Oh, no. That's not what i need from your help. I have 2 problem now.

1. I attempted to completely remove a user's warning via the admin panel choosing "complete removal" as suggested. Although it removed the warning in the admin panel (only 2 warnings show instead of 3), it still shows that the user has 3 warnings??
2. And another user received 4 warnings on 9-27-06. According to the settings, the user should automatically have a 7 day temporary ban after reaching a warning level of 3. However, this user was able to post today and is not banned??

Those are my problems. Can you please check the script or should we have a maintenance script or a cron job script? :confused:

Thank you.

1)your not the first talking about that i will spend some hours to see if i can catch that(also remember that warnings removed by cron are still in the warning log but it will mention it is removed by the cron script)
2)that could be possible with dynamically assigned ipadresses (changes every time you connect to the internet)

edit

again i tested that and in here it is working :surprised: :surprised: the system already uses three cron scripts.I did a testpost where the testuser warninglevel should be above the limit and the system should ban and it did banned my testuser.Also the warningcounters work fine.

Create a temporary admin account and pm me the login details so i can take a look at what's happening at your board

MySQL should be fine but PHP 4.4.2 has known security holes see this for more information

the same comment to you.I'd like to have a look at your board to see what is exactely happening when the reported errors occour

Also ... what do you have in your templates ? (MEMBERINFO,postbit,postbit_legacy)

there is no read me how do i edit the templetes?

the readme is there /docs .....

it works to the version 3.6.2?