Ask a Question

I installed this one as 7.0.1 and ive upgraded it until 7.2.1

However during the last upgrade, things really messed up with errors.

Ive checked the upg error log and upon 7.1.1 it shows this:

System.Data.SqlClient.SqlException (0x80131904): The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.TabSettings' and the index name 'PK_TabSettings'. The duplicate key value is (55, CacheDuration).
Could not create constraint. See previous errors.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(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:b32820ea-054f-4e48-8613-846ef9027167

/***** Fix bug 27258: add the primary key. *****/
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'PK_TabSettings') AND xtype = 'PK')
BEGIN
ALTER TABLE dbo.TabSettings ADD CONSTRAINT [PK_TabSettings] PRIMARY KEY NONCLUSTERED ([TabID], [SettingName])
END


7.1.2 has an empty logfile.
7.2.0 has these errors:

System.Data.SqlClient.SqlException (0x80131904): Cannot drop the index 'dbo.Packages.IX_Packages', because it does not exist or you do not have permission.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(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:6558573b-63ac-40a3-b0a0-e67f961ea809

DROP INDEX IX_Packages ON dbo.[Packages]


7.1.2 shows with empty logfile.


The reason it was brought to my attention is, that during upgrade to 7.2.1, upgrade was halted by errors, so I refreshed the page, then it got a bit further but was again halted with errors, I did another refresh and it finished upgrading.

The site do run and so far I haven't found anything not working, besides weird things like when I update an export a lang pack, it shows as version 7.1.2 and not 7.2.1

I tried other sites which I have just upgraded as well (with no errors) and they show lang pack file version 7.2.1 so apparently its supposed to be like that.

Needless to say, my question is, is the problem fixable? As in can someone tell me like "Just erase that, copy this and edit that and that shd be it" or would it be easier to export all content, do a fresh install and import the content afterwards?

If so, then how do I export the users and roles?
Also how do I export the data from the Events module?

Thx