When i upgraded my install to version 5 I have the following in the upgrade log
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_DNN_ModuleControls'. Cannot insert duplicate key in object 'dbo.DNN_ModuleControls'.
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)
.....
Error: Cannot insert duplicate key row in object 'dbo.DNN_PortalLanguages' with unique index 'IX_DNN_PortalLanguages'.
The statement has been terminated.
While the site has installed the English lanuge Australia this does not appear as a choice in portal site settings - or under user options.
I am also a little confused about the tabs that should appear under Admin. There are no icons for either Admin or Host. The Language tab appears as a page and opens a mudule but has nothing in it.
I have removed the portal alias error from site page by removing the module from the page. I understand this is the work around.
I am unable to export a template with or without content.
Thanks
Paul