While installing the Feedback module did you notice any error message? If not, when logged in as host, please check the Admin-->Event Viewer for any errors which occurred during the install. I am concerned as to why that stored procedure failed to install - one of the reasons could be that your database server may be MS SQL Server 2000 or more likely that the database itself may be still set for compatibility mode 80 (rather than 90 or 100) if the server had been upgraded from MS SQL Server 2000. That particular stored procedure makes use of ROW_NUMBER and CTE (common table expressions) which were not available pre-MS SQL Server 2005.  MS SQL Server 2005/2008 is a pre-requisite for DNN 5.2.0 and later.

If you have just installed the Feedback module and have not started receiving feedback submissions I would suggest uninstalling the Feedback module (Host --> Extensions) and after checking your database compatibility reinstalling the module rather than trying to re-create the missing stored procedure.

If you do decide not to do a complete reinstall for some reason, you will find CREATE PROCEDURE {databaseOwner}[{objectQualifier}Feedback_GetFeedbackByCategory] in the DesktopModules/Feedback/Providers/DataProviders/SqlDataProvider/05.00.00.SqlDataProvider file. It can be copied to the windows clipboard then pasted into the Host-->SQL window and executed. Be sure to check the "Run as Script" checkbox.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner