| Author |
 Topic  |
|
svickrey
Starting Member
USA
43 Posts |
 Posted - 15 February 2005 : 10:30:24
|
Here is the offending query.
SELECT COUNT(TOPIC_ID) AS PAGECOUNT FROM ((((FORUM_FORUM F LEFT JOIN
FORUM_TOPICS T ON F.FORUM_ID = T.FORUM_ID) LEFT JOIN FORUM_REPLY R
ON T.TOPIC_ID = R.TOPIC_ID) LEFT JOIN FORUM_MEMBERS M ON T.T_AUTHOR = M.MEMBER_ID)
LEFT JOIN FORUM_CATEGORY C ON T.CAT_ID = C.CAT_ID)
LEFT JOIN FORUM_MEMBERS MEMBERS_1 ON T.T_LAST_POST_AUTHOR =
MEMBERS_1.MEMBER_ID WHERE (T.T_STATUS > 1 OR R.R_STATUS > 1)
Can anyone see why I'm getting this error? |
Edited by - svickrey on 15 February 2005 10:33:41 |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
svickrey
Starting Member
USA
43 Posts |
Posted - 15 February 2005 : 18:49:31
|
| Thanks Ruirib, That fixed everything. I know I didn't change that. Anyway, it's all good now. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
viggy
Starting Member
3 Posts |
Posted - 23 February 2005 : 04:04:47
|
I want to moderate ONLY new member posts. So went and installed 'User Level Moderation' (http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=39014).
After completing the whole exercise, under ‘edit forum property’ page, I do see a dropdown link that says 'Moderate New User Posts Only' (along with All Posts Moderated, Replies Only Moderated etc) but the posts by new user are not queued for moderation. They show-up to all members. Any solution? BTW, I'm using version 3.4.04.
Thanks in advance...
|
Edited by - viggy on 23 February 2005 04:07:41 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Laserdan
Starting Member
USA
2 Posts |
Posted - 24 March 2005 : 12:52:38
|
| Hmmm...I am admin and moderator of a forum...moderator is all set up and working....the only problem i have is seeing the new posts that need to be approved. THey dont show up in active topics until I have approved them....Is there another place I need to go to see new posts or replys that need to be approved? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Laserdan
Starting Member
USA
2 Posts |
Posted - 24 March 2005 : 15:12:43
|
Well, for any others that were having this problem, here is how I fixed it:
It seemed to be something to do with the cookies...whenever I hit the Logout button, it would say i was logged out then dump me right back into the admin screens.
So I deleted all the cookies...then the logout worked correctly, which also started letting me see the unmoderated posts under the active posts section. Must have had something to do with the log in time filter. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
