Web Wiz Support and Community Forums : moderator sees two forums instead of one

Web Wiz Support and Community Forums : moderator sees two forums instead of one https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 10:21:54 +0000 Mon, 26 Jun 2006 09:48:19 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19760 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[moderator sees two forums instead of one : If you go to the admin control...]]> https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post109597.html#109597 Author: WebWiz-Bruce
Subject: 19760
Posted: 26 June 2006 at 9:48am

If you go to the admin control panel and edit each forum, when you hit the submit button it will recreate the forum permissions.

If this doesn't fix the problem, you will need to delete the permissions in the tblPermissions table in the database and then re-create them in the admin area.
]]> Mon, 26 Jun 2006 09:48:19 +0000 https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post109597.html#109597 <![CDATA[moderator sees two forums instead of one : borg when will this be fixed?...]]> https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post109579.html#109579 Author: ohiopbx
Subject: 19760
Posted: 26 June 2006 at 3:36am

borg when will this be fixed? i just updated to 8.3 and members are still seeing doubles.

do i REALLY have to remove all permissions and re do them?
]]> Mon, 26 Jun 2006 03:36:17 +0000 https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post109579.html#109579 <![CDATA[moderator sees two forums instead of one : The files have been re-written...]]> https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post107311.html#107311 Author: WebWiz-Bruce
Subject: 19760
Posted: 19 May 2006 at 9:49am

The files have been re-written to prevent this and similar problem that should fix the problem.

These re-written files will be in the next release.
]]> Fri, 19 May 2006 09:49:11 +0000 https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post107311.html#107311 <![CDATA[moderator sees two forums instead of one : -boRg- did you found anything...]]> https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post107284.html#107284 Author: moti
Subject: 19760
Posted: 18 May 2006 at 11:36pm

-boRg- did you found anything new ?

is there any way to solve the problem ?

]]> Thu, 18 May 2006 23:36:46 +0000 https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post107284.html#107284 <![CDATA[moderator sees two forums instead of one : the main problem is that , this...]]> https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post106865.html#106865 Author: moti
Subject: 19760
Posted: 13 May 2006 at 9:54am

the main problem is that , this is not application related problem, this is database problem, after converting something cause the problem,

meanwhile, this is not just in default.asp page this is for all page that include forums list, like forum jumps, search form, move topic and ...

I tested this, If you use a new database ( not converted from 7.9 to 8 ) it works fine but if you use converted version ....

]]> Sat, 13 May 2006 09:54:27 +0000 https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post106865.html#106865 <![CDATA[moderator sees two forums instead of one : I have already been working on...]]> https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post106832.html#106832 Author: WebWiz-Bruce
Subject: 19760
Posted: 12 May 2006 at 10:31am

I have already been working on the code on this page to fix a similar issue which should also clear this issue up as well.]]> Fri, 12 May 2006 10:31:43 +0000 https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post106832.html#106832 <![CDATA[moderator sees two forums instead of one : I think taht this is result of...]]> https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post106831.html#106831 Author: venki
Subject: 19760
Posted: 12 May 2006 at 10:25am

I think taht this is result of SQL query to database..

Borg has used this in 'default.asp' to get forum..

ex:

"FROM " & strDbTable & "Category" & strDBNoLock & ", " & strDbTable & "Forum" & strDBNoLock & ", " & strDbTable & "Permissions" & strDBNoLock & ", " & strDbTable & "Author" & strDBNoLock & " " & _
"WHERE " & strDbTable & "Category.Cat_ID = " & strDbTable & "Forum.Cat_ID " & _
"AND " & strDbTable & "Forum.Forum_ID = " & strDbTable & "Permissions.Forum_ID " & _
"AND " & strDbTable & "Forum.Last_post_author_ID = " & strDbTable & "Author.Author_ID " & _
"AND (" & strDbTable & "Permissions.Author_ID = " & lngLoggedInUserID & " OR " & strDbTable & "Permissions.Group_ID = " & intGroupID & ") " & _
"ORDER BY " & strDbTable & "Category.Cat_order, " & strDbTable & "Forum.Forum_Order, " & strDbTable & "Permissions.Author_ID DESC;"

so he has used WHERE ... = ... and this will give 2 results if that user has group AND individual permission for that forum.

It would need to be done as in 'active_topics.asp' like others pages by SELECT IN.. I had same problem whit my MODs and this has fixed problem.

ex:

"FROM " & strDbTable & "Forum" & strDBNoLock & ", " & strDbTable & "Topic" & strDBNoLock & ", " & strDbTable & "Thread" & strDBNoLock & ", " & strDbTable & "Thread AS LastThread" & strDBNoLock & ", " & strDbTable & "Author" & strDBNoLock & ", " & strDbTable & "Author AS LastAuthor" & strDBNoLock & " " & _
"WHERE " & strDbTable & "Forum.Forum_ID = " & strDbTable & "Topic.Forum_ID " & _
"AND " & strDbTable & "Thread.Author_ID = " & strDbTable & "Author.Author_ID " & _
"AND LastThread.Author_ID = LastAuthor.Author_ID " & _
"AND " & strDbTable & "Topic.Start_Thread_ID = " & strDbTable & "Thread.Thread_ID " & _
"AND " & strDbTable & "Topic.Last_Thread_ID = LastThread.Thread_ID " & _
"AND LastAuthor.Author_ID = " & intLastPostsUserID & " "
strSQL = strSQL & _
"AND (" & strDbTable & "Topic.Forum_ID " & _
  "IN (" & _
   "SELECT " & strDbTable & "Permissions.Forum_ID " & _
   "FROM " & strDbTable & "Permissions " & strDBNoLock & " " & _
   "WHERE (" & strDbTable & "Permissions.Group_ID = " & intGroupID & " OR " & strDbTable & "Permissions.Author_ID = " & lngLoggedInUserID & ") " & _
    "AND " & strDbTable & "Permissions.View_Forum = " & strDBTrue & _
  ")" & _
")"

Hope Borg try to rewrite SQL for default.asp page to fix this bug.

]]> Fri, 12 May 2006 10:25:30 +0000 https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post106831.html#106831 <![CDATA[moderator sees two forums instead of one : I have the same problem... ]]> https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post106627.html#106627 Author: AnaMaria
Subject: 19760
Posted: 09 May 2006 at 8:16pm

I have the same problem...]]> Tue, 09 May 2006 20:16:42 +0000 https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post106627.html#106627 <![CDATA[moderator sees two forums instead of one : Borg I found somthing, this...]]> https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post106622.html#106622 Author: moti
Subject: 19760
Posted: 09 May 2006 at 6:30pm

Borg I found somthing,

this is sample of my permissions table, look :

the red color is group permission and grean color is individual permissions

I see the forum ID 38 multiple times in forums main page, so I went to delete one of the records in the permissions table ( in white color )

If I delete the record from group permissions every thing become ok and the forum just appear one time but in this group nobody have access to this forum , and If I delete record from individual permission every thing become ok too, but my moderator doesn't have access to this forum,

so Borg this maybe is a bug in the forum application,

Thanks

Edited by moti - 09 May 2006 at 8:28pm]]> Tue, 09 May 2006 18:30:21 +0000 https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post106622.html#106622 <![CDATA[moderator sees two forums instead of one : I shall have to try a replicate...]]> https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post106581.html#106581 Author: WebWiz-Bruce
Subject: 19760
Posted: 09 May 2006 at 9:03am

I shall have to try a replicate the problem and see if I can get the same issue when individual forum permissions are used.]]> Tue, 09 May 2006 09:03:39 +0000 https://forums.webwiz.net/moderator-sees-two-forums-instead-of-one_topic19760_post106581.html#106581