Page 1 of 1
MySQL connector in v7.4 breaks DATE_FORMAT() in MySQL 5.0
Posted: Wed Nov 24, 2010 4:50 am
by mowgli
Dates in custom RDL reports were broken and displayed as "SystemByte()" by the new MySQL connector employed in v7.4. Tested data on a Linux server where MySQL 5.1.49 was installed, and the symptom disappeared. Apparently MySql.Data.dll version 6.2.4 must have MySQL 5.1 in order for the function DATE_FORMAT() to work properly.
Re: MySQL connector in v7.4 breaks DATE_FORMAT() in MySQL 5.0
Posted: Fri Nov 26, 2010 12:04 pm
by drtech
I am having issues too:
Linux server with MySQL 5.1.49...insplan errors
viewtopic.php?f=2&t=3166
Re: MySQL connector in v7.4 breaks DATE_FORMAT() in MySQL 5.0
Posted: Mon Nov 29, 2010 5:37 pm
by jordansparks
surround it with CHAR() or DATE() or whatever. It's a casting issue.
Re: MySQL connector in v7.4 breaks DATE_FORMAT() in MySQL 5.0
Posted: Tue Nov 30, 2010 11:00 am
by mowgli
Yes, it can be fixed by changing all the queries individually in the reports. Would that be better than upgrading to MySQL 5.1? Would version 5.1 have any problems with Open Dental?
Re: MySQL connector in v7.4 breaks DATE_FORMAT() in MySQL 5.0
Posted: Tue Nov 30, 2010 4:54 pm
by jordansparks
Sounds like an upgrade to 5.1 might be easier if not too many offices are involved. We don't have that luxury. We need to make all of our queries work with MySQL 5.0.