| Author |
 Topic Search  Topic Options
|
moti 
Groupie
Joined: 07 September 2004
Status: Offline
Points: 73
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: moderator sees two forums instead of one
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 ,
|
 |
moti
Groupie
Joined: 07 September 2004
Status: Offline
Points: 73
|
Post Options
Thanks(0)
Quote Reply
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,
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
moti
Groupie
Joined: 07 September 2004
Status: Offline
Points: 73
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
moti
Groupie
Joined: 07 September 2004
Status: Offline
Points: 73
|
Post Options
Thanks(0)
Quote Reply
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
|
|
AnaMaria
Groupie
Joined: 12 May 2005
Status: Offline
Points: 37
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 May 2006 at 8:16pm |
|
I have the same problem...
|
|
venki
Groupie
Joined: 20 April 2003
Status: Offline
Points: 40
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
