| Alan wrote
| Sanjay Mehrotra wrote
did your site by any chance have a prior version of feedback installed on another page? If yes, then in 4.4.3 (of feedback) the ability to moderate posts that were made on a different instance of the module (ie on a different page or if you added and then deleted the prior instance) was removed since it was considered a security hole.
You can get around this by modifying the stored proc (and I'd be happy to show you how) but that would explain why the page is refreshing without any changes...
Sanjay
|
Yes please! Can you explain this?
|
Alan,
So here is the original stored procedure that I'm talking about. (UpdateFeedbackStatus)
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
If you modify this stored procedure as follows, it would allow you to update the status of any feedback submitted (ie similar to what was the case prior to 4.4.3).
CREATE PROCEDURE {databaseOwner}{objectQualifier}UpdateFeedbackStatus
@ModuleID int,
@FeedbackID int,
@Status int
AS
IF @Status = 4
DELETE {databaseOwner}[{objectQualifier}Feedback] WHERE FeedbackID = @FeedbackID
ELSE
UPDATE {databaseOwner}[{objectQualifier}Feedback]
SET Status = @Status
WHERE FeedbackID = @FeedbackID
GO