Web Wiz
Home
Home		 Hosting Services
Hosting Services		 Knowledgebase
Knowledgebase		 Community and Support Forums
Support Forums		 Customer Login
Customer Login

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

Windows Web Hosting 30 Day Free Trial

Windows Web Hosting 30 Day Free Trial

Windows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.

For more information see our Windows Hosting 30 Day Free Trial page.

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: Poole, England
Status: Offline
Points: 8028 		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.
Find Web Wiz on Facebook
Follow Web Wiz on Twitter
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: Poole, England
Status: Offline
Points: 8028 		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.
Find Web Wiz on Facebook
Follow Web Wiz on Twitter
Back to Top
 Post Reply Post Reply Page  12>
  Share Topic   

Forum Jump Forum Permissions View Drop Down



Become a Fan on Facebook Follow us on Twitter Web Wiz on Google+ Community Forums Web Wiz Blogs Web Wiz News
Company Information | Contact Web Wiz | Terms & Conditions | Privacy Policy

Prices exclude VAT unless otherwise stated - $, € prices shown as a guideline only
Web Wiz Ltd, Unit 10E Dawkins Road Ind. Est, Poole, Dorset, UK, BH15 4JD
Copyright ©2001-2012 Web Wiz - All rights reserved