|
Joined: 4/16/2008
Posts: 1
|
|
|
I've a new installation of version 4.9 and new to DNN. I tried to install a skin but I got a permission error. I Googled the error and the problem was caused by having Frontpage Extensions installed in the directory that DNN is installed in. I uninstalled FPSE and tried to install it again, but no love.
I tried a few other templates but soon gave up and I've decided I'll just use and modify Minimal Extropy for my site. Hey, it's well tested, so has got to be a good place to start.
I then tried to install the feedback module but got the following error (see below). I'm not a coder. Wow, where do I start to solve this problem?? OK, I've given up on the skins but it'd be nice to have access to a few modules.
TIA for any suggestions
Kerry
| StartJob |
Installing: Feedback (04.04.03) |
| StartJob |
Starting Installation |
| StartJob |
Reading files |
| Info |
Loading App_LocalResources/CommentSettings.ascx.resx |
| Info |
File App_LocalResources\CommentSettings.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Feedback.ascx.resx |
| Info |
File App_LocalResources\Feedback.ascx.resx read successfully |
| Info |
Loading App_LocalResources/FeedbackLists.ascx.resx |
| Info |
File App_LocalResources\FeedbackLists.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Moderation.ascx.resx |
| Info |
File App_LocalResources\Moderation.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Settings.ascx.resx |
| Info |
File App_LocalResources\Settings.ascx.resx read successfully |
| Info |
Loading App_LocalResources/SharedResources.resx |
| Info |
File App_LocalResources\SharedResources.resx read successfully |
| Info |
Loading App_LocalResources/ViewComments.ascx.resx |
| Info |
File App_LocalResources\ViewComments.ascx.resx read successfully |
| Info |
Loading 03.02.01.SqlDataProvider |
| Info |
File 03.02.01.SqlDataProvider read successfully |
| Info |
Loading 04.04.01.SqlDataProvider |
| Info |
File 04.04.01.SqlDataProvider read successfully |
| Info |
Loading 04.04.02.SqlDataProvider |
| Info |
File 04.04.02.SqlDataProvider read successfully |
| Info |
Loading 04.04.03.SqlDataProvider |
| Info |
File 04.04.03.SqlDataProvider read successfully |
| Info |
Loading 04.04.03.txt |
| Info |
File 04.04.03.txt read successfully |
| Info |
Loading CommentSettings.ascx |
| Info |
File CommentSettings.ascx read successfully |
| Info |
Loading DNN_Feedback.dnn |
| Info |
File DNN_Feedback.dnn read successfully |
| Info |
Loading DotNetNuke.Modules.Feedback.dll |
| Info |
File DotNetNuke.Modules.Feedback.dll read successfully |
| Info |
Loading DotNetNuke.Modules.Feedback.SqlDataProvider.dll |
| Info |
File DotNetNuke.Modules.Feedback.SqlDataProvider.dll read successfully |
| Info |
Loading Feedback.ascx |
| Info |
File Feedback.ascx read successfully |
| Info |
Loading FeedbackLists.ascx |
| Info |
File FeedbackLists.ascx read successfully |
| Info |
Loading Moderation.ascx |
| Info |
File Moderation.ascx read successfully |
| Info |
Loading Settings.ascx |
| Info |
File Settings.ascx read successfully |
| Info |
Loading Uninstall.SqlDataProvider |
| Info |
File Uninstall.SqlDataProvider read successfully |
| Info |
Loading ViewComments.ascx |
| Info |
File ViewComments.ascx read successfully |
| EndJob |
Reading files done. |
| |
| StartJob |
Reading Installation Manifest file |
| Info |
DNN file is in valid 3.0 format. |
| Info |
xml loaded. |
| Info |
Loading files info |
| Info |
Found valid path (App_LocalResources) for Feedback.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Settings.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Moderation.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for ViewComments.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for CommentSettings.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for FeedbackLists.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for SharedResources.resx. |
| Info |
Loading Modules info |
| Info |
Loading Control info for 'Feedback' module |
| Info |
Loading Control info for 'Feedback Comments' module |
| EndJob |
Manifest file finished successfully |
| |
| StartJob |
Begin Sql execution |
| Info |
Executing 03.02.01.SqlDataProvider |
| StartJob |
Start Sql execution: 03.02.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Stored Procedures **/ create procedure dbo.CreateFeedback @Category int, @CreatedByEmail nvarchar(200), @FeedBackGUID nvarchar(50), @ModuleID int, @Status int, @Message nvarchar(1000), @Subject nvarchar(200) as insert into Feedback ( Category, CreatedByEmail, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) values ( @Category, @CreatedByEmail, getdate(), @FeedBackGUID, @ModuleID, @Status, @Message, @Subject ) System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. Invalid column name 'Category'. Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetCategoryFeedback @Category int, @Status int, @CurrentPage int, @PageSize int AS --Create a temp table to hold the current page of data --Add and ID column to count the records CREATE TABLE #TempTable ( ID int IDENTITY PRIMARY KEY, FeedbackID int, Category int, CreatedByEmail nvarchar(200), ApprovedBy int, DateCreated datetime, FeedBackGUID nvarchar(50), ModuleID int, Status int, Message nvarchar(1000), Subject nvarchar(200) ) --Fill the temp table with the Customers data IF @Category = 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Status = @Status ORDER BY DateCreated Desc END IF @Category > 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Category = @Category and Status = @Status ORDER BY DateCreated Desc END --Return the total number of records available DECLARE @TotalRecords int SELECT @TotalRecords = COUNT(FeedbackID) FROM #TempTable --Create variable to identify the first and last record that should be selected DECLARE @FirstRec int, @LastRec int SELECT @FirstRec = (@CurrentPage - 1) * @PageSize SELECT @LastRec = (@CurrentPage * @PageSize + 1) --Select one page of data based on the record numbers above SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject, TotalRecords = @TotalRecords FROM #TempTable WHERE ID > @FirstRec AND ID < @LastRec System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetFeedbackByGUID @FeedbackGUID nvarchar(50) as select * from Feedback where FeedbackGUID = @FeedbackGUID System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.UpdateFeedbackStatus @FeedBackGUID nvarchar(50), @Status int as update Feedback set Status = @Status where FeedbackGUID = @FeedbackGUID |
| EndJob |
End Sql execution: 03.02.01.SqlDataProvider file |
| |
| Info |
Executing 04.04.01.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'Category' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN [Category] System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'FeedbackGUID' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN FeedbackGUID |
| EndJob |
End Sql execution: 04.04.01.SqlDataProvider file |
| |
| Info |
Executing 04.04.02.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.02.SqlDataProvider file |
| EndJob |
End Sql execution: 04.04.02.SqlDataProvider file |
| |
| Info |
Executing 04.04.03.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.03.SqlDataProvider file |
| EndJob |
End Sql execution: 04.04.03.SqlDataProvider file |
| |
| EndJob |
Finished Sql execution |
| |
| StartJob |
Creating files |
| Failure |
ExceptionSystem.UnauthorizedAccessException: Access to the path 'C:\HostingSpaces\kerryww2\orientbeach.com\wwwroot\bin\DotNetNuke.Modules.Feedback.dll' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFile(String FullFileName, Byte[] Buffer) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateBinFile(PaFile File) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install() |
| StartJob |
Installing: Feedback (04.04.03) |
| StartJob |
Starting Installation |
| StartJob |
Reading files |
| Info |
Loading App_LocalResources/CommentSettings.ascx.resx |
| Info |
File App_LocalResources\CommentSettings.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Feedback.ascx.resx |
| Info |
File App_LocalResources\Feedback.ascx.resx read successfully |
| Info |
Loading App_LocalResources/FeedbackLists.ascx.resx |
| Info |
File App_LocalResources\FeedbackLists.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Moderation.ascx.resx |
| Info |
File App_LocalResources\Moderation.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Settings.ascx.resx |
| Info |
File App_LocalResources\Settings.ascx.resx read successfully |
| Info |
Loading App_LocalResources/SharedResources.resx |
| Info |
File App_LocalResources\SharedResources.resx read successfully |
| Info |
Loading App_LocalResources/ViewComments.ascx.resx |
| Info |
File App_LocalResources\ViewComments.ascx.resx read successfully |
| Info |
Loading 03.02.01.SqlDataProvider |
| Info |
File 03.02.01.SqlDataProvider read successfully |
| Info |
Loading 04.04.01.SqlDataProvider |
| Info |
File 04.04.01.SqlDataProvider read successfully |
| Info |
Loading 04.04.02.SqlDataProvider |
| Info |
File 04.04.02.SqlDataProvider read successfully |
| Info |
Loading 04.04.03.SqlDataProvider |
| Info |
File 04.04.03.SqlDataProvider read successfully |
| Info |
Loading 04.04.03.txt |
| Info |
File 04.04.03.txt read successfully |
| Info |
Loading CommentSettings.ascx |
| Info |
File CommentSettings.ascx read successfully |
| Info |
Loading DNN_Feedback.dnn |
| Info |
File DNN_Feedback.dnn read successfully |
| Info |
Loading DotNetNuke.Modules.Feedback.dll |
| Info |
File DotNetNuke.Modules.Feedback.dll read successfully |
| Info |
Loading DotNetNuke.Modules.Feedback.SqlDataProvider.dll |
| Info |
File DotNetNuke.Modules.Feedback.SqlDataProvider.dll read successfully |
| Info |
Loading Feedback.ascx |
| Info |
File Feedback.ascx read successfully |
| Info |
Loading FeedbackLists.ascx |
| Info |
File FeedbackLists.ascx read successfully |
| Info |
Loading Moderation.ascx |
| Info |
File Moderation.ascx read successfully |
| Info |
Loading Settings.ascx |
| Info |
File Settings.ascx read successfully |
| Info |
Loading Uninstall.SqlDataProvider |
| Info |
File Uninstall.SqlDataProvider read successfully |
| Info |
Loading ViewComments.ascx |
| Info |
File ViewComments.ascx read successfully |
| EndJob |
Reading files done. |
| |
| StartJob |
Reading Installation Manifest file |
| Info |
DNN file is in valid 3.0 format. |
| Info |
xml loaded. |
| Info |
Loading files info |
| Info |
Found valid path (App_LocalResources) for Feedback.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Settings.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Moderation.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for ViewComments.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for CommentSettings.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for FeedbackLists.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for SharedResources.resx. |
| Info |
Loading Modules info |
| Info |
Loading Control info for 'Feedback' module |
| Info |
Loading Control info for 'Feedback Comments' module |
| EndJob |
Manifest file finished successfully |
| |
| StartJob |
Begin Sql execution |
| Info |
Executing 03.02.01.SqlDataProvider |
| StartJob |
Start Sql execution: 03.02.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Stored Procedures **/ create procedure dbo.CreateFeedback @Category int, @CreatedByEmail nvarchar(200), @FeedBackGUID nvarchar(50), @ModuleID int, @Status int, @Message nvarchar(1000), @Subject nvarchar(200) as insert into Feedback ( Category, CreatedByEmail, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) values ( @Category, @CreatedByEmail, getdate(), @FeedBackGUID, @ModuleID, @Status, @Message, @Subject ) System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. Invalid column name 'Category'. Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetCategoryFeedback @Category int, @Status int, @CurrentPage int, @PageSize int AS --Create a temp table to hold the current page of data --Add and ID column to count the records CREATE TABLE #TempTable ( ID int IDENTITY PRIMARY KEY, FeedbackID int, Category int, CreatedByEmail nvarchar(200), ApprovedBy int, DateCreated datetime, FeedBackGUID nvarchar(50), ModuleID int, Status int, Message nvarchar(1000), Subject nvarchar(200) ) --Fill the temp table with the Customers data IF @Category = 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Status = @Status ORDER BY DateCreated Desc END IF @Category > 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Category = @Category and Status = @Status ORDER BY DateCreated Desc END --Return the total number of records available DECLARE @TotalRecords int SELECT @TotalRecords = COUNT(FeedbackID) FROM #TempTable --Create variable to identify the first and last record that should be selected DECLARE @FirstRec int, @LastRec int SELECT @FirstRec = (@CurrentPage - 1) * @PageSize SELECT @LastRec = (@CurrentPage * @PageSize + 1) --Select one page of data based on the record numbers above SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject, TotalRecords = @TotalRecords FROM #TempTable WHERE ID > @FirstRec AND ID < @LastRec System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetFeedbackByGUID @FeedbackGUID nvarchar(50) as select * from Feedback where FeedbackGUID = @FeedbackGUID System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.UpdateFeedbackStatus @FeedBackGUID nvarchar(50), @Status int as update Feedback set Status = @Status where FeedbackGUID = @FeedbackGUID |
| EndJob |
End Sql execution: 03.02.01.SqlDataProvider file |
| |
| Info |
Executing 04.04.01.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'Category' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN [Category] System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'FeedbackGUID' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN FeedbackGUID |
| EndJob |
End Sql execution: 04.04.01.SqlDataProvider file |
| |
| Info |
Executing 04.04.02.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.02.SqlDataProvider file |
| EndJob |
End Sql execution: 04.04.02.SqlDataProvider file |
| |
| Info |
Executing 04.04.03.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.03.SqlDataProvider file |
| EndJob |
End Sql execution: 04.04.03.SqlDataProvider file |
| |
| EndJob |
Finished Sql execution |
| |
| StartJob |
Creating files |
| Failure |
ExceptionSystem.UnauthorizedAccessException: Access to the path 'C:\HostingSpaces\kerryww2\orientbeach.com\wwwroot\bin\DotNetNuke.Modules.Feedback.dll' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFile(String FullFileName, Byte[] Buffer) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateBinFile(PaFile File) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install() |
| StartJob |
Installing: Feedback (04.04.03) |
| StartJob |
Starting Installation |
| StartJob |
Reading files |
| Info |
Loading App_LocalResources/CommentSettings.ascx.resx |
| Info |
File App_LocalResources\CommentSettings.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Feedback.ascx.resx |
| Info |
File App_LocalResources\Feedback.ascx.resx read successfully |
| Info |
Loading App_LocalResources/FeedbackLists.ascx.resx |
| Info |
File App_LocalResources\FeedbackLists.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Moderation.ascx.resx |
| Info |
File App_LocalResources\Moderation.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Settings.ascx.resx |
| Info |
File App_LocalResources\Settings.ascx.resx read successfully |
| Info |
Loading App_LocalResources/SharedResources.resx |
| Info |
File App_LocalResources\SharedResources.resx read successfully |
| Info |
Loading App_LocalResources/ViewComments.ascx.resx |
| Info |
File App_LocalResources\ViewComments.ascx.resx read successfully |
| Info |
Loading 03.02.01.SqlDataProvider |
| Info |
File 03.02.01.SqlDataProvider read successfully |
| Info |
Loading 04.04.01.SqlDataProvider |
| Info |
File 04.04.01.SqlDataProvider read successfully |
| Info |
Loading 04.04.02.SqlDataProvider |
| Info |
File 04.04.02.SqlDataProvider read successfully |
| Info |
Loading 04.04.03.SqlDataProvider |
| Info |
File 04.04.03.SqlDataProvider read successfully |
| Info |
Loading 04.04.03.txt |
| Info |
File 04.04.03.txt read successfully |
| Info |
Loading CommentSettings.ascx |
| Info |
File CommentSettings.ascx read successfully |
| Info |
Loading DNN_Feedback.dnn |
| Info |
File DNN_Feedback.dnn read successfully |
| Info |
Loading DotNetNuke.Modules.Feedback.dll |
| Info |
File DotNetNuke.Modules.Feedback.dll read successfully |
| Info |
Loading DotNetNuke.Modules.Feedback.SqlDataProvider.dll |
| Info |
File DotNetNuke.Modules.Feedback.SqlDataProvider.dll read successfully |
| Info |
Loading Feedback.ascx |
| Info |
File Feedback.ascx read successfully |
| Info |
Loading FeedbackLists.ascx |
| Info |
File FeedbackLists.ascx read successfully |
| Info |
Loading Moderation.ascx |
| Info |
File Moderation.ascx read successfully |
| Info |
Loading Settings.ascx |
| Info |
File Settings.ascx read successfully |
| Info |
Loading Uninstall.SqlDataProvider |
| Info |
File Uninstall.SqlDataProvider read successfully |
| Info |
Loading ViewComments.ascx |
| Info |
File ViewComments.ascx read successfully |
| EndJob |
Reading files done. |
| |
| StartJob |
Reading Installation Manifest file |
| Info |
DNN file is in valid 3.0 format. |
| Info |
xml loaded. |
| Info |
Loading files info |
| Info |
Found valid path (App_LocalResources) for Feedback.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Settings.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Moderation.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for ViewComments.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for CommentSettings.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for FeedbackLists.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for SharedResources.resx. |
| Info |
Loading Modules info |
| Info |
Loading Control info for 'Feedback' module |
| Info |
Loading Control info for 'Feedback Comments' module |
| EndJob |
Manifest file finished successfully |
| |
| StartJob |
Begin Sql execution |
| Info |
Executing 03.02.01.SqlDataProvider |
| StartJob |
Start Sql execution: 03.02.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Stored Procedures **/ create procedure dbo.CreateFeedback @Category int, @CreatedByEmail nvarchar(200), @FeedBackGUID nvarchar(50), @ModuleID int, @Status int, @Message nvarchar(1000), @Subject nvarchar(200) as insert into Feedback ( Category, CreatedByEmail, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) values ( @Category, @CreatedByEmail, getdate(), @FeedBackGUID, @ModuleID, @Status, @Message, @Subject ) System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. Invalid column name 'Category'. Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetCategoryFeedback @Category int, @Status int, @CurrentPage int, @PageSize int AS --Create a temp table to hold the current page of data --Add and ID column to count the records CREATE TABLE #TempTable ( ID int IDENTITY PRIMARY KEY, FeedbackID int, Category int, CreatedByEmail nvarchar(200), ApprovedBy int, DateCreated datetime, FeedBackGUID nvarchar(50), ModuleID int, Status int, Message nvarchar(1000), Subject nvarchar(200) ) --Fill the temp table with the Customers data IF @Category = 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Status = @Status ORDER BY DateCreated Desc END IF @Category > 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Category = @Category and Status = @Status ORDER BY DateCreated Desc END --Return the total number of records available DECLARE @TotalRecords int SELECT @TotalRecords = COUNT(FeedbackID) FROM #TempTable --Create variable to identify the first and last record that should be selected DECLARE @FirstRec int, @LastRec int SELECT @FirstRec = (@CurrentPage - 1) * @PageSize SELECT @LastRec = (@CurrentPage * @PageSize + 1) --Select one page of data based on the record numbers above SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject, TotalRecords = @TotalRecords FROM #TempTable WHERE ID > @FirstRec AND ID < @LastRec System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetFeedbackByGUID @FeedbackGUID nvarchar(50) as select * from Feedback where FeedbackGUID = @FeedbackGUID System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.UpdateFeedbackStatus @FeedBackGUID nvarchar(50), @Status int as update Feedback set Status = @Status where FeedbackGUID = @FeedbackGUID |
| EndJob |
End Sql execution: 03.02.01.SqlDataProvider file |
| |
| Info |
Executing 04.04.01.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'Category' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN [Category] System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'FeedbackGUID' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN FeedbackGUID |
| EndJob |
End Sql execution: 04.04.01.SqlDataProvider file |
| |
| Info |
Executing 04.04.02.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.02.SqlDataProvider file |
| EndJob |
End Sql execution: 04.04.02.SqlDataProvider file |
| |
| Info |
Executing 04.04.03.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.03.SqlDataProvider file |
| EndJob |
End Sql execution: 04.04.03.SqlDataProvider file |
| |
| EndJob |
Finished Sql execution |
| |
| StartJob |
Creating files |
| Failure |
ExceptionSystem.UnauthorizedAccessException: Access to the path 'C:\HostingSpaces\kerryww2\orientbeach.com\wwwroot\bin\DotNetNuke.Modules.Feedback.dll' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFile(String FullFileName, Byte[] Buffer) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateBinFile(PaFile File) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install() |
| StartJob |
Installing: Feedback (04.04.03) |
| StartJob |
Starting Installation |
| StartJob |
Reading files |
| Info |
Loading App_LocalResources/CommentSettings.ascx.resx |
| Info |
File App_LocalResources\CommentSettings.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Feedback.ascx.resx |
| Info |
File App_LocalResources\Feedback.ascx.resx read successfully |
| Info |
Loading App_LocalResources/FeedbackLists.ascx.resx |
| Info |
File App_LocalResources\FeedbackLists.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Moderation.ascx.resx |
| Info |
File App_LocalResources\Moderation.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Settings.ascx.resx |
| Info |
File App_LocalResources\Settings.ascx.resx read successfully |
| Info |
Loading App_LocalResources/SharedResources.resx |
| Info |
File App_LocalResources\SharedResources.resx read successfully |
| Info |
Loading App_LocalResources/ViewComments.ascx.resx |
| Info |
File App_LocalResources\ViewComments.ascx.resx read successfully |
| Info |
Loading 03.02.01.SqlDataProvider |
| Info |
File 03.02.01.SqlDataProvider read successfully |
| Info |
Loading 04.04.01.SqlDataProvider |
| Info |
File 04.04.01.SqlDataProvider read successfully |
| Info |
Loading 04.04.02.SqlDataProvider |
| Info |
File 04.04.02.SqlDataProvider read successfully |
| Info |
Loading 04.04.03.SqlDataProvider |
| Info |
File 04.04.03.SqlDataProvider read successfully |
| Info |
Loading 04.04.03.txt |
| Info |
File 04.04.03.txt read successfully |
| Info |
Loading CommentSettings.ascx |
| Info |
File CommentSettings.ascx read successfully |
| Info |
Loading DNN_Feedback.dnn |
| Info |
File DNN_Feedback.dnn read successfully |
| Info |
Loading DotNetNuke.Modules.Feedback.dll |
| Info |
File DotNetNuke.Modules.Feedback.dll read successfully |
| Info |
Loading DotNetNuke.Modules.Feedback.SqlDataProvider.dll |
| Info |
File DotNetNuke.Modules.Feedback.SqlDataProvider.dll read successfully |
| Info |
Loading Feedback.ascx |
| Info |
File Feedback.ascx read successfully |
| Info |
Loading FeedbackLists.ascx |
| Info |
File FeedbackLists.ascx read successfully |
| Info |
Loading Moderation.ascx |
| Info |
File Moderation.ascx read successfully |
| Info |
Loading Settings.ascx |
| Info |
File Settings.ascx read successfully |
| Info |
Loading Uninstall.SqlDataProvider |
| Info |
File Uninstall.SqlDataProvider read successfully |
| Info |
Loading ViewComments.ascx |
| Info |
File ViewComments.ascx read successfully |
| EndJob |
Reading files done. |
| |
| StartJob |
Reading Installation Manifest file |
| Info |
DNN file is in valid 3.0 format. |
| Info |
xml loaded. |
| Info |
Loading files info |
| Info |
Found valid path (App_LocalResources) for Feedback.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Settings.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Moderation.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for ViewComments.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for CommentSettings.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for FeedbackLists.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for SharedResources.resx. |
| Info |
Loading Modules info |
| Info |
Loading Control info for 'Feedback' module |
| Info |
Loading Control info for 'Feedback Comments' module |
| EndJob |
Manifest file finished successfully |
| |
| StartJob |
Begin Sql execution |
| Info |
Executing 03.02.01.SqlDataProvider |
| StartJob |
Start Sql execution: 03.02.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Stored Procedures **/ create procedure dbo.CreateFeedback @Category int, @CreatedByEmail nvarchar(200), @FeedBackGUID nvarchar(50), @ModuleID int, @Status int, @Message nvarchar(1000), @Subject nvarchar(200) as insert into Feedback ( Category, CreatedByEmail, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) values ( @Category, @CreatedByEmail, getdate(), @FeedBackGUID, @ModuleID, @Status, @Message, @Subject ) System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. Invalid column name 'Category'. Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetCategoryFeedback @Category int, @Status int, @CurrentPage int, @PageSize int AS --Create a temp table to hold the current page of data --Add and ID column to count the records CREATE TABLE #TempTable ( ID int IDENTITY PRIMARY KEY, FeedbackID int, Category int, CreatedByEmail nvarchar(200), ApprovedBy int, DateCreated datetime, FeedBackGUID nvarchar(50), ModuleID int, Status int, Message nvarchar(1000), Subject nvarchar(200) ) --Fill the temp table with the Customers data IF @Category = 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Status = @Status ORDER BY DateCreated Desc END IF @Category > 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Category = @Category and Status = @Status ORDER BY DateCreated Desc END --Return the total number of records available DECLARE @TotalRecords int SELECT @TotalRecords = COUNT(FeedbackID) FROM #TempTable --Create variable to identify the first and last record that should be selected DECLARE @FirstRec int, @LastRec int SELECT @FirstRec = (@CurrentPage - 1) * @PageSize SELECT @LastRec = (@CurrentPage * @PageSize + 1) --Select one page of data based on the record numbers above SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject, TotalRecords = @TotalRecords FROM #TempTable WHERE ID > @FirstRec AND ID < @LastRec System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetFeedbackByGUID @FeedbackGUID nvarchar(50) as select * from Feedback where FeedbackGUID = @FeedbackGUID System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.UpdateFeedbackStatus @FeedBackGUID nvarchar(50), @Status int as update Feedback set Status = @Status where FeedbackGUID = @FeedbackGUID |
| EndJob |
End Sql execution: 03.02.01.SqlDataProvider file |
| |
| Info |
Executing 04.04.01.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'Category' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN [Category] System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'FeedbackGUID' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN FeedbackGUID |
| EndJob |
End Sql execution: 04.04.01.SqlDataProvider file |
| |
| Info |
Executing 04.04.02.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.02.SqlDataProvider file |
| EndJob |
End Sql execution: 04.04.02.SqlDataProvider file |
| |
| Info |
Executing 04.04.03.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.03.SqlDataProvider file |
| EndJob |
End Sql execution: 04.04.03.SqlDataProvider file |
| |
| EndJob |
Finished Sql execution |
| |
| StartJob |
Creating files |
| Failure |
ExceptionSystem.UnauthorizedAccessException: Access to the path 'C:\HostingSpaces\kerryww2\orientbeach.com\wwwroot\bin\DotNetNuke.Modules.Feedback.dll' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFile(String FullFileName, Byte[] Buffer) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateBinFile(PaFile File) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install() |
| StartJob |
Installing: Feedback (04.04.03) |
| StartJob |
Starting Installation |
| StartJob |
Reading files |
| Info |
Loading App_LocalResources/CommentSettings.ascx.resx |
| Info |
File App_LocalResources\CommentSettings.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Feedback.ascx.resx |
| Info |
File App_LocalResources\Feedback.ascx.resx read successfully |
| Info |
Loading App_LocalResources/FeedbackLists.ascx.resx |
| Info |
File App_LocalResources\FeedbackLists.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Moderation.ascx.resx |
| Info |
File App_LocalResources\Moderation.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Settings.ascx.resx |
| Info |
File App_LocalResources\Settings.ascx.resx read successfully |
| Info |
Loading App_LocalResources/SharedResources.resx |
| Info |
File App_LocalResources\SharedResources.resx read successfully |
| Info |
Loading App_LocalResources/ViewComments.ascx.resx |
| Info |
File App_LocalResources\ViewComments.ascx.resx read successfully |
| Info |
Loading 03.02.01.SqlDataProvider |
| Info |
File 03.02.01.SqlDataProvider read successfully |
| Info |
Loading 04.04.01.SqlDataProvider |
| Info |
File 04.04.01.SqlDataProvider read successfully |
| Info |
Loading 04.04.02.SqlDataProvider |
| Info |
File 04.04.02.SqlDataProvider read successfully |
| Info |
Loading 04.04.03.SqlDataProvider |
| Info |
File 04.04.03.SqlDataProvider read successfully |
| Info |
Loading 04.04.03.txt |
| Info |
File 04.04.03.txt read successfully |
| Info |
Loading CommentSettings.ascx |
| Info |
File CommentSettings.ascx read successfully |
| Info |
Loading DNN_Feedback.dnn |
| Info |
File DNN_Feedback.dnn read successfully |
| Info |
Loading DotNetNuke.Modules.Feedback.dll |
| Info |
File DotNetNuke.Modules.Feedback.dll read successfully |
| Info |
Loading DotNetNuke.Modules.Feedback.SqlDataProvider.dll |
| Info |
File DotNetNuke.Modules.Feedback.SqlDataProvider.dll read successfully |
| Info |
Loading Feedback.ascx |
| Info |
File Feedback.ascx read successfully |
| Info |
Loading FeedbackLists.ascx |
| Info |
File FeedbackLists.ascx read successfully |
| Info |
Loading Moderation.ascx |
| Info |
File Moderation.ascx read successfully |
| Info |
Loading Settings.ascx |
| Info |
File Settings.ascx read successfully |
| Info |
Loading Uninstall.SqlDataProvider |
| Info |
File Uninstall.SqlDataProvider read successfully |
| Info |
Loading ViewComments.ascx |
| Info |
File ViewComments.ascx read successfully |
| EndJob |
Reading files done. |
| |
| StartJob |
Reading Installation Manifest file |
| Info |
DNN file is in valid 3.0 format. |
| Info |
xml loaded. |
| Info |
Loading files info |
| Info |
Found valid path (App_LocalResources) for Feedback.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Settings.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Moderation.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for ViewComments.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for CommentSettings.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for FeedbackLists.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for SharedResources.resx. |
| Info |
Loading Modules info |
| Info |
Loading Control info for 'Feedback' module |
| Info |
Loading Control info for 'Feedback Comments' module |
| EndJob |
Manifest file finished successfully |
| |
| StartJob |
Begin Sql execution |
| Info |
Executing 03.02.01.SqlDataProvider |
| StartJob |
Start Sql execution: 03.02.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Stored Procedures **/ create procedure dbo.CreateFeedback @Category int, @CreatedByEmail nvarchar(200), @FeedBackGUID nvarchar(50), @ModuleID int, @Status int, @Message nvarchar(1000), @Subject nvarchar(200) as insert into Feedback ( Category, CreatedByEmail, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) values ( @Category, @CreatedByEmail, getdate(), @FeedBackGUID, @ModuleID, @Status, @Message, @Subject ) System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. Invalid column name 'Category'. Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetCategoryFeedback @Category int, @Status int, @CurrentPage int, @PageSize int AS --Create a temp table to hold the current page of data --Add and ID column to count the records CREATE TABLE #TempTable ( ID int IDENTITY PRIMARY KEY, FeedbackID int, Category int, CreatedByEmail nvarchar(200), ApprovedBy int, DateCreated datetime, FeedBackGUID nvarchar(50), ModuleID int, Status int, Message nvarchar(1000), Subject nvarchar(200) ) --Fill the temp table with the Customers data IF @Category = 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Status = @Status ORDER BY DateCreated Desc END IF @Category > 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Category = @Category and Status = @Status ORDER BY DateCreated Desc END --Return the total number of records available DECLARE @TotalRecords int SELECT @TotalRecords = COUNT(FeedbackID) FROM #TempTable --Create variable to identify the first and last record that should be selected DECLARE @FirstRec int, @LastRec int SELECT @FirstRec = (@CurrentPage - 1) * @PageSize SELECT @LastRec = (@CurrentPage * @PageSize + 1) --Select one page of data based on the record numbers above SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject, TotalRecords = @TotalRecords FROM #TempTable WHERE ID > @FirstRec AND ID < @LastRec System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetFeedbackByGUID @FeedbackGUID nvarchar(50) as select * from Feedback where FeedbackGUID = @FeedbackGUID System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.UpdateFeedbackStatus @FeedBackGUID nvarchar(50), @Status int as update Feedback set Status = @Status where FeedbackGUID = @FeedbackGUID |
| EndJob |
End Sql execution: 03.02.01.SqlDataProvider file |
| |
| Info |
Executing 04.04.01.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'Category' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN [Category] System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'FeedbackGUID' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN FeedbackGUID |
| EndJob |
End Sql execution: 04.04.01.SqlDataProvider file |
| |
| Info |
Executing 04.04.02.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.02.SqlDataProvider file |
| EndJob |
End Sql execution: 04.04.02.SqlDataProvider file |
| |
| Info |
Executing 04.04.03.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.03.SqlDataProvider file |
| EndJob |
End Sql execution: 04.04.03.SqlDataProvider file |
| |
| EndJob |
Finished Sql execution |
| |
| StartJob |
Creating files |
| Failure |
ExceptionSystem.UnauthorizedAccessException: Access to the path 'C:\HostingSpaces\kerryww2\orientbeach.com\wwwroot\bin\DotNetNuke.Modules.Feedback.dll' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFile(String FullFileName, Byte[] Buffer) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateBinFile(PaFile File) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install() |
| StartJob |
Installing: Feedback (04.04.03) |
| StartJob |
Starting Installation |
| StartJob |
Reading files |
| Info |
Loading App_LocalResources/CommentSettings.ascx.resx |
| Info |
File App_LocalResources\CommentSettings.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Feedback.ascx.resx |
| Info |
File App_LocalResources\Feedback.ascx.resx read successfully |
| Info |
Loading App_LocalResources/FeedbackLists.ascx.resx |
| Info |
File App_LocalResources\FeedbackLists.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Moderation.ascx.resx |
| Info |
File App_LocalResources\Moderation.ascx.resx read successfully |
| Info |
Loading App_LocalResources/Settings.ascx.resx |
| Info |
File App_LocalResources\Settings.ascx.resx read successfully |
| Info |
Loading App_LocalResources/SharedResources.resx |
| Info |
File App_LocalResources\SharedResources.resx read successfully |
| Info |
Loading App_LocalResources/ViewComments.ascx.resx |
| Info |
File App_LocalResources\ViewComments.ascx.resx read successfully |
| Info |
Loading 03.02.01.SqlDataProvider |
| Info |
File 03.02.01.SqlDataProvider read successfully |
| Info |
Loading 04.04.01.SqlDataProvider |
| Info |
File 04.04.01.SqlDataProvider read successfully |
| Info |
Loading 04.04.02.SqlDataProvider |
| Info |
File 04.04.02.SqlDataProvider read successfully |
| Info |
Loading 04.04.03.SqlDataProvider |
| Info |
File 04.04.03.SqlDataProvider read successfully |
| Info |
Loading 04.04.03.txt |
| Info |
File 04.04.03.txt read successfully |
| Info |
Loading CommentSettings.ascx |
| Info |
File CommentSettings.ascx read successfully |
| Info |
Loading DNN_Feedback.dnn |
| Info |
File DNN_Feedback.dnn read successfully |
| Info |
Loading DotNetNuke.Modules.Feedback.dll |
| Info |
File DotNetNuke.Modules.Feedback.dll read successfully |
| Info |
Loading DotNetNuke.Modules.Feedback.SqlDataProvider.dll |
| Info |
File DotNetNuke.Modules.Feedback.SqlDataProvider.dll read successfully |
| Info |
Loading Feedback.ascx |
| Info |
File Feedback.ascx read successfully |
| Info |
Loading FeedbackLists.ascx |
| Info |
File FeedbackLists.ascx read successfully |
| Info |
Loading Moderation.ascx |
| Info |
File Moderation.ascx read successfully |
| Info |
Loading Settings.ascx |
| Info |
File Settings.ascx read successfully |
| Info |
Loading Uninstall.SqlDataProvider |
| Info |
File Uninstall.SqlDataProvider read successfully |
| Info |
Loading ViewComments.ascx |
| Info |
File ViewComments.ascx read successfully |
| EndJob |
Reading files done. |
| |
| StartJob |
Reading Installation Manifest file |
| Info |
DNN file is in valid 3.0 format. |
| Info |
xml loaded. |
| Info |
Loading files info |
| Info |
Found valid path (App_LocalResources) for Feedback.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Settings.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for Moderation.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for ViewComments.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for CommentSettings.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for FeedbackLists.ascx.resx. |
| Info |
Found valid path (App_LocalResources) for SharedResources.resx. |
| Info |
Loading Modules info |
| Info |
Loading Control info for 'Feedback' module |
| Info |
Loading Control info for 'Feedback Comments' module |
| EndJob |
Manifest file finished successfully |
| |
| StartJob |
Begin Sql execution |
| Info |
Executing 03.02.01.SqlDataProvider |
| StartJob |
Start Sql execution: 03.02.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Stored Procedures **/ create procedure dbo.CreateFeedback @Category int, @CreatedByEmail nvarchar(200), @FeedBackGUID nvarchar(50), @ModuleID int, @Status int, @Message nvarchar(1000), @Subject nvarchar(200) as insert into Feedback ( Category, CreatedByEmail, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) values ( @Category, @CreatedByEmail, getdate(), @FeedBackGUID, @ModuleID, @Status, @Message, @Subject ) System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. Invalid column name 'Category'. Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetCategoryFeedback @Category int, @Status int, @CurrentPage int, @PageSize int AS --Create a temp table to hold the current page of data --Add and ID column to count the records CREATE TABLE #TempTable ( ID int IDENTITY PRIMARY KEY, FeedbackID int, Category int, CreatedByEmail nvarchar(200), ApprovedBy int, DateCreated datetime, FeedBackGUID nvarchar(50), ModuleID int, Status int, Message nvarchar(1000), Subject nvarchar(200) ) --Fill the temp table with the Customers data IF @Category = 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Status = @Status ORDER BY DateCreated Desc END IF @Category > 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Category = @Category and Status = @Status ORDER BY DateCreated Desc END --Return the total number of records available DECLARE @TotalRecords int SELECT @TotalRecords = COUNT(FeedbackID) FROM #TempTable --Create variable to identify the first and last record that should be selected DECLARE @FirstRec int, @LastRec int SELECT @FirstRec = (@CurrentPage - 1) * @PageSize SELECT @LastRec = (@CurrentPage * @PageSize + 1) --Select one page of data based on the record numbers above SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject, TotalRecords = @TotalRecords FROM #TempTable WHERE ID > @FirstRec AND ID < @LastRec System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetFeedbackByGUID @FeedbackGUID nvarchar(50) as select * from Feedback where FeedbackGUID = @FeedbackGUID System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.UpdateFeedbackStatus @FeedBackGUID nvarchar(50), @Status int as update Feedback set Status = @Status where FeedbackGUID = @FeedbackGUID |
| EndJob |
End Sql execution: 03.02.01.SqlDataProvider file |
| |
| Info |
Executing 04.04.01.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'Category' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN [Category] System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'FeedbackGUID' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN FeedbackGUID |
| EndJob |
End Sql execution: 04.04.01.SqlDataProvider file |
| |
| Info |
Executing 04.04.02.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.02.SqlDataProvider file |
| EndJob |
End Sql execution: 04.04.02.SqlDataProvider file |
| |
| Info |
Executing 04.04.03.SqlDataProvider |
| StartJob |
Start Sql execution: 04.04.03.SqlDataProvider file |
| EndJob |
End Sql execution: 04.04.03.SqlDataProvider file |
| |
| EndJob |
Finished Sql execution |
| |
| StartJob |
Creating files |
| Failure |
ExceptionSystem.UnauthorizedAccessException: Access to the path 'C:\HostingSpaces\kerryww2\orientbeach.com\wwwroot\bin\DotNetNuke.Modules.Feedback.dll' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFile(String FullFileName, Byte[] Buffer) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateBinFile(PaFile File) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install() |
StartJob Installing: Feedback (04.04.03)
StartJob Starting Installation
StartJob Reading files
Info Loading App_LocalResources/CommentSettings.ascx.resx
Info File App_LocalResources\CommentSettings.ascx.resx read successfully
Info Loading App_LocalResources/Feedback.ascx.resx
Info File App_LocalResources\Feedback.ascx.resx read successfully
Info Loading App_LocalResources/FeedbackLists.ascx.resx
Info File App_LocalResources\FeedbackLists.ascx.resx read successfully
Info Loading App_LocalResources/Moderation.ascx.resx
Info File App_LocalResources\Moderation.ascx.resx read successfully
Info Loading App_LocalResources/Settings.ascx.resx
Info File App_LocalResources\Settings.ascx.resx read successfully
Info Loading App_LocalResources/SharedResources.resx
Info File App_LocalResources\SharedResources.resx read successfully
Info Loading App_LocalResources/ViewComments.ascx.resx
Info File App_LocalResources\ViewComments.ascx.resx read successfully
Info Loading 03.02.01.SqlDataProvider
Info File 03.02.01.SqlDataProvider read successfully
Info Loading 04.04.01.SqlDataProvider
Info File 04.04.01.SqlDataProvider read successfully
Info Loading 04.04.02.SqlDataProvider
Info File 04.04.02.SqlDataProvider read successfully
Info Loading 04.04.03.SqlDataProvider
Info File 04.04.03.SqlDataProvider read successfully
Info Loading 04.04.03.txt
Info File 04.04.03.txt read successfully
Info Loading CommentSettings.ascx
Info File CommentSettings.ascx read successfully
Info Loading DNN_Feedback.dnn
Info File DNN_Feedback.dnn read successfully
Info Loading DotNetNuke.Modules.Feedback.dll
Info File DotNetNuke.Modules.Feedback.dll read successfully
Info Loading DotNetNuke.Modules.Feedback.SqlDataProvider.dll
Info File DotNetNuke.Modules.Feedback.SqlDataProvider.dll read successfully
Info Loading Feedback.ascx
Info File Feedback.ascx read successfully
Info Loading FeedbackLists.ascx
Info File FeedbackLists.ascx read successfully
Info Loading Moderation.ascx
Info File Moderation.ascx read successfully
Info Loading Settings.ascx
Info File Settings.ascx read successfully
Info Loading Uninstall.SqlDataProvider
Info File Uninstall.SqlDataProvider read successfully
Info Loading ViewComments.ascx
Info File ViewComments.ascx read successfully
EndJob Reading files done.
StartJob Reading Installation Manifest file
Info DNN file is in valid 3.0 format.
Info xml loaded.
Info Loading files info
Info Found valid path (App_LocalResources) for Feedback.ascx.resx.
Info Found valid path (App_LocalResources) for Settings.ascx.resx.
Info Found valid path (App_LocalResources) for Moderation.ascx.resx.
Info Found valid path (App_LocalResources) for ViewComments.ascx.resx.
Info Found valid path (App_LocalResources) for CommentSettings.ascx.resx.
Info Found valid path (App_LocalResources) for FeedbackLists.ascx.resx.
Info Found valid path (App_LocalResources) for SharedResources.resx.
Info Loading Modules info
Info Loading Control info for 'Feedback' module
Info Loading Control info for 'Feedback Comments' module
EndJob Manifest file finished successfully
StartJob Begin Sql execution
Info Executing 03.02.01.SqlDataProvider
StartJob Start Sql execution: 03.02.01.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Stored Procedures **/ create procedure dbo.CreateFeedback @Category int, @CreatedByEmail nvarchar(200), @FeedBackGUID nvarchar(50), @ModuleID int, @Status int, @Message nvarchar(1000), @Subject nvarchar(200) as insert into Feedback ( Category, CreatedByEmail, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) values ( @Category, @CreatedByEmail, getdate(), @FeedBackGUID, @ModuleID, @Status, @Message, @Subject ) System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. Invalid column name 'Category'. Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetCategoryFeedback @Category int, @Status int, @CurrentPage int, @PageSize int AS --Create a temp table to hold the current page of data --Add and ID column to count the records CREATE TABLE #TempTable ( ID int IDENTITY PRIMARY KEY, FeedbackID int, Category int, CreatedByEmail nvarchar(200), ApprovedBy int, DateCreated datetime, FeedBackGUID nvarchar(50), ModuleID int, Status int, Message nvarchar(1000), Subject nvarchar(200) ) --Fill the temp table with the Customers data IF @Category = 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Status = @Status ORDER BY DateCreated Desc END IF @Category > 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Category = @Category and Status = @Status ORDER BY DateCreated Desc END --Return the total number of records available DECLARE @TotalRecords int SELECT @TotalRecords = COUNT(FeedbackID) FROM #TempTable --Create variable to identify the first and last record that should be selected DECLARE @FirstRec int, @LastRec int SELECT @FirstRec = (@CurrentPage - 1) * @PageSize SELECT @LastRec = (@CurrentPage * @PageSize + 1) --Select one page of data based on the record numbers above SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject, TotalRecords = @TotalRecords FROM #TempTable WHERE ID > @FirstRec AND ID < @LastRec System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetFeedbackByGUID @FeedbackGUID nvarchar(50) as select * from Feedback where FeedbackGUID = @FeedbackGUID System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.UpdateFeedbackStatus @FeedBackGUID nvarchar(50), @Status int as update Feedback set Status = @Status where FeedbackGUID = @FeedbackGUID
EndJob End Sql execution: 03.02.01.SqlDataProvider file
Info Executing 04.04.01.SqlDataProvider
StartJob Start Sql execution: 04.04.01.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'Category' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN [Category] System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because column 'FeedbackGUID' does not exist in table 'Feedback'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Feedback] DROP COLUMN FeedbackGUID
EndJob End Sql execution: 04.04.01.SqlDataProvider file
Info Executing 04.04.02.SqlDataProvider
StartJob Start Sql execution: 04.04.02.SqlDataProvider file
EndJob End Sql execution: 04.04.02.SqlDataProvider file
Info Executing 04.04.03.SqlDataProvider
StartJob Start Sql execution: 04.04.03.SqlDataProvider file
EndJob End Sql execution: 04.04.03.SqlDataProvider file
EndJob Finished Sql execution
StartJob Creating files
Failure ExceptionSystem.UnauthorizedAccessException: Access to the path 'C:\HostingSpaces\kerryww2\orientbeach.com\wwwroot\bin\DotNetNuke.Modules.Feedback.dll' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFile(String FullFileName, Byte[] Buffer) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateBinFile(PaFile File) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()
|
| |
|
|