• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Default mysql TIMESTAMPS not allowed NULL
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: Default mysql TIMESTAMPS not allowed NULL
      • From: Tim W via Webobjects-dev <email@hidden>
  • Prev by Date: Re: The secret WOCommunity Slack channel?
  • Next by Date: Re: Default mysql TIMESTAMPS not allowed NULL
  • Previous by thread: Re: move to mysql 8 on Catalina jdbc Incorrect DATE value: '??’
  • Next by thread: Re: Default mysql TIMESTAMPS not allowed NULL
  • Index(es):
    • Date
    • Thread