|
|
Joined: 12/15/2004
Posts: 407
|
|
|
I have something wrong in the RNDViewInfo01.SqlDataProvider generated by the VS DotNetNuke Compiled Module template
The Error reported by DotNetNuke when trying to install my DotNetNuke Compiled Module:
| Start jobb |
Börjar exekvera Sql |
| Info |
Exekverar RNDViewInfo01.SqlDataProvider |
| Start jobb |
Start Sql exekvering: RNDViewInfo01.SqlDataProvider fil |
| Fel |
SQL exekvering resulterade i följande undantagsfel: System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_DesktopModules_ModuleName'. Cannot insert duplicate key in object 'dbo.DesktopModules'. Violation of UNIQUE KEY constraint 'IX_ModuleDefinitions'. Cannot insert duplicate key in object 'dbo.ModuleDefinitions'. Violation of UNIQUE KEY constraint 'IX_ModuleControls'. Cannot insert duplicate key in object 'dbo.ModuleControls'. Violation of UNIQUE KEY constraint 'IX_ModuleControls'. Cannot insert duplicate key in object 'dbo.ModuleControls'. Violation of UNIQUE KEY constraint 'IX_ModuleControls'. Cannot insert duplicate key in object 'dbo.ModuleControls'. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.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) /************************************************************/ /***** RegisterModule *****/ /***** *****/ /***** Use this script to register a module in the *****/ /***** database using Query Analyzer *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ exec dbo.[AddDesktopModule] @ModuleName = N'RNDViewInfo01', @FolderName = N'RNDViewInfo01', @FriendlyName = N'RNDViewInfo01', @Description = N'A RNDViewInfo01 module', @Version = N'01.00.00', @IsPremium = 0, @IsAdmin = 0, @BusinessController = N'ITansvar.Modules.RNDViewInfo01.RNDViewInfo01Controller', @SupportedFeatures = 3, @CompatibleVersions = NULL, @Dependencies = NULL, @Permissions = NULL declare @DesktopModuleId int select @DesktopModuleId = DesktopModuleId from dbo.[DesktopModules] where ModuleName = 'RNDViewInfo01' exec dbo.[AddModuleDefinition] @DesktopModuleId, @FriendlyName = N'RNDViewInfo01', @DefaultCacheTime = 0 declare @ModuleDefID int select @ModuleDefID = ModuleDefID from dbo.[ModuleDefinitions] where FriendlyName = 'RNDViewInfo01' exec dbo.[AddModuleControl] @ModuleDefID, @ControlKey = NULL, @ControlTitle = NULL, @ControlSrc = N'DesktopModules/RNDViewInfo01/ViewRNDViewInfo01.ascx', @IconFile = NULL, @ControlType = 0, @ViewOrder = NULL, @HelpUrl = NULL, @SupportsPartialRendering = 0 exec dbo.[AddModuleControl] @ModuleDefID, @ControlKey = 'Edit', @ControlTitle = 'Edit Content', @ControlSrc = N'DesktopModules/RNDViewInfo01/EditRNDViewInfo01.ascx', @IconFile = NULL, @ControlType = 1, @ViewOrder = NULL, @HelpUrl = NULL, @SupportsPartialRendering = 0 exec dbo.[AddModuleControl] @ModuleDefID, @ControlKey = 'Settings', @ControlTitle = 'RNDViewInfo01 Settings', @ControlSrc = N'DesktopModules/RNDViewInfo01/Settings.ascx', @IconFile = NULL, @ControlType = 1, @ViewOrder = NULL, @HelpUrl = NULL, @SupportsPartialRendering = 0 |
| Slut jobb |
Klar Sql exekvering: RNDViewInfo01.SqlDataProvider fil |
| |
| Slut jobb |
Klar Sql exekvering |
The sourcefile RNDViewInfo01.SqlDataProvider
/************************************************************/
/***** RegisterModule *****/
/***** *****/
/***** Use this script to register a module in the *****/
/***** database using Query Analyzer *****/
/***** *****/
/***** *****/
/***** Note: To manually execute this script you must *****/
/***** perform a search and replace operation *****/
/***** for {databaseOwner} and {objectQualifier} *****/
/***** *****/
/************************************************************/
exec {databaseOwner}[{objectQualifier}AddDesktopModule]
@ModuleName = N'RNDViewInfo01',
@FolderName = N'RNDViewInfo01',
@FriendlyName = N'RNDViewInfo01',
@Description = N'A RNDViewInfo01 module',
@Version = N'01.00.00',
@IsPremium = 0,
@IsAdmin = 0,
@BusinessController = N'ITansvar.Modules.RNDViewInfo01.RNDViewInfo01Controller',
@SupportedFeatures = 3,
@CompatibleVersions = NULL,
@Dependencies = NULL,
@Permissions = NULL
declare @DesktopModuleId int
select @DesktopModuleId = DesktopModuleId
from {databaseOwner}[{objectQualifier}DesktopModules]
where ModuleName = 'RNDViewInfo01'
exec {databaseOwner}[{objectQualifier}AddModuleDefinition] @DesktopModuleId,
@FriendlyName = N'RNDViewInfo01',
@DefaultCacheTime = 0
declare @ModuleDefID int
select @ModuleDefID = ModuleDefID
from {databaseOwner}[{objectQualifier}ModuleDefinitions]
where FriendlyName = 'RNDViewInfo01'
exec {databaseOwner}[{objectQualifier}AddModuleControl]
@ModuleDefID,
@ControlKey = NULL,
@ControlTitle = NULL,
@ControlSrc = N'DesktopModules/RNDViewInfo01/ViewRNDViewInfo01.ascx',
@IconFile = NULL,
@ControlType = 0,
@ViewOrder = NULL,
@HelpUrl = NULL,
@SupportsPartialRendering = 0
exec {databaseOwner}[{objectQualifier}AddModuleControl]
@ModuleDefID,
@ControlKey = 'Edit',
@ControlTitle = 'Edit Content',
@ControlSrc = N'DesktopModules/RNDViewInfo01/EditRNDViewInfo01.ascx',
@IconFile = NULL,
@ControlType = 1,
@ViewOrder = NULL,
@HelpUrl = NULL,
@SupportsPartialRendering = 0
exec {databaseOwner}[{objectQualifier}AddModuleControl]
@ModuleDefID,
@ControlKey = 'Settings',
@ControlTitle = 'RNDViewInfo01 Settings',
@ControlSrc = N'DesktopModules/RNDViewInfo01/Settings.ascx',
@IconFile = NULL,
@ControlType = 1,
@ViewOrder = NULL,
@HelpUrl = NULL,
@SupportsPartialRendering = 0
/Johan www.nätdejting.nu
|
| |
|
|