I get the following error each time I try to execute a query
System.FormatException Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). Stack Trace: at System.Guid..ctor(String g) at MySql.Data.Types.MySqlGuid.MySql.Data.Types.IMySqlValue.ReadValue(MySqlPacket packet, Int64 length, Boolean nullVal) at MySql.Data.MySqlClient.NativeDriver.ReadColumnValue(Int32 index, MySqlField field, IMySqlValue valObject) at MySql.Data.MySqlClient.ResultSet.ReadColumnData(Boolean outputParms) at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlDataReader.Read() at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
I tried deleting the default.tss file as another post advises but it didn't work.
Below is a DESC of on of the tables. We have many tables that use char(36) as the field type but it doesn't mean we have a GUID in there. All the queries used to work on Toad 4.5 but not on version 5.
Field Type Null Key Default Extra id char(36) NO PRI client_id char(36) NO MUL patron_id char(36) NO date_time datetime YES type varchar(50) YES description longtext YES link_info varchar(150) YES source varchar(300) YES
...just to confirm, the fields are defined as char 36, allowing nulls. If the value is null or in GUID format, everything works. If the value is not null and not in GUID format we see the error described above.