Error upgrading database

Problem reported by John Dobbin - 7/26/2018 at 7:18 AM

Submitted

Attempting to upgrade SmarterTrack from 13.1.6746 to 14.1.6773 using MysQL(server version 5.7) on shared hosting and getting an error:

Error executing the following:

Duplicate column name 'RespondingIP'

Problem: MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate column name 'RespondingIP'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at SmarterTrack.Data.DataLayerShortcut.ExecuteNonQueryWithWait(String query, SqlParameter[] parameters)
   at SmarterTrack.Data.Database.AlterTableTask.Execute(DBProperties props)
   at SmarterTrack.HelperClasses.Threads.DatabaseUpgradeThread.#Bvo(DBProperties #sPi)
   at SmarterTrack.HelperClasses.Threads.DatabaseUpgradeThread.ThreadFunc()

Reverting back to 13 for the moment, any ideas?

2 Replies

Reply to Thread

Eric McCarthy Replied

7/26/2018 at 7:22 AM

Employee Post

With the limited info, this looks like it could be an issue with the storage of the schema version. In order to properly assist you we recommend opening a support ticket for personalized support.

If you are reverting back without using a Database backup from before the update, there will be issues. SmarterTrack 14 changed the way related items are stored in the Database, so rolling back without that backup will cause issues with your related items.

Eric McCarthy Software Developer SmarterTools Inc. www.smartertools.com

John Dobbin Replied

7/26/2018 at 8:13 AM

I was able to revert back both the files and the database.

Back to Community Threads

Please leave this box unchecked

2 Replies

Reply to Thread

Tags

Related Knowledge Base Articles