|
Replies:
6
-
Pages:
1
-
Last Post:
Apr 19, 2011 12:25 PM
by: Syncnite
|
|
|
Posts:
38
Registered:
5/15/09
|
|
|
|
MySql.Data.Types.MySqlConversionException Toad 5.0.0.345
Posted:
Oct 27, 2010 3:41 PM
|
|
|
When trying to see data from the grid for a table that includes timestamp columns:
|
|
|
Posts:
38
Registered:
5/15/09
|
|
|
|
Re: MySql.Data.Types.MySqlConversionException Toad 5.0.0.345
Posted:
Oct 28, 2010 12:11 PM
in response to: Backberry
|
|
|
It looks like the issue happens when there is more than one timestamp column declared in the table. This does not happens on version 4.6.0.531.
|
|
|
Posts:
1
Registered:
10/29/10
|
|
|
|
Re: MySql.Data.Types.MySqlConversionException Toad 5.0.0.345
Posted:
Oct 29, 2010 12:34 AM
in response to: Backberry
|
|
|
Happens also with only 1 datetime column in the table. Seems to be an issue with specific data in the table or column. For a different table with a datetime column it displays the data.
Just found out that for the table with one datetime column (NOT NULL) it was because of the default value of "0001-01-01 00:00:00" in one row. I added the column later after creating the table.
For the table with 2 datetime columns i guess it may be because of NULLs in one column?
I installed v5.0 because i wanted to see if the refresh button works better now in the database explorer (it only refreshes right/data side if the focus is on the left/table side) but it works as poor as before with v4.6...
|
|
|
Posts:
14
Registered:
6/11/10
|
|
|
|
Re: MySql.Data.Types.MySqlConversionException Toad 5.0.0.345
Posted:
Oct 29, 2010 11:02 AM
in response to: Backberry
|
|
|
Just want to ditto this. I hope the toad team will get this fixed soon because otherwise I'm sticking to 4.0+ at least with v4 I can still get work done.
|
|
|
|
|
|
|
Re: MySql.Data.Types.MySqlConversionException Toad 5.0.0.345
Posted:
Feb 15, 2011 10:28 AM
in response to: Backberry
|
|
|
Fixing my data that had all zeros for the required date columns solved this problem for me.
|
|
|
Posts:
314
Registered:
8/23/07
|
|
|
|
Re: MySql.Data.Types.MySqlConversionException Toad 5.0.0.345
Posted:
Feb 15, 2011 1:00 PM
in response to: Stacy
|
|
|
The new 6.0 beta of Toad for MySQL should also handle this problem correctly.
/Henrik
|
|
|
Posts:
1
Registered:
4/19/11
|
|
|
|
Re: MySql.Data.Types.MySqlConversionException Toad 5.0.0.345
Posted:
Apr 19, 2011 12:25 PM
in response to: Mauritz
|
|
|
I just downloaded the beta version (6.0) specifically due to this annoying bug. Happily, it appears to be fixed in this version.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
