We recently had a server failure that resulted in having to rebuild the server services. Ended up going from mySQL 5.1 to 5.6.23. Since that issue occurred, one of our clients is reporting that Calendar gives him this error when trying to create new events:

A Database Error Occurred Error Number: 1364

Field 'last_date' doesn't have a default value

Client reports that entry gets made, just doesn't have an date info in the Calendar field.

It's EE 2.8.1 and Calendar 1.8.9.

  • Have you manually checked that table column to make sure that it does have a default?
    – jrothafer
    Commented Sep 2, 2015 at 2:09
  • Nope. But I'm headed that way... I've also received some feedback from Solspace. I think I'll have this fixed in a few and will post my actions for future me or whoever else may need it.
    – ImpDesigns
    Commented Sep 2, 2015 at 16:53

1 Answer 1


The issue shown here was resolved by adding a default value (0) into the exp_calendar_events table, 'last_date' field. Not sure how it got gone, perhaps it was a result of the mysql version change or maybe the missing value wasn't an issue until the version change, but adding the default value resolved the issue for me.

  • 1
    "...doesn't have a default value" errors can happen when strict mode is enabled in MySQL. If you turn this off the error usually would go away. The other approach is to indeed add a default value yourself in the table if you have strict more kept enabled.
    – Solspace
    Commented Sep 2, 2015 at 23:44
  • Disabling strict mode has helped me in this case. But it's only a temporary Situation since I'm on a shared hosting. The server guys won't keep the strict mode disabled for a long time.
    – outline4
    Commented Feb 27, 2019 at 14:38
  • The error message sais that it's on Line Number: 903, Filename: third_party/calendar/data.calendar.php. Would it be possible to make this somehow work with stict mode enable? Calendar 1.8.14.
    – outline4
    Commented Feb 27, 2019 at 14:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.