Hi - I'm new to DNN. I have developed my first module on a local install of DNN and it works fine. I'm now trying to load it onto the clients DNN install and I'm getting the following error...
| Error loading files from temporary folder - see below |
| StartJob |
Starting Installation |
| Info |
Starting Installation - Products |
| Info |
Starting Installation - Script |
| Info |
Begin Sql execution |
| Info |
Creating backup of previous version - Products.SqlDataProvider |
| Info |
Created - Products.SqlDataProvider |
| Info |
Executing Products.SqlDataProvider |
| Info |
Start Sql execution: Products.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near '@CompatibleVersions'. An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. 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 dnna_ *****/ /***** *****/ /************************************************************/ exec dbo.[dnna_AddDesktopModule] @ModuleName = N'Products', @FolderName = N'Products', @FriendlyName = N'Products', @Description = N'A Products module', @Version = N'01.00.00', @IsPremium = 0, @IsAdmin = 0, @BusinessController = N'SipidCode.Modules.Products.ProductsController', @SupportedFeatures = 3 @CompatibleVersions = "" @Dependencies = "" @Permissions = "" declare @DesktopModuleId int select @DesktopModuleId = DesktopModuleId from dbo.[dnna_DesktopModules] where ModuleName = 'Products' exec dbo.[dnna_AddModuleDefinition] @DesktopModuleId, @FriendlyName = N'Products', @DefaultCacheTime = 0 declare @ModuleDefID int select @ModuleDefID = ModuleDefID from dbo.[dnna_ModuleDefinitions] where FriendlyName = 'Products' exec dbo.[dnna_AddModuleControl] @ModuleDefID, @ControlKey = NULL, @ControlTitle = NULL, @ControlSrc = N'DesktopModules/Products/ViewProducts.ascx', @IconFile = NULL, @ControlType = 0, @ViewOrder = NULL, @HelpUrl = NULL exec dbo.[dnna_AddModuleControl] @ModuleDefID, @ControlKey = 'Edit', @ControlTitle = 'Edit Content', @ControlSrc = N'DesktopModules/Products/EditProducts.ascx', @IconFile = NULL, @ControlType = 1, @ViewOrder = NULL, @HelpUrl = NULL exec dbo.[dnna_AddModuleControl] @ModuleDefID, @ControlKey = 'Settings', @ControlTitle = 'Products Settings', @ControlSrc = N'DesktopModules/Products/Settings.ascx', @IconFile = NULL, @ControlType = 1, @ViewOrder = NULL, @HelpUrl = NULL |
| Info |
End Sql execution: Products.SqlDataProvider file |
| Info |
Finished Sql execution |
| Failure |
Installation Failed - Script |
| Info |
Installation Failed - Products |
| Info |
Deleted temporary install folder |
| EndJob |
Installation Failed |
|
Here is the SQL that is trying to run on my install...
exec {databaseOwner}[{objectQualifier}AddDesktopModule]
@ModuleName = N'Products',
@FolderName = N'Products',
@FriendlyName = N'Products',
@Description = N'A Products module',
@Version = N'01.00.00',
@IsPremium = 0,
@IsAdmin = 0,
@BusinessController = N'SipidCode.Modules.Products.ProductsController',
@SupportedFeatures = 3
@CompatibleVersions = ""
@Dependencies = ""
@Permissions = ""
declare @DesktopModuleId int
select @DesktopModuleId = DesktopModuleId
from {databaseOwner}[{objectQualifier}DesktopModules]
where ModuleName = 'Products'
exec {databaseOwner}[{objectQualifier}AddModuleDefinition] @DesktopModuleId,
@FriendlyName = N'Products',
@DefaultCacheTime = 0
declare @ModuleDefID int
select @ModuleDefID = ModuleDefID
from {databaseOwner}[{objectQualifier}ModuleDefinitions]
where FriendlyName = 'Products'
exec {databaseOwner}[{objectQualifier}AddModuleControl]
@ModuleDefID,
@ControlKey = NULL,
@ControlTitle = NULL,
@ControlSrc = N'DesktopModules/Products/ViewProducts.ascx',
@IconFile = NULL,
@ControlType = 0,
@ViewOrder = NULL,
@HelpUrl = NULL
exec {databaseOwner}[{objectQualifier}AddModuleControl]
@ModuleDefID,
@ControlKey = 'Edit',
@ControlTitle = 'Edit Content',
@ControlSrc = N'DesktopModules/Products/EditProducts.ascx',
@IconFile = NULL,
@ControlType = 1,
@ViewOrder = NULL,
@HelpUrl = NULL
exec {databaseOwner}[{objectQualifier}AddModuleControl]
@ModuleDefID,
@ControlKey = 'Settings',
@ControlTitle = 'Products Settings',
@ControlSrc = N'DesktopModules/Products/Settings.ascx',
@IconFile = NULL,
@ControlType = 1,
@ViewOrder = NULL,
@HelpUrl = NULL
It's failing the first SP [AddDesktopModule]. I know that cause I've tried to manually run it as well and I get the same error.
Any help would be greatly appreciated as I'm a little lost (or a lot lost :-) )