I just checked MySQL and it does fail when I try to insert a NULL into a Non-Null column. So it is only when there is no value for the column that MySQL will use the default value instead.
So when CakePHP uses NULL for that column, MySQL will fail the insert operation. How does the save statement look like? What fields are in the data array that you try to save?
Enjoy, John
On Tuesday, 30 December 2014 22:50:11 UTC+2, MikeK wrote:
-- So when CakePHP uses NULL for that column, MySQL will fail the insert operation. How does the save statement look like? What fields are in the data array that you try to save?
Enjoy, John
On Tuesday, 30 December 2014 22:50:11 UTC+2, MikeK wrote:
I also ran the legacy code with some SQL log dumping and it seems to me the old code did NOT attempt an INSERT with the values of the unset fields set to NULL - apparently it only attempted to INSERT the fields that were set, at least according to the lastQuery() dump.
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment