_EventStartDate gets set to null, and event breaks

  • Resolved donbowman

    (@donbowman)


    1 year, 7 months ago

    I’m not sure what goes wrong. But, when we edit an existing event, its common that it will break.

    Tracking it down, we find that _EventStartDate/_EventEndDate get nulled. (_EventStartDateUTC/_EventEndDateUTC are not).

    This in turn causes the page to be un-editable, and it does not render properly.

    My ‘fix’ is to update them in the db:

    update wp_postmeta set meta_value = ‘2023-07-26 19:00:00’ where post_id = 2282107 and meta_id = 2561883;

    | 2561882 | 2282107 | _EventStartDate ? ? ? ? ? ? ? ? ? ?| ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?|
| 2561883 | 2282107 | _EventEndDate ? ? ? ? ? ? ? ? ? ? ?| ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?|
| 2561884 | 2282107 | _EventStartDateUTC ? ? ? ? ? ? ? ? | 2023-07-26 18:40:57 ? ? ? ? ? ?|
| 2561885 | 2282107 | _EventEndDateUTC ? ? ? ? ? ? ? ? ? | 2023-07-26 18:40:57 ? ? ? ? ? ?|
Viewing 15 replies - 1 through 15 (of 15 total)
  • Plugin Support tristan083

    (@tristan083)

    Hi @donbowman ,

    Thank you for reaching out, and I’m sorry to learn of the difficulties.

    I suspect there’s a conflict that’s causing the issue here. It would be good to test for conflicts. Could you follow the following steps?

    1. Deactivate all other plugins except for The Events Calendar Plugins.
    2. Switching to the Default theme.

    Please read the Testing for Conflicts Article before doing anything. 
    To be safe, we’d recommend conducting tests and updates on a Staging Server. Also, please keep a working backup of your website.

    Thread Starter donbowman

    (@donbowman)

    its not a conflict. something about UTC time and editing events causes it to corrupt itself. when it does, the event vanishes (either from the backend, or the front end).

    the fix is to either delete the date, save, recreate the date, or, to update the database so those fields are all 4 present, not empty.

    Plugin Support Darian

    (@d0153)

    Hi @donbowman

    Thanks for your response. Could you try manually updating The Events Calendar to the latest version and see if that helps?

    If that doesn’t help, could you provide the following information for us to investigate and replicate the issue further on our side?

    • Name of your hosting provider
    • The Events Calendar, WP, and PHP versions
    • Are you using a block editor or classic editor for your events?
    • Does the issue persist if you only activate our plugins and a basic theme, such as the 2020 theme?
    • What is your default timezone? And are you using site-wide timezone or manual timezones for events?

    Looking forward to your reply.

    Thread Starter donbowman

    (@donbowman)

    we self host

    PHP 8.2.7

    wp 6.2.1

    $ wp plugin list |grep -i event
    event-tickets active none 5.6.3
    the-events-calendar active none 6.1.3

    server timezone == site timezone == UTC

    we typically set the timezone to UTC as well

    we run gutenberg (16.2.1)

    Plugin Support Darian

    (@d0153)

    Hi @donbowman

    Thanks for your response.

    I understand that this may not be the news you were hoping for, but unfortunately, PHP 8.1 and above, is not fully supported at this time. Perhaps it would be worth considering downgrading to PHP 8.0 and seeing if that resolves the issue.

    See- PHP 8 Support

    If the previous suggestion doesn’t work, you may want to try using the timezone based on your current location. This could potentially fix the issue you’re experiencing.

    See- Working With Timezones

    Let me know how it goes.

    Thread Starter donbowman

    (@donbowman)

    I’m not so sure on that.

    Is WordPress compatible with PHP 8?

    “PHP 8.x has been with us for a while now, so much so that even PHP 8.0 has only security support, and we should mainly use PHP 8.1 and PHP 8.2.”

    wordpress.com also uses php 8.2 https://developer.wordpress.com/2022/12/09/php-8-2-is-now-available-on-wordpress-com/

    my issue seems to be, something is overwriting these fields, and, something crashes when these fields exist but are empty.

    I will keep debugging. I don’t have an option to go backwards on php, but I guess i do have the option to use a different events plugin.

    wordpress 6.3 comes out next week, i guess i can start testing with that.

    Thread Starter donbowman

    (@donbowman)

    i do not have those options in my settings for timezone:

    In Settings/Display, i have:
    “Enable Time Zone Suppor” and a button. “Update Time Zone Data”

    It says “Click this button to update your database and take advantage of additional time zone capabilities. Please?configure WordPress?to use the correct time zone before clicking this button!” below it.

    Pressing that button says: “Update complete: time zone data has been added to all events in the database.” but does not change the menu items available.

    https://theeventscalendar.com/knowledgebase/working-with-time-zones/

    shows 2 options, I have neither.

    Plugin Support Darian

    (@d0153)

    Hi @donbowman

    Thank you for your message. Have you encountered any errors related to The Events Calendar in your error_log file? We would like to investigate this further on our end.

    As for the timezone settings, could I ask for a screenshot or screen recording on what you’re seeing on your side?

    Looking forward to your reply.

    Thread Starter donbowman

    (@donbowman)

    On the settigns screen, when i enable the timezone support, the below appears to php error

    [04-Aug-2023 00:41:17] WARNING: [pool www] child 130 said into stderr: "NOTICE: PHP message: tribe-canonical-line channel=default level=error source="The start_date should be a valid date." method="TEC\Events\Custom_Tables\V1\Models\Builder::upsert" line=319 model="TEC\Events\Custom_Tables\V1\Models\Event""

    as for the video of setting it:

    Plugin Support Darian

    (@d0153)

    HI @donbowman ,

    Thank you for providing a screen recording of the issue. It seems the reason why you could not update the Timezone data is related to the events that were not properly updated/saved.

    Have you attempted to replicate the issue on a staging version of your live site? Once you have done so, delete any events that cannot be edited. Then, try updating the Timezone data from your Event settings page to see if that fixes the issue.

    Plugin Support Darian

    (@d0153)

    Hi @donbowman

    I hope you’re doing well. I just wanted to touch base and check in with you. It’s been a little while since we’ve heard from you. I was just curious if you had the chance to try out the recommendation provided above.

    Let me know if there’s anything I can assist you with.

    Thread Starter donbowman

    (@donbowman)

    we have come to the conclusion its just buggy.

    so we try to be very careful and only create an rsvp as the last item we save on a page, and never save it again.

    i wish it were more reliable.

    the ‘fix’ when we need it is so delete the event and recreate from scratch, its a bit painful.

    Plugin Support Darian

    (@d0153)

    Hi @donbowman

    I’m sorry to hear that you’re still experiencing this issue.

    Have you tried using our latest plugins to see if that resolves the problem? If it does not help, from a staging version of your live site, could you try activating only our plugins and using a default theme like WP’s 2020 theme, and see if that makes a difference? This will assist me in reproducing the issue on my end, and I can further debug it.

    Looking forward to your reply.

    Plugin Support Darian

    (@d0153)

    Hi @donbowman

    I hope everything is going smoothly for you. I just wanted to touch base and inquire if you had the opportunity to review my previous response, as it has been some time since we last heard from you.

    Plugin Support Darian

    (@d0153)

    Hi @donbowman

    This thread has been inactive for a while, so we’ll go ahead and mark it Resolved. Please open a new thread if any other questions arise, and we’d be happy to help.

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘_EventStartDate gets set to null, and event breaks’ is closed to new replies.