Title: admin: booking date error
Last modified: October 2, 2018

---

# admin: booking date error

 *  Resolved [eltebe](https://wordpress.org/support/users/eltebe/)
 * (@eltebe)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/admin-booking-date-error/)
 * On the admin: The booking page shows dates like this:
    “-0001.11.30. 00:00”
 * Events Made Easy version: 2.0.43
    -  This topic was modified 7 years, 8 months ago by [eltebe](https://wordpress.org/support/users/eltebe/).

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [Franky](https://wordpress.org/support/users/liedekef/)
 * (@liedekef)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/admin-booking-date-error/#post-10743687)
 * Can you first upgrade and try again? And also: please explain in a little more
   detail your problem afterwards …
 *  Plugin Author [Franky](https://wordpress.org/support/users/liedekef/)
 * (@liedekef)
 * [7 years, 8 months ago](https://wordpress.org/support/topic/admin-booking-date-error/#post-10747003)
 * no reply, closing.
 *  [Aspexi](https://wordpress.org/support/users/aspexi/)
 * (@aspexi)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/admin-booking-date-error/#post-10910348)
 * Hi [@liedekef](https://wordpress.org/support/users/liedekef/)
 * Great job with the plugin.
 * I’m experiencing similar issue as the author of this topic. Suddenly, about 70%
   of all bookings got “0000-00-00 00:00:00” values in database for creation_date
   column. Which obviously broke event’s date in admin and frontend.
 * Plugin version: 2.0.51
 * Any ideas how to debug this?
 *  Plugin Author [Franky](https://wordpress.org/support/users/liedekef/)
 * (@liedekef)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/admin-booking-date-error/#post-10910409)
 * First: please update.
    Second: what verison of php, wordpress and mysql are you
   using? Booking creation date is not related to events date at all. And which 
   is your wordpress setting concerning date/time representation?
 *  [Aspexi](https://wordpress.org/support/users/aspexi/)
 * (@aspexi)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/admin-booking-date-error/#post-10910492)
 * Of course, update is on our todo list. Anyway, we need to sort this issue out
   first.
 * PHP 7.0.32
    WP 4.9.8 MySQL 5.5.56-MariaDB
 * Sorry, yes, events’ dates are fine. Bookings / RSVPs dates are broken.
 * Custom date setting: D jS M Y
    Custom time setting: g:ia Timezone: utc+0 Week
   Starts On Monday
 *  Plugin Author [Franky](https://wordpress.org/support/users/liedekef/)
 * (@liedekef)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/admin-booking-date-error/#post-10910904)
 * Not too difficult:
 * the bookings table has 2 columns, creation_date and modif_date. Both have type
   datetime.
    But for sake of ease, I no longer manually update these but use the
   definition
 *  creation_date datetime $default_current_ts,
    modif_date datetime $default_current_ts
   $update_current_ts,
 * With
    $default_current_ts=”DEFAULT CURRENT_TIMESTAMP”; $update_current_ts=”DEFAULT
   CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”;
 * ut that definition is only valid for newer database servers, so for old ones 
   I leave the default empty (and so that column is empty too).
    This is the current
   check I make to try and detect old db servers:
 *  $mysql_version = $wpdb->get_var(“SELECT VERSION();”);
    $mysql_version = preg_replace(‘/[
   ^0-9.].*/’, ”, $mysql_version); $mysql_old = version_compare( $mysql_version,“
   5.6”, ‘<‘ );
 * So in short: your db version is too old, update to something more recent if possible
   or currently accept the empty datetime info there (and even that still doesn’t
   block rsvp, it is just the booking datetime info that is empty then).

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘admin: booking date error’ is closed to new replies.

 * ![](https://ps.w.org/events-made-easy/assets/icon-256x256.png?rev=1856035)
 * [Events Made Easy](https://wordpress.org/plugins/events-made-easy/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/events-made-easy/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/events-made-easy/)
 * [Active Topics](https://wordpress.org/support/plugin/events-made-easy/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/events-made-easy/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/events-made-easy/reviews/)

## Tags

 * [Date Error](https://wordpress.org/support/topic-tag/date-error/)

 * 6 replies
 * 3 participants
 * Last reply from: [Franky](https://wordpress.org/support/users/liedekef/)
 * Last activity: [7 years, 6 months ago](https://wordpress.org/support/topic/admin-booking-date-error/#post-10910904)
 * Status: resolved