SQL Error and non page load

  • Resolved eliloeffel

    (@eliloeffel)


    2 years, 4 months ago

    Our site is showing this error. Our Calendar short code page does not load. It’s thinks for several minutes and eventually returns a 403 error.

    We are on version Version 2.8.6 with Rollback V1.0.0

    EventM_Install::em_create_table()

    Plugin: eventprime-event-calendar-managementYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘IF’ at line 11064

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter eliloeffel

    (@eliloeffel)

    2 years, 4 months ago

    I appologize for adding more but I am learning how to troubleshoot wordpress a but deeper. There are many error log entries of this error:

    [13-Feb-2023 21:04:59 UTC] PHP Fatal error: Uncaught Exception: DateTimeZone::__construct(): Unknown or bad timezone (Europe/Kyiv) in /home/no5nov4u4l73/public_html/wp-content/plugins/eventprime-event-calendar-management/includes/em-core-functions.php:138
    Stack trace:

    0 /home/no5nov4u4l73/public_html/wp-content/plugins/eventprime-event-calendar-management/includes/em-core-functions.php(138): DateTimeZone->__construct(‘Europe/Kyiv’)

    1 /home/no5nov4u4l73/public_html/wp-content/plugins/eventprime-event-calendar-management/includes/em-core-functions.php(182): em_current_time_by_timezone()

    2 /home/no5nov4u4l73/public_html/wp-includes/class-wp-hook.php(308): em_check_event_status(”)

    3 /home/no5nov4u4l73/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)

    4 /home/no5nov4u4l73/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array)

    5 /home/no5nov4u4l73/public_html/wp-settings.php(617): do_action(‘init’) 6 /home/no5nov4u4l73/public_html/wp-config.php(98): require_once(‘/home/no5nov4u4…’)

    7 /home/no5nov4u4l73 in /home/no5nov4u4l73/public_html/wp-content/plugins/eventprime-event-calendar-management/includes/em-core-functions.php on line 138

    eventprimesupport

    (@eventprimesupport)

    2 years, 4 months ago

    Thanks for using EventPrime. I hope you are having a wonderful day!

    Please ensure that both your EventPrime plugin and WordPress installation are running the latest versions. Sometimes, compatibility issues may arise with outdated software.

    After updating, kindly check if the issue persists.
    If the problem persists, please let us know, and we will further investigate and assist you in resolving the issue.

    If you have any further questions, please don’t hesitate to reach out to us.

    Thread Starter eliloeffel

    (@eliloeffel)

    2 years, 4 months ago

    Thank you for the response.

    Is there an update that works with the rollback plugin?

    I’ve tried updating to the latest version without the rollback, and even though there are many events, the calendar says that there are no events on the front end. It doesn’t even show a blank calendar, it just has that message.

    • This reply was modified 2 years, 4 months ago by eliloeffel.
    Thread Starter eliloeffel

    (@eliloeffel)

    2 years, 4 months ago

    We’ve updated to the latest version on our staging site. The events do not show up on the calendar even though there are many in the list.
    When there are no events, instead of showing an empty calendar it displays this message.

    Thread Starter eliloeffel

    (@eliloeffel)

    2 years, 4 months ago

    I’ve updated all settings manually in each event and now it works.

    Is there a way to bypass the event page? On our 3rd party linked events it takes them to an event page, then they have to click “get tickets now” to get redirected to the 3rd party site. It is very redundant.
    We will have to fully build out every event that links to a 3rd party platform:(

    Thread Starter eliloeffel

    (@eliloeffel)

    2 years, 4 months ago

    IT LOOKS LIKE YOU MADE THE UPDATE SO THAT THIRD PARTY LINKS GO DIRECT TO THE SITE!!!! THANK YOU!

    We will re-install and test. We’ll go pro FOR SURE if it works!

    Thank You again!

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

The topic ‘SQL Error and non page load’ is closed to new replies.