is a Bug ? all newbie became ADMIN when p
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=23086
Printed Date: 29 March 2026 at 2:48am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: is a Bug ? all newbie became ADMIN when p
Posted By: RAVALON
Subject: is a Bug ? all newbie became ADMIN when p
Date Posted: 10 April 2007 at 2:53pm
|
Hello....
i found a big problem in NEW_POST.ASP file....
i dont' know if appen only in my forum, but after upgrade to 8,05a MySQL version, all newbie that post, became ADMIN member,...
I think the problem was in NEW_POST.ASP file, in this SQL query
i fix problem adding the condition: and Special_Rank=0
so the complete line became
Do you know this problem or appen only in my forum ? And if appen only in mine, do you know why ?
 |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 11 April 2007 at 10:12am
|
The problem you are having is that your groups are not setup correctly, the admin group needs to NOT be a ladder group. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: RAVALON
Date Posted: 11 April 2007 at 3:05pm
|
but IS NOT set as ladder group !
look here ... i put a link of a screenshot of admin panel about group configuration..
http://img402.imageshack.us/img402/1227/groupadminvn0.gif - http://img402.imageshack.us/img402/1227/groupadminvn0.gif
|
Posted By: User123
Date Posted: 11 April 2007 at 4:27pm
|
Did you use the Admin interface to create your groups or did you enter them by hand (or convert them from another system)? If you look a the resulting SQL from that statement it should basically be: select top 1 tblGroup.Group_ID from tblGroup where (tblGroup.Minimum_posts <= ####) and (tblGroupMinimum_posts >=0) order by tblGroup.Minimum_posts desc All non-ladder groups should have a "Minimum_posts" value of -1, this will disqualify them from this query. My bet is your admin group has a minimum_posts value of 0 in the data table even though it's designated as a non-ladder group. |
Posted By: RAVALON
Date Posted: 11 April 2007 at 4:45pm
|
yes.....my admin group have value=0 in Minimum_posts.... and also Guests, Moderator and Newbie have "0"
Think you is this the problem ?
Have i change value in -1 to resolve ?
Have i to change SQL code if i put -1 value or is it sufficient ?
I have -1 in Special_rank field...is this correct for Admin,Moderator and Guests ?
I specify the problem appen when newbie POST a message .... and not became ADMIN immediately...only after he post a message...
maybe the problem is what you say....
|
Posted By: RAVALON
Date Posted: 11 April 2007 at 5:07pm
ok...i update value of Minimum_posts in -1 and Special_rank in 1 and all work !!! 
thanks to all
|
Posted By: User123
Date Posted: 11 April 2007 at 8:57pm
| Glad to hear that worked. You might try added a non-ladder group via the WebWiz admin area and verify it's putting a -1 in the "Minimum_posts" field. I've tried this on mine and it does however if you're using something besides SQL Server as the back end it's possible there is a bug in one of the other areas. |
Posted By: WebWiz-Bruce
Date Posted: 12 April 2007 at 8:14am
|
The different database types use different values for True/False fields:- mySQL True = -1 False = 0 SQL Server True = 1 False = 0 Access True = True False = False These values for these fields are set in the database/database_connection.asp file. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: RAVALON
Date Posted: 12 April 2007 at 3:33pm
now it work fine...thanks to all 
i have a last question but i open a new discussion
|