Hi,

I cannot create a page to be viewable by all users. It throws the following exception. DNN 8.0.2

AbsoluteURL:/Default.aspx

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:30569950-e094-4124-b258-19dbb4be60dd

AssemblyVersion:8.0.2

PortalId:0

UserId:2

TabId:124

RawUrl:/Admin/Pages

Referrer:http://vsstoregraphics-stage.azurewebsites.net/Admin/Pages

UserAgent:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/601.5.17 (KHTML, like Gecko) Version/9.1 Safari/601.5.17

ExceptionHash:JOn9dIhY+v1wEHILnLI3Sg==

Message:Cannot insert duplicate key row in object 'dbo.TabPermission' with unique index 'IX_TabPermission_Users'. The duplicate key value is (, 91, 3). The statement has been terminated.

StackTrace:

InnerMessage:Cannot insert duplicate key row in object 'dbo.TabPermission' with unique index 'IX_TabPermission_Users'. The duplicate key value is (, 91, 3). The statement has been terminated.

InnerStackTrace:

   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at PetaPoco.Database.ExecuteScalar[T](String sql, Object[] args)
   at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteScalar[T](String connectionString, CommandType type, Int32 timeout, String sql, Object[] args)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScalar[T](String procedureName, Object[] commandParameters)
   at DotNetNuke.Data.DataProvider.AddTabPermission(Int32 tabId, Int32 permissionId, Int32 roleID, Boolean allowAccess, Int32 userId, Int32 createdByUserID)
   at DotNetNuke.Security.Permissions.PermissionProvider.SaveTabPermissions(TabInfo tab)
   at DotNetNuke.Security.Permissions.TabPermissionController.SaveTabPermissions(TabInfo tab)
   at DotNetNuke.Entities.Tabs.TabController.UpdateTab(TabInfo updatedTab)
   at Dnn.Modules.Tabs.View.CmdUpdateClick(Object sender, EventArgs e)
   at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
   at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Sebastian,

I recently upgraded form 7.3.2 to 8.0.1.

I have not specifically modified the "tabPermission" table. I just tried to modify other pages permissions using the page management section. Adding registered users or removing and I get the same error. I tried using only a admin account instead of a super user, same error. It's like I cannot change any permissions on the pages or new pages.

Any idea on what is wrong? Something from the upgrade I am suspecting.

ok. No problem. Let me know the next step when you can.