Deploying DateTime types and MySQL

[Stephen Moretti]

I could swear that I've addressed this previously in MySQL 4.x....

However, I'm getting an error when deploying datetime types.  The error amounts to you can't have a default value of '' on a datetime type column in MySQL. Manually taking the ALTER statement and removing the default value works fine.  

The error comes up at line 1581 of core/packages/farcry/alterType.cfc, so basically when you are deploying an individual column, specifically in this instance, datetimelastupdate and datetimecreated from the core/types/type.cfc - bizarrely full table deploys seem to be ok.

Anyone else noticed this? Got a fix?

Suggestions where would be more appropriate to fix this?  alterType.cfc or /webtop/admin/coapiTypes.cfc

Regards

Stephen

--
Stephen Moretti
Blog : http://nil.checksite.co.uk/
Twitter : http://twitter.com/mr_nil
EE: http://beta.experts-exchange.com/M_1167123.html

[Stephen Moretti]

Before I forget I posted this as a bug : http://bugs.farcrycms.org/browse/FC-1720

2009/1/16 Stephen Moretti <stephen...@gmail.com>