ERROR! - smartertrack 12.x install/upgrade to latest
Problem reported by Jon Eastwood - June 19 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
0
Jon Eastwood Replied
0
Andrew Barker Replied
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

0
Jon Eastwood Replied
versio: 5.5.49
0
Jon Eastwood Replied
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?
0
Andrew Barker Replied
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

0
Jon Eastwood Replied
when will that be as right now I have a customers web site that no longer has live chat!
0
Andrew Barker Replied
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

0
Jon Eastwood Replied
cheers all done and back working thanks

Reply to Thread