moderator sees two forums instead of one
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=19760
Printed Date: 11 April 2026 at 10:09am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: moderator sees two forums instead of one
Posted By: moti
Subject: moderator sees two forums instead of one
Date Posted: 08 May 2006 at 12:51am
|
I just convert my database from 7.9 to 8.01 every thing is ok
but one of my moderators told me that he sees his forum ( which he moderate ) twice, (after log-in into his account)
another moderators told me that everything is ok
this forum is my first forum i mean the ID number is 1
other users (registered or guest) see this forum normal and just one forum, but the moderator sees it twice every where even on forum jump menu
I have tested , the files this is not corrupted file, I guess this is database problem maybe a section of my database has corrupted during converting to v8.01
Borg, please tell me what can cause this problem,
this is very important to me, because I can't change my database its about 98 MB ,
|
Replies:
Posted By: moti
Date Posted: 08 May 2006 at 1:21am
|
I found something new :
Its not related to moderators, If i change any of the permissions for a user on this forum ( forum with ID no. 1 on my database ) the user sees the forum twice,
even if I deny all permissions for a user on this forum he/she sees the forum twice,
|
Posted By: WebWiz-Bruce
Date Posted: 08 May 2006 at 10:25am
|
This sometimes happens when upgrading from version 7.x to 8, it is coursed when double entries occur in the tblPermissions table in the database. I have put code in place to try and prevent this, so the first thing to do is delete any individual member permissions, then go through each forum in the admin area, and go to the page where you set the forum name, description, permissions etc. and hit the forms submit button for each forum. This should reset the permissions table for each forum. If this fails to work, then you may need to delete all entries in the tblPermissions table in the database. When you do this, all your forums will disappear from the main forum index, but don't worry, all will be fixed. After doing this, go to the admin section and re-setup all forum permissions. This should fix any issues with forums appearing multiple times. ------------- 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: moti
Date Posted: 09 May 2006 at 2:25am
|
borg, thanks a lot for your attention,
the first way which you have wrote, doesn't work so I went for second way ,
I deleted all of records in the Permissions table, and it took about 1 hour to re-setup all persmission for forums,
but I still have the problem,
when I log-in with a user which I have assigned individual permission for one forum its ok and the problem has gone, but If I give this user permission for more than one forum ( a user moderate two or more forums ) the problem gets back and the forums appear multiple times ,
borg what you think? this is not a bug ?
maybe the problem isn't permission table ,
tell me what to do,
Thanks
|
Posted By: WebWiz-Bruce
Date 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.
------------- 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: moti
Date 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
|
Posted By: AnaMaria
Date Posted: 09 May 2006 at 8:16pm
| I have the same problem... |
Posted By: venki
Date 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.
|
Posted By: WebWiz-Bruce
Date 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.
------------- 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: moti
Date 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 ....
|
Posted By: moti
Date Posted: 18 May 2006 at 11:36pm
| http://forums.webwiz.net/member_profile.asp?PF=1&FID=18 - -boRg- did you found anything new ? is there any way to solve the problem ? |
Posted By: WebWiz-Bruce
Date 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. ------------- 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: ohiopbx
Date 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? |
Posted By: WebWiz-Bruce
Date 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. ------------- 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 |