Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackProduction Issue Need Help - Please GuideProduction Issue Need Help - Please Guide
Previous
 
Next
New Post
3/3/2008 11:32 PM
 

Joe,
My apologies if it looked like the solution was kept secret. This was not the intention. In Sid's case, part of the issue was the way he was trying to use the moderation feature of the feedback module which was resulting in the issues he was experiencing on his particular setup. I did help him out in solving the problem but this was more to help him understand how the moderation feature worked and in his case, he was able to moderate posts once he made a tweak in his environment.

For your information and others, I'll go ahead and post on the forums the particular situation...
In 4.4.2 and onwards of Feedback module, an issue was identified which would allow someone without module level permissions to be able to moderate posts even if they were not supposed to moderate posts. To avoid this problem, we started passing the moduleID as part of the query to the feedback sproc which updates the status of the feedback post. What this means is that you can moderate the posts submitted for the instance of the feedback module which is dropped on a given page. A unique moduleID is given to every instance of Feedback (as well as the comments) and this is used to track which posts can be moderated. 
In Sid's case, he had dropped feedback on a particular page, and then he was trying to moderate the posts from another instance of the feedback module that he dropped on a hidden page which was not visible to someone till they logged in with the right permissions. He was using the redirect feature of the page settings to redirect the user to the moderation page, but he was not passing in the ModuleID correctly as part of the redirection. 
So in summary, all I did was point this out to him and he made the neccessary changes which made his moderation start working. 
One of the reasons I didn't post this on the forums was because his case was unique - in most other cases I've seen people moderate posts, they are using the moderate menu action from the same page on which the feedback module is dropped on a page. 

If you're doing the same thing, then you should be able to make the same changes (note the ModuleID when you click on Moderate) and make your redirect URL to be the same. 

Prior to 4.4.2, you were able to moderate any posts that were submitted on any instance of the feedback module (for the same Portal). In another scenario (lets call this Scenario B), you might have feedback on a given page and are trying to moderate them via another instance on another page - this will not work and this is intentional. 

However that being said, you can make a slight modification and get the above mentioned scenario (Scenario B)  to work too. There is a stored procedure called UpdateFeedbackStatus which takes in ModuleID, FeedbackID and a Status (all integer values). If you modify the sproc in SQL Server by removing the where clause for the ModuleID, Scenario B would start working.

I'm not sure if this is your case or not and if it isn't, I'd be more than happy to work with you to see what's going on in your case.... The sproc in question is given below with the section to be removed in red....

 

 

CREATE PROCEDURE {databaseOwner}{objectQualifier}UpdateFeedbackStatus
 @ModuleID int,
 @FeedbackID int,
 @Status int
AS
IF @Status = 4
 DELETE {databaseOwner}[{objectQualifier}Feedback] WHERE FeedbackID = @FeedbackID and ModuleID = @ModuleID
ELSE
 UPDATE {databaseOwner}[{objectQualifier}Feedback]
 SET    Status = @Status
 WHERE FeedbackID = @FeedbackID and ModuleID = @ModuleID
GO

Thanks
Sanjay

 


AcuitiDP - Oracle Data Provider for DotNetNuke
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackProduction Issue Need Help - Please GuideProduction Issue Need Help - Please Guide


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out