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).
