When I add a new module by adding a project from VS 2005 menu: File >> Add >> New Project >> Selecting Visual Basic >> Web >> My Templates >> DotNetNuke Compiled Module .... using the modulename: ITARedirect .... then the file generated with namne: ITARedirect.SqlDataProvider is having some old stored procedure inside of it ... because when you later try to install a built module the installation process in dotnetnuke are complaining about:

StartJob Start Sql execution: ITARedirect.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException:

Procedure or function 'AddDesktopModule' expects parameter '@CompatibleVersions', which was not supplied. Cannot insert the value NULL into column 'DesktopModuleID', table 'C:\INETPUB\DOTNETNUKE_04_08_01_INSTALL\APP_DATA\DATABASE.MDF.dbo.ModuleDefinitions'; column does not allow nulls. INSERT fails.

Procedure or function 'AddModuleControl' expects parameter '@SupportsPartialRendering', which was not supplied. Procedure or function 'AddModuleControl' expects parameter '@SupportsPartialRendering', which was not supplied.

Procedure or function 'AddModuleControl' expects parameter '@SupportsPartialRendering', which was not supplied. The statement has been terminated. 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) /************************************************************/ /***** 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'ITARedirect', @FolderName = N'ITARedirect', @FriendlyName = N'ITARedirect', @Description = N'A ITARedirect module', @Version = N'01.00.00', @IsPremium = 0, @IsAdmin = 0, @BusinessController = N'ITAnsvar.Modules.ITARedirect.ITARedirectController', @SupportedFeatures = 3 declare @DesktopModuleId int select @DesktopModuleId = DesktopModuleId from dbo.[DesktopModules] where ModuleName = 'ITARedirect' exec dbo.[AddModuleDefinition] @DesktopModuleId, @FriendlyName = N'ITARedirect', @DefaultCacheTime = 0 declare @ModuleDefID int select @ModuleDefID = ModuleDefID from dbo.[ModuleDefinitions] where FriendlyName = 'ITARedirect' exec dbo.[AddModuleControl] @ModuleDefID, @ControlKey = NULL, @ControlTitle = NULL, @ControlSrc = N'DesktopModules/ITARedirect/ViewITARedirect.ascx', @IconFile = NULL, @ControlType = 0, @ViewOrder = NULL, @HelpUrl = NULL exec dbo.[AddModuleControl] @ModuleDefID, @ControlKey = 'Edit', @ControlTitle = 'Edit Content', @ControlSrc = N'DesktopModules/ITARedirect/EditITARedirect.ascx', @IconFile = NULL, @ControlType = 1, @ViewOrder = NULL, @HelpUrl = NULL exec dbo.[AddModuleControl] @ModuleDefID, @ControlKey = 'Settings', @ControlTitle = 'ITARedirect Settings', @ControlSrc = N'DesktopModules/ITARedirect/Settings.ascx', @IconFile = NULL, @ControlType = 1, @ViewOrder = NULL, @HelpUrl = NULL EndJob End Sql execution: ITARedirect.SqlDataProvider file

Is there a fix for this? ... can someone provide the correct stored procedure that should be inside this module ?

/Johan

Nätdejting
Personalrekrytering
Konferenslokaler
Solkräm
Kassasystem
Rekrytering

thanks for posting the solution it helped me :)