 |
|
|
|
Joined: 10/22/2005
Posts: 20
|
|
|
Hi,
I waited as long as I could but I still cannot get our site past the DNN-6601 error.
Sebastian, I tried the full DNNTurbo script, although it had errors. It created the portal, but we are still locked out and it is getting to be mission critical. There is a new beta but no upgrade to 7.4.1. There is a 7.5.0 alpha, but it is the full install and alpha only. But can I use this alpha on top of our entire site to make it so we can get past this bug?
Here is the current error...
" at DotNetNuke.Security.Permissions.PermissionProvider.DefaultImplicitRoles(Int32 portalId)
at DotNetNuke.Security.Permissions.PermissionProvider.ImplicitRolesForPages(Int32 portalId)
at DotNetNuke.Security.Permissions.Controls.TabPermissionsGrid.IsImplicitRole(Int32 portalId, Int32 roleId)
at DotNetNuke.Security.Permissions.Controls.TabPermissionsGrid.GetEnabled(PermissionInfo objPerm, RoleInfo role, Int32 column)
at DotNetNuke.Security.Permissions.Controls.PermissionsGrid.BindRolesGrid()
at DotNetNuke.Security.Permissions.Controls.PermissionsGrid.BindData()
at DotNetNuke.Security.Permissions.Controls.PermissionsGrid.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Source:"
|
| |
|
|
 | |
|
|
|
Joined: 10/22/2005
Posts: 20
|
|
|
Here is the error with the DNNTurbo script... maybe something is missing.
This is really a MAJOR issue for us now (not about DNNTurbo but about this terrible bug), as we have updates we need to do to the site. So any suggestions on this would be appreciated. I have spent many hours on this.
System.Data.SqlClient.SqlException (0x80131904): Column 'PropertyKey' in table 'dbo.UserProfile' cannot be used in an index or statistics or as a partition key because it is non-deterministic.
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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)
ClientConnectionId:f4b0ad02-2b36-4e5d-977a-93609c8b169f
-- Lookup Index for Lists data type:
CREATE NONCLUSTERED INDEX [IX_UserProfile_PropertyKey] ON dbo.[UserProfile]
([PropertyDefinitionID],[PropertyKey])
INCLUDE ([UserID])
System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_Roles'. Cannot insert duplicate key in object 'dbo.Roles'. The duplicate key value is (0).
Violation of PRIMARY KEY constraint 'PK_Roles'. Cannot insert duplicate key in object 'dbo.Roles'. The duplicate key value is (1).
The statement has been terminated.
The statement has been terminated.
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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)
ClientConnectionId:f4b0ad02-2b36-4e5d-977a-93609c8b169f
-- temporary fix:
etc...
|
| |
|
|
| |
|
|
|
Steve,
I am sorry that you are experiencing issues with TurboDNN, I tested it on a couple of sites - but there are so many different Environments, making it hard to take every case into account. Which Version of SQL Server are you running in which Environment? Did you try applying TurboDBConfig740.sql (re-apply TurboDNN afterwards). Please post full error message in Issues area on dnnscript.Codeplex.com
Regarding the first error:
- what is data type of column PropertyValue in table UserProfile?
- what is data type of calculated column PropertyKey in table UserProfile (this column is specific for TurboDNN to improve Joins with Lists table)
The error will not affect function of the site, but performance in membership directory with many users.
Regarding the 2nd error:
it looks like there are roles left over from the deleted portal (integrity checks in DNN database are a mess). This error should be fixed upon 2nd run of the script (unfortunately the integrity checks are added further down in the script)
|
| |
|
|
| |
|
|
|
Joined: 10/22/2005
Posts: 20
|
|
|
Hi Sebastian,
Of course I understand many different environments. We deal with that all the time!
PropertyValue is shown as nvarchar(3750)
PropertyKey does not have a data type. It is empty. In the Computed Column Specification it shows (TRY_CAST(substring([PropertyValue],(1),(11)) AS [int]))
I did run the TurboDBConfig740.sql file first just fine, then the TurboDNN740.sql file. It gave the error the first time, and then the 2nd time it ran OK. The dummy portal is created, but I am still locked out like before.
RoleID PortalID RoleName
0 1 Administrators Portal Administration
1 1 Registered Users Registered Users
2 1 Subscribers A public role for site subscriptions
3 1 Unverified Users Unverified Users
Then a few custom roles at 4 and 5, and then some -1, -2, -3 that are for:
-1 NULL All Users
-2 NULL Super Users
-3 NULL Unauthenticated Users
So 0 is the Administrator role. Should the table allow for duplicate columns for the RoleID if the PortalID is different?
Thanks,
Steve
|
| |
|
|
| |
|
|
|
Joined: 10/22/2005
Posts: 20
|
|
|
I did discover after applying the fix which added the new portal to the database that now I get this: See the bold text.
Message:Object reference not set to an instance of an object.
StackTrace:
InnerMessage:Object reference not set to an instance of an object.
InnerStackTrace:
at DotNetNuke.Security.Permissions.Controls.TabPermissionsGrid.<>c__DisplayClass1.b__0(RoleInfo r)
at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source, Func`2 predicate)
at DotNetNuke.Security.Permissions.Controls.TabPermissionsGrid.IsImplicitRole(Int32 portalId, Int32 roleId)
at DotNetNuke.Security.Permissions.Controls.TabPermissionsGrid.GetEnabled(PermissionInfo objPerm, RoleInfo role, Int32 column)
at DotNetNuke.Security.Permissions.Controls.PermissionsGrid.BindRolesGrid()
at DotNetNuke.Security.Permissions.Controls.PermissionsGrid.BindData()
at DotNetNuke.Security.Permissions.Controls.PermissionsGrid.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
|
| |
|
|
| |