Upgrade to Newest SmarterTrack Error
Problem reported by Ron Raley - 12/3/2018 at 8:16 AM
SmarterTrack - SmarterTrack 100.0                        
Your database is being upgraded.
This page will refresh every few seconds to show the progress.
Error executing the following:

Column 'BrandID' cannot be null

Problem: MySql.Data.MySqlClient.MySqlException (0x80004005): Column 'BrandID' cannot be null
   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.ExecuteNonQuery(IDbConnection& conn, String query, SqlParameter[] parameters)
   at SmarterTrack.Data.Database.QueryTask.Execute(DBProperties props)
   at SmarterTrack.HelperClasses.Threads.DatabaseUpgradeThread.UpdateDB(DBProperties props)
   at SmarterTrack.HelperClasses.Threads.DatabaseUpgradeThread.ThreadFunc()

I have uninstalled and gone back to Smartrack 14 for the time being.

3 Replies

Reply to Thread
Eric McCarthy Replied
Employee Post
We have identified the issue. We will be starting a ticket with you shortly to provide you with a resolution for this issue.
Eric McCarthy
Software Developer
SmarterTools Inc.
(877) 357-6278
Ron Raley Replied
I was able to locate more information in the logs.  By setting BrandID to 1 from NULL on a table (I forget which one).  We fixed the issue.
Andrew Barker Replied
Employee Post Marked As Resolution
A fix was added to SmarterTrack build 6922, which was released on December 14.

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

Reply to Thread