|
 |    |  |
 | |  |
 | |  |
 | |  |
 | |  |
 |
|
|
| Help module will not install |
|
|
I get this error when installing to 4.0.2
| StartJob |
Start Sql execution: 02.00.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'Help_CategorySetVisibility' in the database. 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[Help_CategorySetVisibility] @CategoryID int, @Visibility int AS UPDATE dbo.Help_Category SET [Visible] = @Visibility WHERE [CategoryID] = @CategoryID System.Data.SqlClient.SqlException: There is already an object named 'Help_GetCategory' in the database. 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[Help_GetCategory] @CategoryID int AS SELECT * FROM dbo.Help_Category WHERE [CategoryID] = @CategoryID |
| EndJob |
End Sql execution: 02.00.01.SqlDataProvider file |
| |
| Info |
Executing 02.00.02.SqlDataProvider |
| StartJob |
Start Sql execution: 02.00.02.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 31: Incorrect syntax near '@Search'. 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** SQLDataProvider *****/ /***** Help *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ /* Insert here the code to create tables and stored procs */ CREATE PROCEDURE dbo.[Help_SearchTutorials] @Search nvarchar(100) AS SELECT dbo.Help_Tutorials.TutorialGUID, dbo.Help_Tutorials.TutorialID, dbo.Help_Tutorials.Title, dbo.Help_Tutorials.ProductImage, dbo.Help_Tutorials.Featured, dbo.Help_Tutorials.KeyWords, dbo.Help_Tutorials.DownloadName, dbo.Help_Tutorials.ShortDesc, dbo.Help_Tutorials.Archive, dbo.Help_Tutorials.Description, 0 AS ViewOrder FROM dbo.Help_Tutorials WHERE (dbo.Help_Tutorials.Title LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.KeyWords LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.ShortDesc LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.Description LIKE N'%' @Search '%') |
| EndJob |
End Sql execution: 02.00.02.SqlDataProvider file | |
|
|
|
 |  |
|
|
| Re: Help module will not install |
|
|
Looks to me like you already had it installed. To get aound this problem you will need to open up the database and delete all ofthe tables and stored procedures prefixed with Help_. Then try it again. Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
 |
|
|
|
 |  |
|
|
| Re: Help module will not install |
|
|
| Unfortunatly, i do not have access to eh database, is there a script i could run to delete those tables? |
|
|
|
 |  |
|
|
| Re: Help module will not install |
|
|
You can paste the Uninstall script in the Uninstall.SQLDataProvider file into the Host/SQL window and mark it as Execute as Script. Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
 |
|
|
|
 |  |
|
|
| Re: Help module will not install |
|
|
|
|
|  |
 | |  |
 | |  |
 | |  |
|  |
| |
 |
|
These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.
For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
|
| |
 |
|