Deploying DateTime types and MySQL

[StephenMoretti]

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

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-beta" group.
To post to this group, send email to farcry-beta@...
To unsubscribe from this group, send email to farcry-beta+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/farcry-beta?hl=en
-~----------~----~----~----~------~----~------~--~---

[StephenMoretti]

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

2009/1/16 Stephen Moretti <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
Blog : http://nil.checksite.co.uk/
Twitter : http://twitter.com/mr_nil
EE: http://beta.experts-exchange.com/M_1167123.html

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-beta" group.
To post to this group, send email to farcry-beta@...
To unsubscribe from this group, send email to farcry-beta+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/farcry-beta?hl=en
-~----------~----~----~----~------~----~------~--~---