Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Active Topics SQL bug?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Active Topics SQL bug?

 Post Reply Post Reply
Author
email View Drop Down
Newbie
Newbie


Joined: 23 March 2003
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote email Quote  Post ReplyReply Direct Link To This Post Topic: Active Topics SQL bug?
    Posted: 04 June 2003 at 8:20am

 

Here's the problem that I'm having.  This used to work on 7.0 Beta 4 (Access Version) but now on 7.01 (SQL) final it is not working.

When clicking on Active Topics the forum(s) that I setup for REGISTERED USERS on Forum Access are NOT being displayed even if I am already logged in and I am a Forum Member.

If I configure it like THIS... it doesn't show on active topics. If I give Forum access to ALL then of course it works.
Generic Forum Permissions
Forum Access: Registered Users
Post New Topics: Registered Users
Reply To Posts:
Registered Users
Edit Posts: Registered Users
Delete Posts: Forum Admin's Only
Sticky Topics: Forum Admin's Only
Create Poll's: Forum Admin's Only
Vote in Poll's: Forum Admin's Only
Upload Images in Posts:
Only enable this function if you have first setup the upload configuration, if your web space supports it.
Forum Admin's Only
Attach Files to Posts:
Only enable this function if you have first setup the upload configuration, if your web space supports it.
Forum Admin's Only
Password:
If you want this forum password protected place the password here. Otherwise leave it blank.



Edited by email
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: 04 June 2003 at 8:32am
Yep thats right that is the way it works on Access and SQL server versions, there is no dieffernce in the code base.

Edited by -boRg-
Back to Top
email View Drop Down
Newbie
Newbie


Joined: 23 March 2003
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote email Quote  Post ReplyReply Direct Link To This Post Posted: 04 June 2003 at 8:34am

 

Shouldn't it show if I'm a Registered User?

 

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: 04 June 2003 at 8:40am
The active topics page doesn't look at permisions on individual users or groups as it was found that it made the page to slow and resource intensive.
Back to Top
email View Drop Down
Newbie
Newbie


Joined: 23 March 2003
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote email Quote  Post ReplyReply Direct Link To This Post Posted: 04 June 2003 at 8:42am

 

Got it... So it's that way by design...thanks a lot Borg.

 

Back to Top
Zamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 27 February 2003
Location: Netherlands
Status: Offline
Points: 95
Post Options Post Options   Thanks (0) Thanks(0)   Quote Zamal Quote  Post ReplyReply Direct Link To This Post Posted: 04 June 2003 at 11:32am
There is a mod for the active topics page which looks at the grouppermission settings. You can find it in the mod forum
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: 04 June 2003 at 11:41am
I had a look at that but never mangaed to get it to work correctly.
Back to Top
Zamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 27 February 2003
Location: Netherlands
Status: Offline
Points: 95
Post Options Post Options   Thanks (0) Thanks(0)   Quote Zamal Quote  Post ReplyReply Direct Link To This Post Posted: 04 June 2003 at 4:15pm
The mod I made works only for Access because I only modified the query in active_topics.asp, and not the corresponding one in the stored procedure for the MSSQL version.
Also for it to work correctly it is required that grouppermissions are set for each group for each forum.
Back to Top
 Post Reply Post Reply

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.