Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - is a Bug ? all newbie became ADMIN when p
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

is a Bug ? all newbie became ADMIN when p
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132 		Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Topic: is a Bug ? all newbie became ADMIN when p
    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
 
Quote
WHERE (" & strDbTable & "Group.Minimum_posts <= " & lngNumOfPosts & ") AND (" & strDbTable & "Group.Minimum_posts >= 0) "  & _
 
i fix problem adding the condition: and Special_Rank=0
 
so the complete line became
 
Quote WHERE (" & strDbTable & "Group.Minimum_posts <= " & lngNumOfPosts & ") AND (" & strDbTable & "Group.Minimum_posts >= 0) and Special_Rank=0 "  & _
 
Do you know this problem or appen only in my forum ? And if appen only in mine, do you know why ?Confused
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132 		Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Posted: 11 April 2007 at 3:05pm
but IS NOT set as ladder group !Confused
 
look here ... i put a link of a screenshot of admin panel about group configuration..
 
 
 
Back to Top
User123 View Drop Down
Newbie
Newbie


Joined: 11 March 2007
Status: Offline
Points: 38 		Post Options Post Options   Thanks (0) Thanks(0)   Quote User123 Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132 		Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post 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....


Edited by RAVALON - 11 April 2007 at 4:51pm
Back to Top
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132 		Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post Posted: 11 April 2007 at 5:07pm
ok...i update value of Minimum_posts in -1 and Special_rank in 1 and all work !!! Thumbs%20Up
 
thanks to all
Back to Top
User123 View Drop Down
Newbie
Newbie


Joined: 11 March 2007
Status: Offline
Points: 38 		Post Options Post Options   Thanks (0) Thanks(0)   Quote User123 Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.