Error upgrading database
Problem reported by John Dobbin - 7/26/2018 at 7:18 AM
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
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.
(877) 357-6278
John Dobbin Replied
I was able to revert back both the files and the database.

Reply to Thread