Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...4.0.3 to 4.3.0 upgrade problem4.0.3 to 4.3.0 upgrade problem
Previous
 
Next
New Post
6/15/2006 8:14 AM
 

I tried to upgrade dnn 4.0.3 to 4.3.0 and it looked like it worked, but when I go to "Manage profile properties" or "User settings" at the User accounts, nothing appears on my screen.

I checked the log and it said:

Upgraded DotNetNuke: General
Warnings: Error: Violation of UNIQUE KEY constraint 'IX_DesktopModules_ModuleName'. Cannot insert duplicate key in object 'dbo.DesktopModules'. The statement has been terminated.
Server Naam: WWW

And:

AssemblyVersion: 04.03.00
Method: System.Data.SqlClient.SqlConnection.OnError
FileName:
FileLineNumber: 0
FileColumnNumber: 0
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
AbsoluteURL: /Install/Install.aspx
AbsoluteURLReferrer: http://##MYDOMAINNAME##/Install/Install.aspx?mode=Install
ExceptionGUID: b801b9ca-55ae-4c02-971b-5dbe3640a031
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
InnerException: Violation of UNIQUE KEY constraint 'IX_DesktopModules_ModuleName'. Cannot insert duplicate key in object 'dbo.DesktopModules'. The statement has been terminated.
Message: System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_DesktopModules_ModuleName'. Cannot insert duplicate key in object 'dbo.DesktopModules'. 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.SqlDataReader.ConsumeMetaData() 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddDesktopModule(String ModuleName, String FolderName, String FriendlyName, String Description, String Version, Boolean IsPremium, Boolean IsAdmin, String BusinessControllerClass, Int32 SupportedFeatures) at DotNetNuke.Entities.Modules.DesktopModuleController.AddDesktopModule(DesktopModuleInfo objDesktopModule) at DotNetNuke.Services.Upgrade.Upgrade.AddModuleDefinition(String DesktopModuleName, String Description, String ModuleDefinitionName, Boolean Premium, Boolean Admin, String Controller, String Version) at DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication()
StackTrace:
Source:
Server Naam: WWW

And:

AssemblyVersion: 04.03.00
Method: System.Data.ProviderBase.FieldNameLookup.GetOrdinal
FileName:
FileLineNumber: 0
FileColumnNumber: 0
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
ExceptionGUID: ed22d8bc-3756-4ab5-a193-8266f84017a5
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
InnerException: Unhandled Error:
Message: System.Exception: Unhandled Error: ---> System.IndexOutOfRangeException: DisplayName at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) at System.Data.SqlClient.SqlDataReader.get_Item(String name) at DotNetNuke.Security.Membership.AspNetMembershipProvider.FillUserInfo(Int32 portalId, IDataReader dr, Boolean isHydrated, Boolean CheckForOpenDataReader) at DotNetNuke.Security.Membership.AspNetMembershipProvider.GetUser(Int32 portalId, Int32 userId, Boolean isHydrated) at DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) at DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo objPortalAliasInfo) at DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --- End of inner exception stack trace ---
StackTrace:
Source:
Server Naam: WWW

Please HELP...


 
New Post
6/15/2006 9:13 AM
 

Hang on... I could only see this because I was still logged on.

Now I am logged of, and when I try to log in i get the well known:

A critical error has occured.
Object reference not set to an instance of an object.

 
New Post
6/15/2006 9:56 AM
 

(Update again)
I tried to login under a different (super) user account.
This one worked...
But this didn't solve all my problems of course.

There is still the matter of "profile properties" not working and "User settings" not working.
And it is a strange thing that after the upgrade my user account does not work anymore.

So there seems to be something wrong with the new DNN version...(or at least the upgrade)

 
New Post
6/15/2006 10:01 AM
 

(update again)
Now that I can log in with the other super user account, I tried to view the super users accounts under the host menu. I clicked on "all" and the paging function showed there were 6 pages, but there are no entries to be seen....

That is a very weird thing. I know that there are not six pages with super users, so why does it show that.
And why can't I see the super users?

 

 
New Post
6/15/2006 11:25 AM
 

(update again again)

I looked at the sql data provider log files and in 04.00.04.log I found:

System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Files_Folders". The conflict occurred in database "430netwerkpalliatievezorg", table "dbo.Folders", column 'FolderID'.
   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)


If (SELECT dbo.fn_GetVersion(3,2,3)) = 0
 BEGIN
 ALTER TABLE dbo.Files ADD CONSTRAINT
  FK_Files_Folders FOREIGN KEY
  (
  FolderID
  ) REFERENCES dbo.Folders
  (
  FolderID
  )
 END


System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.aspnet_Users' with unique index 'aspnet_Users_Index'.
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)


/* Transfer Users  */
/*******************/

If (SELECT dbo.fn_GetVersion(3,2,3)) = 0
 BEGIN
  --Create Temp Table to hold users
  CREATE TABLE dbo.TransferredUsers (
    [TransferredAppId] [uniqueidentifier] ,
    [Username] [nvarchar] (256) NULL
  )

  --Declare Variables
  DECLARE @PortalID int

  --Iterate through Portals to transfer users
  SELECT @PortalID = min(PortalID)
  FROM   dbo.Portals
  WHILE @PortalID IS NOT NULL
  BEGIN

   -- Transfer Portal Users
   EXECUTE TransferUsersToSameContext N'DotNetNuke', @PortalID

   SELECT @PortalID = min(PortalID)
   FROM   dbo.Portals
   WHERE  PortalID > @PortalID
  END

  -- Transfer Super Users
  EXECUTE TransferUsersToSameContext N'DotNetNuke', NULL

  --Drop temp objects
  DROP TABLE dbo.TransferredUsers
  DROP PROCEDURE dbo.TransferUsersToSameContext
 END

 

Does this ring a bell to someone?
What should I do?

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...4.0.3 to 4.3.0 upgrade problem4.0.3 to 4.3.0 upgrade problem


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out