Toad World® Forums

TDA v2.7 MySQL Error in DATETIME field


#1

Good day, again.

I’m writing to report the following error in TDA v2.7 when querying a MySQL 5.1 Database (direct connection) with a DATETIME field having the value: 0000-00-00 00:00:00

I got this error:


MySql.Data.Types.MySqlConversionException
Unable to convert MySQL date/time value to System.DateTime
Stack Trace:
en MySql.Data.Types.MySqlDateTime.GetDateTime()
en MySql.Data.MySqlClient.MySqlDataReader.GetValue(Int32 i)
en Quest.Toad.Db.Connection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler)
en Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()


If I run the query without this field, it works OK! But, when I use SELECT * or SELECT DATE_CHECK_OUT (the field having 0000-00-00 00:00:00) I get the error showed above.

Maybe it is a TDA v2.7 bug. Could you guys please take a look at this?

Thanks in advance.
Oscar.


#2

I entered CR81549 for this issue. I do not get this issue when I test. What version of mySQL are you using. I know you have said before but I forget.

Debbie


#3

Hello, Debbie

I’m using MySQL 5.1.41 querying MyISAM tables. The field that launches the error is defined as: DATETIME NOT NULL and DEFAULT VALUE 0000-00-00 00:00:00

In phpMyAdmin the query runs OK, but I’m getting the error when using TDA v2.7 to run the same query.

Hope this helps! Please let me know if you need additional info.

Best Regards,
Oscar.


#4

Hello all,

I was testing this issue again, using TDA 3.0 BETA, and it is working fine now!!!

However, still getting the same behaviour in TDA 2.7.

Good news!!! TDA 3.0 ROCKS!!!

Best regards,
Oscar.


#5

Yay. Glad to hear it is working for you.

Debbie