Problem with module permissions

Feb 3, 2010 at 2:01 PM


First of all, great provider impelmenting this missing permission and workflow functionality!

Iam am experencing a problem with the permissions set on a module.
Settings on page level seems fine. I then whant to limit the group from beeing able to manage module settings for the modules in the page.

I have set the Manage Settings to false (X) in the module. Also I have set Delete, Import, Export and Set Permissions to false (X).
Even so, I still get the Module Settings icon for the module, logged in as a memper of the restriced group.

Is this supposed to work like this or is it a bug?

Nov 1, 2010 at 1:22 PM


Nice work, but when i tried to install this module i got this error

StartJob Starting Installation
Info Starting Installation - OliverHine.CustomPermissionProvider
Info Starting Installation - Script
Info Begin Sql execution
Info Folder Created - D:\DNN\Providers\PermissionProviders\EnhancedPermissionProvider\
Info Created - 00.00.01.sqldataprovider
Info Executing 00.00.01.sqldataprovider
Info Start Sql execution: 00.00.01.sqldataprovider file
Info End Sql execution: 00.00.01.sqldataprovider file
Info Created - 00.00.04.sqldataprovider
Info Executing 00.00.04.sqldataprovider
Info Start Sql execution: 00.00.04.sqldataprovider file
Info End Sql execution: 00.00.04.sqldataprovider file
Info Created - 00.00.05.sqldataprovider
Info Executing 00.00.05.sqldataprovider
Info Start Sql execution: 00.00.05.sqldataprovider file
Info End Sql execution: 00.00.05.sqldataprovider file
Info Created - 00.00.06.sqldataprovider
Info Executing 00.00.06.sqldataprovider
Info Start Sql execution: 00.00.06.sqldataprovider file
Info End Sql execution: 00.00.06.sqldataprovider file
Info Created - 00.00.10.sqldataprovider
Info Executing 00.00.10.sqldataprovider
Info Start Sql execution: 00.00.10.sqldataprovider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.Workflow'. 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() 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) /* INSERT CONTENT APPROVAL WORKFLOW */ INSERT INTO dbo.[Workflow] ([WorkflowName], [Description], [IsDeleted]) VALUES('Content Approval', 'Require Approval before Publishing', 0) /************************************/ /* INSERT STAGES FOR CONTENT APPROVAL WORKFLOW */ DECLARE @TestingWorkflowID int SET @TestingWorkflowID = (select WorkflowId from dbo.[Workflow] where WorkflowName = 'Content Approval') INSERT INTO dbo.[WorkflowStates] (WorkflowID, StateName, [Order], IsActive, Notify) VALUES(@TestingWorkflowID,'Draft', 1, 1, 0) INSERT INTO dbo.[WorkflowStates] (WorkflowID, StateName, [Order], IsActive, Notify) VALUES(@TestingWorkflowID,'Pending Approval', 2, 1, 0) INSERT INTO dbo.[WorkflowStates] (WorkflowID, StateName, [Order], IsActive, Notify) VALUES(@TestingWorkflowID,'Published', 3, 1, 0) /**********************************************/ /* INSERT REVIEW PERMISSION */ INSERT INTO dbo.[Permission] (PermissionCode, ModuleDefID, PermissionKey, PermissionName, ViewOrder) VALUES ('WORKFLOW_MODULE',-1,'REVIEW','Review/Approve Content',0) /****************************/ /* INSERT APPROVER SECURITY ROLE */ INSERT INTO dbo.[Roles] (PortalID, RoleName, [Description]) VALUES (0,'Approver','used to approve content') /*********************************/ /* CREATE ROW FOR SECURITY CHECK AGAINST APPROVER ROLE ON THE STATE CREATED FOR THE TEST APPROVAL MODE */ DECLARE @TestingStateId int DECLARE @TestingPermissionId int DECLARE @TestingRoleId int SET @TestingStateId = (select StateID from dbo.[WorkflowStates] where StateName = 'Pending Approval') SET @TestingPermissionId = (select PermissionId from dbo.[Permission] where PermissionCode = 'WORKFLOW_MODULE' AND PermissionKey = 'REVIEW') SET @TestingRoleId = (select RoleID from dbo.[Roles] where RoleName = 'Approver') INSERT INTO dbo.[workflowstatepermission] (StateID, PermissionID, AllowAccess, RoleID) VALUES (@TestingStateId,@TestingPermissionId, 1, @TestingRoleId) /*******************************************************************************************************/ SET ANSI_NULLS ON
Info End Sql execution: 00.00.10.sqldataprovider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - OliverHine.CustomPermissionProvider
Info Deleted temporary install folder

Installation Failed



kind regards



Jan 17, 2011 at 7:12 PM
Edited Jan 17, 2011 at 7:13 PM

DNN HTML module 5.06  seems to ignore "content approval" workflow i tryed both version 0.0.16 and  0.0.134(from code page). I can  see all changes in item history but when i save changes i can`t see "Approve" and "Decline" buttons  and even "Publish" button is not shown when module is set to content approval workflow.

Is there a solution?

And one more thing - on a big portal its quet a big work to enable users to navigate to pages again - is there a way to change default settings to enable navigation to page by default?