ERROR! - smartertrack 12.x install/upgrade to latest

Problem reported by Jon Eastwood - 6/19/2018 at 11:26 PM

Resolved

just upgraded and now get this error!

Error executing the following:

Error on rename of '.\candc_help\st_customdatafieldsincustomtemplates' to '.\candc_help\#sql2-4f8-cc7235' (errno: 152)

Problem: MySql.Data.MySqlClient.MySqlException (0x80004005): Error on rename of '.\candc_help\st_customdatafieldsincustomtemplates' to '.\candc_help\#sql2-4f8-cc7235' (errno: 152)
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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()

8 Replies

Reply to Thread

Jon Eastwood Replied

6/20/2018 at 1:06 AM

Andrew Barker Replied

6/20/2018 at 7:56 AM

Employee Post

This appears to be the result of a bug in several versions of MySQL. What version are you currently using?

Andrew Barker Software Developer SmarterTools Inc. (877) 357-6278 www.smartertools.com

Jon Eastwood Replied

6/20/2018 at 8:09 AM

versio: 5.5.49

Jon Eastwood Replied

6/21/2018 at 1:06 AM

so how do we fix this?

I cant easily upgrade MYSQL as this is a live production server and cant simply put a new version of MYSQL

can i go back to a previous working copy/version?

Andrew Barker Replied

6/21/2018 at 3:22 PM

Employee Post

Since you pointed it out to us, we have found a way to work around this bug in MySQL 5.5. It will be included in our next SmarterTrack 14.0 update.

Andrew Barker Software Developer SmarterTools Inc. (877) 357-6278 www.smartertools.com

Jon Eastwood Replied

6/22/2018 at 1:05 AM

when will that be as right now I have a customers web site that no longer has live chat!

Andrew Barker Replied

6/25/2018 at 7:07 AM

Employee Post

As noted above, the fix for this was included in the latest SmarterTrack 14 update, which was released last Friday.

Andrew Barker Software Developer SmarterTools Inc. (877) 357-6278 www.smartertools.com

Jon Eastwood Replied

6/25/2018 at 7:34 AM

cheers all done and back working thanks

Back to Community Threads

Please leave this box unchecked

8 Replies

Reply to Thread

Tags

Related Knowledge Base Articles