Deploying DateTime types and MySQL

View: New views
2 Messages — Rating Filter:   Alert me  

Deploying DateTime types and MySQL

by StephenMoretti :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---


Re: Deploying DateTime types and MySQL

by StephenMoretti :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---