Hey John,
Moved the NeatUpload in web.config and all is well on that front.
I tried to run the SQL and got the following error:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_DesktopModules_ModuleName'. Cannot insert duplicate key in object 'dbo.DesktopModules'. Cannot insert the value NULL into column 'DesktopModuleID', table 'dnndb.dbo.ModuleDefinitions'; column does not allow nulls. INSERT fails. Violation of UNIQUE KEY constraint 'IX_ModuleControls'. Cannot insert duplicate key in object 'dbo.ModuleControls'. Cannot insert the value NULL into column 'ModuleDefID', table 'dnndb.dbo.Modules'; column does not allow nulls. INSERT fails. 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.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) DECLARE @PortalId int DECLARE @TabId int DECLARE @TabOrder int DECLARE @IconFile varchar(50) DECLARE @TabViewPermissionId int DECLARE @TabEditPermissionId int DECLARE @AdminRoleId int DECLARE @AdminTabId int DECLARE @DesktopModuleId int DECLARE @ModuleDefId int DECLARE @ModuleId int DECLARE @ModuleViewPermissionId int DECLARE @ModuleEditPermissionId int -- Add the Admin Control as a module INSERT INTO dbo.[DesktopModules] ([FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures], [CompatibleVersions]) VALUES (N'PageBlaster Admin', 'Administrators can manage the PageBlaster configuration for their portal.', NULL, 0, 1, NULL,'PageBlaster Admin','PageBlaster', 0, NULL) SET @DesktopModuleId = SCOPE_IDENTITY() -- Add a Module Definition INSERT INTO dbo.[ModuleDefinitions] ([FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (N'PageBlaster Admin', @DesktopModuleId, 0) SET @ModuleDefId = SCOPE_IDENTITY() --add the PageBlaster Admin Control INSERT INTO dbo.[ModuleControls] ([ModuleDefID], [ControlKey], [ControlTitle], [ControlSrc], [IconFile], [ControlType], [ViewOrder], [HelpUrl]) VALUES (@ModuleDefId , NULL, NULL, 'DesktopModules/Snapsis/PageBlaster/PageBlasterAdminConfig.ascx', NULL, 0, NULL, 'http://www.snapsis.com/support.aspx') --Insert into Modules table INSERT INTO dbo.[Modules] ([ModuleDefID], [ModuleTitle], [AllTabs], [IsDeleted], [InheritViewPermissions], [Header], [Footer], [StartDate], [EndDate], [PortalID]) VALUES (@ModuleDefId ,'PageBlaster Admin', 0, 0, 1, NULL, NULL, NULL, NULL, NULL) SET @ModuleId = SCOPE_IDENTITY() DECLARE portal_cursor cursor FOR SELECT PortalId FROM dbo.Portals OPEN portal_cursor FETCH NEXT FROM portal_cursor INTO @PortalId WHILE @@FETCH_STATUS = 0 BEGIN IF NOT EXISTS (SELECT TabID FROM dbo.Tabs WHERE PortalId=@PortalId and TabName='PageBlaster' ) BEGIN --get the parent admin tabid SELECT @AdminTabId = Tabid FROM dbo.Tabs WHERE PortalId = @PortalId AND TabName='Admin' --get the Tab Order SELECT @TabOrder = Max(TabOrder) + 2 FROM dbo.Tabs WHERE PortalId = @PortalId --create a new Tab for the PageBlaster Admin Control INSERT INTO dbo.Tabs (PortalId,TabName,IsVisible,DisableLink,Level,TabOrder, ParentId,IconFile,Title,Description,KeyWords, IsDeleted,Url,SkinSrc,ContainerSrc,TabPath, StartDate,EndDate) VALUES (@PortalId,'PageBlaster',1,0,1,@TabOrder, @AdminTabId,'../DesktopModules/Snapsis/PageBlaster/Images/PBICON16.gif','PageBlaster','','',0, '',NULL,NULL,'//Admin//PageBlaster', NULL,NULL ) SET @TabId = SCOPE_IDENTITY() --Put a PageBlaster Module on the tab INSERT INTO dbo.[TabModules] ([TabID], [ModuleID], [PaneName], [ModuleOrder], [CacheTime], [Alignment], [Color], [Border], [IconFile], [Visibility], [ContainerSrc], [DisplayTitle], [DisplayPrint], [DisplaySyndicate]) VALUES (@TabId, @ModuleId,'ContentPane', 0, 0, NULL,'','','~/DesktopModules/Snapsis/PageBlaster/Images/PBICON32.gif', 0, NULL, 1, 0, 0) --get the administrator roleid SELECT DISTINCT @AdminRoleId = RoleId FROM dbo.Roles WHERE RoleName = 'Administrators' AND PortalId = @PortalId --Get the System Permission IDs for the Tab and module SELECT DISTINCT @TabViewPermissionId = PermissionId FROM dbo.Permission WHERE PermissionCode = 'SYSTEM_TAB' AND PermissionKey = 'VIEW' SELECT DISTINCT @TabEditPermissionId = PermissionId FROM dbo.Permission WHERE PermissionCode = 'SYSTEM_TAB' AND PermissionKey = 'EDIT' SELECT DISTINCT @ModuleViewPermissionId = PermissionId FROM dbo.Permission WHERE PermissionCode = 'SYSTEM_MODULE_DEFINITION' AND PermissionKey = 'VIEW' SELECT DISTINCT @ModuleEditPermissionId = PermissionId FROM dbo.Permission WHERE PermissionCode = 'SYSTEM_MODULE_DEFINITION' AND PermissionKey = 'EDIT' --Add permissions for the Tab INSERT INTO dbo.TabPermission (TabId,PermissionId,RoleId,AllowAccess) VALUES (@TabId,@TabViewPermissionId,@AdminRoleId,1) INSERT INTO dbo.TabPermission (TabId,PermissionId,RoleId,AllowAccess) VALUES (@TabId,@TabEditPermissionId,@AdminRoleId,1) --Add permissions for the Module INSERT INTO dbo.ModulePermission (ModuleId,PermissionId,RoleId,AllowAccess) VALUES (@ModuleId,@ModuleViewPermissionId,@AdminRoleId,1) INSERT INTO dbo.ModulePermission (ModuleId,PermissionId,RoleId,AllowAccess) VALUES (@ModuleId,@ModuleEditPermissionId,@AdminRoleId,1) END FETCH NEXT FROM portal_cursor INTO @PortalId END CLOSE portal_cursor DEALLOCATE portal_cursor
Any thoughts?
|