Ongoing Plugin Issues

  • Resolved inndesign

    (@inndesign)


    9 months, 1 week ago

    This plugin… is a constant, never-ending source of website problems. I have many support posts on here. The ongoing issues have cost us steeply for ongoing developer support. We have several dozen websites, but only this one with Events Calendar suffers endless complications, including an error log file that fills up with Events Calendar errors, filling the hosting space with a bloated log file. We will likely have to abandon it due to two years of endless issues. As of the last four versions up to 6.3.2, this error repeated endlessly, which are developer verifies is the Event Calendar plugin:

    [17-Feb-2024 06:15:44 UTC] WordPress database error Unknown column ‘wp_tec_occurrences.start_date_utc’ in ‘field list’ for query
    SELECT wp_posts.ID, CAST( wp_tec_occurrences.start_date_utc AS DATETIME ) AS event_date_utc, CAST( wp_tec_occurrences.duration AS DECIMAL ) AS event_duration
    FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
    WHERE 1=1 AND (
    wp_term_relationships.term_taxonomy_id IN (259)
    ) AND (
    ( wp_postmeta.meta_key = ‘_EventEndDateUTC’ AND CAST(wp_postmeta.meta_value AS DATETIME) > ‘2022-02-11 05:00:00’ )
    ) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘donor’, ‘funds’, ‘donation’, ‘tribe_events’, ‘avada_portfolio’, ‘avada_faq’) AND ((wp_posts.post_status = ‘publish’))
    GROUP BY wp_tec_occurrences.occurrence_id
    ORDER BY event_date_utc ASC, event_duration ASC, wp_posts.post_date ASC
    LIMIT 0, 11
    made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/Avada/tribe/events/v2/default-template.php’), Tribe\Events\Views\V2\Template_Bootstrap->get_view_html, Tribe\Events\Views\V2\View->get_html, Tribe\Events\Views\V2\Views\List_View->setup_template_vars, Tribe\Events\Views\V2\View->setup_template_vars, Tribe__Repository->all, WP_Query->get_posts

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support tristan083

    (@tristan083)

    Hi @inndesign,

    Thank you for reaching out.

    The error message seems to point to our new events data storage system. As such, have you completed the Migration to the New Event Data System, and has no database restoration been done since then?

    Thread Starter inndesign

    (@inndesign)

    No, that is not it…

    System Information
    Views V2 Status: Enabled
    Custom Tables Migration Status: Completed
    Custom Tables Health Check: Good!

    No database restorations have been done.

    Plugin Support Darian

    (@d0153)

    Hi @inndesign

    Thanks for your response.

    Could you check if you’re using the latest version of the Avada theme? If not, kindly update your theme to the latest version and see if that makes a difference.

    If it doesn’t help, could you please provide steps on how we can replicate the issue on our side? Looking forward to your reply.

    Thread Starter inndesign

    (@inndesign)

    Of course, it would be senseless to open a ticket if ANYTHING was not up-to-date and current. Avada 7.11.5 and The Events Calendar 6.3.3. PHP 8.1.27. Everything is 100% current and the website runs lean, only required plugins.

    There are no “steps” to create the problem. Simply activate Events Calendar and the error log starts filling up. Disable it, the error log remains empty. The below posts over 3 or 4 seconds until the error log file bloats to 1.5Gig in about two weeks.

    [20-Feb-2024 23:02:36 UTC] WordPress database error Unknown column ‘wp_tec_occurrences.start_date_utc’ in ‘field list’ for query
    SELECT wp_posts.ID, CAST( wp_tec_occurrences.start_date_utc AS DATETIME ) AS event_date_utc, CAST( wp_tec_occurrences.duration AS DECIMAL ) AS event_duration
    FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
    WHERE 1=1 AND (
    wp_term_relationships.term_taxonomy_id IN (314)
    ) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘donor’, ‘funds’, ‘donation’, ‘tribe_events’, ‘avada_portfolio’, ‘avada_faq’) AND ((wp_posts.post_status = ‘publish’)) AND ((
    TIMESTAMPDIFF ( SECOND, wp_tec_occurrences.start_date_utc, ‘2021-10-30 03:59:59’ ) >= 1
    AND
    TIMESTAMPDIFF ( SECOND, ‘2021-10-29 04:00:00’, wp_tec_occurrences.end_date_utc ) >= 1
    ))
    GROUP BY wp_tec_occurrences.occurrence_id
    ORDER BY event_date_utc ASC, event_duration ASC, wp_posts.post_date ASC
    made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/Avada/tribe/events/v2/default-template.php’), Tribe\Events\Views\V2\Template_Bootstrap->get_view_html, Tribe\Events\Views\V2\View->get_html, Tribe\Events\Views\V2\Views\Day_View->setup_template_vars, Tribe\Events\Views\V2\View->setup_template_vars, Tribe__Repository->all, WP_Query->get_posts

    Plugin Support Darian

    (@d0153)

    Hi @inndesign

    Thank you for your message.

    I appreciate your input. I will share this with the team and keep you informed as soon as I have more information.

    Plugin Support Darian

    (@d0153)

    Hi @inndesign

    I’m glad you brought this to our attention. I can see how this issue impacts error logs, causing them to bloat infinitely.

    I’ve created an internal ticket BTRIA-2281 to address this issue and I’ve included your specific use case in it to communicate it to our team.

    We prioritize bugs by taking into consideration the number of users impacted as well as how the bug impacts one’s ability to run an event/sell tickets. I don’t have a specific timeline as to when this issue will be resolved, but trust that our team is aware. Our team communicates updates and bug fixes in our newsletter and via our changelog.

    I’m happy to help if any other questions are coming up around this topic, otherwise I’ll go ahead and close this ticket.

    Thanks again for reporting this issue and for using The Events Calendar! Have a great day.

    —

    Internal Bug Ticket Reference: BTRIA-2281

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Ongoing Plugin Issues’ is closed to new replies.

Tags