Upgrade to Newest SmarterTrack Error
Problem reported by Ronald Raley - December 3 at 8:16 AM
Being Fixed
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.

2 Replies

Reply to Thread
0
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
www.smartertools.com
0
Ronald 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.

Reply to Thread