TeslaLogger
TeslaLogger copied to clipboard
External DB after update (Object cannot be cast from DBNull to other types)
08.01.2024 01:59:54 : System.InvalidCastException: Object cannot be cast from DBNull to other types.
at System.DBNull.System.IConvertible.ToInt32 (System.IFormatProvider provider) [0x00000] in <533173d24dae460899d2b10975534bb0>:0
at System.Convert.ToInt32 (System.Object value, System.IFormatProvider provider) [0x00003] in <533173d24dae460899d2b10975534bb0>:0
at MySql.Data.MySqlClient.Driver.LoadCharacterSetsAsync (MySql.Data.MySqlClient.MySqlConnection connection, System.Boolean execAsync, System.Threading.CancellationToken cancellationToken) [0x0027e] in <9efbbc7dfea642918a697b5b4f171f76>:0
at MySql.Data.MySqlClient.Driver.ConfigureAsync (MySql.Data.MySqlClient.MySqlConnection connection, System.Boolean execAsync, System.Threading.CancellationToken cancellationToken) [0x00228] in <9efbbc7dfea642918a697b5b4f171f76>:0
at MySql.Data.MySqlClient.MySqlConnection.OpenAsync (System.Boolean execAsync, System.Threading.CancellationToken cancellationToken) [0x005f3] in <9efbbc7dfea642918a697b5b4f171f76>:0
at MySql.Data.MySqlClient.MySqlConnection.Open () [0x00012] in <9efbbc7dfea642918a697b5b4f171f76>:0
at System.Data.Common.DbDataAdapter.QuietOpen (System.Data.IDbConnection connection, System.Data.ConnectionState& originalState) [0x0000c] in :0
at System.Data.Common.DbDataAdapter.FillInternal (System.Data.DataSet dataset, System.Data.DataTable[] datatables, System.Int32 startRecord, System.Int32 maxRecords, System.String srcTable, System.Data.IDbCommand command, System.Data.CommandBehavior behavior) [0x0002d] in :0
at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable[] dataTables, System.Int32 startRecord, System.Int32 maxRecords, System.Data.IDbCommand command, System.Data.CommandBehavior behavior) [0x0007c] in :0
at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable) [0x00034] in :0
at (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter.Fill(System.Data.DataTable)
at TeslaLogger.SQLTracer.TraceDA (System.Data.DataTable dt, MySql.Data.MySqlClient.MySqlDataAdapter da, System.String callerFilePath, System.Int32 callerLineNumber) [0x0004c] in :0
at TeslaLogger.WebServer.GetAllCars (System.Net.HttpListenerRequest request, System.Net.HttpListenerResponse response) [0x0006e] in :0
Describe the bug After updating to the new version (around December 1st 2023), TeslaLogger can't connect to my database. My database is on an own server (hostname db).
To Reproduce Connect to an external teslalogger database through ConnectionString in TeslaLogger.exe.config
Expected behavior It should connect to the DB
** Teslalogger Type ** Debian 12 VM on ESXi Did you update the Image with apt-get update & upgrade? yes, but I also made a complete new installation.
** Do you use Tasker or iBeacon ** no
Additional context Add any other context about the problem here.
is this a duplicate of: https://github.com/bassmaster187/TeslaLogger/issues/1040