Default mysql TIMESTAMPS not allowed NULL
Default mysql TIMESTAMPS not allowed NULL
- Subject: Default mysql TIMESTAMPS not allowed NULL
- From: John Pollard via Webobjects-dev <email@hidden>
- Date: Wed, 11 Nov 2020 22:20:50 +0000
Hi again list,
My move to Catalina forced me to mysql 8. The previous version allowed NULL to
be passed to TIMESTAMP fields causing mysql to set them automatically, but the
NULL passed in the INSERT statements causes an error.
From reading around I believe they should be passed as a blank “” rather than
NULL in order for mysql to default them. I should update my Wonder snapshot as
perhaps it is fixed in Wonder now, but I am wary of making too many changes all
at once. The lesson I suppose is to keep all aspects reasonably up to date in
good time!
Is there a quick way to set all fields that are of type dateTimeStampPrototype
in the EOModel to be blank rather than NULL? Or I could just set them to now in
code, but is there one place I can do it rather than in every entity class?
Thanks
John
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden