ollep
Nuke Master
Posts:456
 |
| 05/24/2010 4:52 AM |
|
Got the following long exception message as I installed the Link Module in the latest DNN version; | Info |
Executing 04.00.00.SqlDataProvider |
| Info |
Start Sql execution: 04.00.00.SqlDataProvider
file |
| Warning |
SQL Execution resulted in following
Exceptions:
System.Data.SqlClient.SqlException: There is already an object named
'dnnLinks_AddLink' 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script,
Boolean UseTransactions)
/** Create renamed Stored Procedures **/
CREATE PROCEDURE dbo.dnnLinks_AddLink
@ModuleId int,
@UserId int,
@CreatedDate datetime,
@Title nvarchar(100),
@Url nvarchar(250),
@ViewOrder int,
@Description nvarchar(2000)
AS
INSERT INTO dbo.Links (
ModuleId,
CreatedByUser,
CreatedDate,
Title,
Url,
ViewOrder,
Description
)
VALUES (
@ModuleId,
@UserId,
@CreatedDate,
@Title,
@Url,
@ViewOrder,
@Description
)
SELECT SCOPE_IDENTITY()
System.Data.SqlClient.SqlException: There is already an object named
'dnnLinks_GetLink' 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script,
Boolean UseTransactions)
CREATE PROCEDURE dbo.dnnLinks_GetLink
@ItemId int,
@ModuleId int
AS
SELECT L.ItemId,
L.ModuleId,
L.Title,
L.URL,
L.ViewOrder,
L.Description,
L.CreatedByUser,
L.CreatedDate,
UT.TrackClicks,
UT.NewWindow
FROM dbo.Links L
LEFT OUTER JOIN dbo.UrlTracking UT ON L.URL = UT.Url AND L.ModuleId =
UT.ModuleId
WHERE L.ItemId = @ItemId AND L.ModuleId = @ModuleId
System.Data.SqlClient.SqlException: There is already an object named
'dnnLinks_GetLinks' 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script,
Boolean UseTransactions)
CREATE PROCEDURE dbo.dnnLinks_GetLinks
@ModuleId int
AS
SELECT L.ItemId,
L.ModuleId,
L.CreatedByUser,
L.CreatedDate,
L.Title,
L.URL,
L.ViewOrder,
L.Description,
UT.TrackClicks,
UT.NewWindow
FROM dbo.Links L
LEFT OUTER JOIN dbo.UrlTracking UT ON L.URL = UT.Url AND L.ModuleId =
UT.ModuleId
WHERE L.ModuleId = @ModuleId
ORDER BY L.ViewOrder, L.Title
System.Data.SqlClient.SqlException: There is already an object named
'dnnLinks_UpdateLink' 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script,
Boolean UseTransactions)
CREATE PROCEDURE dbo.dnnLinks_UpdateLink
@ItemId int,
@UserId int,
@CreatedDate DateTime,
@Title nvarchar(100),
@Url nvarchar(250),
@ViewOrder int,
@Description nvarchar(2000)
AS
UPDATE Links
SET CreatedByUser = @UserId,
CreatedDate = @CreatedDate,
Title = @Title,
Url = @Url,
ViewOrder = @ViewOrder,
Description = @Description
WHERE ItemId = @ItemId
System.Data.SqlClient.SqlException: There is already an object named
'dnnLinks_DeleteLink' 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script,
Boolean UseTransactions)
CREATE PROCEDURE dbo.dnnLinks_DeleteLink
@ItemId INT,
@ModuleId INT
AS
DELETE
FROM dbo.Links
WHERE ItemID = @ItemId AND ModuleID = @ModuleId
|
| Info |
End Sql execution: 04.00.00.SqlDataProvider file |
| Info |
Created - 04.00.01.SqlDataProvider |
|
|
|
|
|