not unique table/alias: ‘wp-tec_occurrences’

  • Resolved qgotv

    (@qgotv)


    1 year, 9 months ago

    Please help! Apparently, this error has been going on for months. Our server resources have been max-ed out daily and I just discovered this. I have looked at the db and there is no other table named wp_tec_occurrences, then I ran the query myself in phpMyAdmin and it indeed throws the error. The querry and error is listed below from my error log.
    MySQL said:?#1066 - Not unique table/alias: 'wp_tec_occurrences'

    [25-Jun-2023 22:17:14 UTC] WordPress database error Not unique table/alias: ‘wp_tec_occurrences’ for query
    SELECT SQL_CALC_FOUND_ROWS (wp_tec_occurrences.occurrence_id + 10000000) as occurrence_id
    FROM wp_posts INNER JOIN wp_tec_occurrences ON wp_posts.ID = wp_tec_occurrences.post_id
    LEFT JOIN wp_tec_series_relationships ON wp_tec_series_relationships.event_post_id = wp_posts.ID
    JOIN wp_tec_occurrences ON wp_posts.ID = wp_tec_occurrences.post_id
    WHERE 1=1 AND wp_posts.ID NOT IN (446) AND (
    CAST(wp_tec_occurrences.end_date_utc AS DATETIME) < ‘2023-06-25 22:17:14’ ) AND wp_posts.post_type = ‘tribe_events’ AND ((wp_posts.post_status = ‘publish’)) AND (wp_tec_series_relationships.series_post_id IN(10000052)) GROUP BY wp_tec_occurrences.occurrence_id ORDER BY wp_posts.post_date ASC LIMIT 0, 11 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/the-events-calendar/src/views/v2/default-template.php’), Tribe\Events\Views\V2\Template_Bootstrap->get_view_html, Tribe\Events\Pro\Views\V2\Views\All_View->get_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\Events\Views\V2\Views\List_View->next_url, Tribe\Events\Views\V2\Views\List_View->get_upcoming_url, Tribe__Repository->count, WP_Query->get_posts, apply_filters_ref_array(‘posts_pre_query’), WP_Hook->apply_filters, TEC\Events\Custom_Tables\V1\WP_Query\Modifiers\Events_Only_Modifier->filter_posts_pre_query, TEC\Events\Custom_Tables\V1\WP_Query\Custom_Tables_Query->get_posts, WP_Query->get_posts

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Darian

    (@d0153)

    Hi @qgotv

    I’m sorry to hear that you’re having this issue. Let me help you with this one.

    The wp_tec_occurrences table was introduced during the V6 of The Events Calendar plugin. If you don’t have this table in your database, then it could probably mean that you haven’t migrated your events to the New Event Data System yet.

    To migrate your events, please follow the steps below:

    1. Update to the latest versions of The Events Calendar and Events Calendar Pro.
    2. Remove any un-needed draft events and empty the Trash.
    3. Activate only our plugins and use a basic theme like 2020 theme during migration.
    4. Go to Events > Settings > Upgrades and go through the migration process.

    See also- Tips for smooth migration

    Please do the migration first on your staging site before applying it to your live site.

    I hope this helps, and please let me know if you have further questions or concerns.

    Plugin Support Iris

    (@iirvin)

    Hi @qgotv

    Since you have an active license and for us to help you better, please open a Support Ticket on our Help Desk. Also, for us to follow WordPress Forum Guidelines regarding premium users.??

    One of my colleagues will be with you shortly. We look forward to helping you out with this one. 

    Hang in there.

    I am fighting the same issue. I have definitely migrated.

    Is it possible that events created before the migration are carrying a vestigial issue that is throwing the error?

    If you have had any success with mitigating this error please let me know. I have been working with support for 2 months on this and still no resolution. It is taking my site down regularly.

    Plugin Support Darian

    (@d0153)

    Hi @markbeese

    I apologize for the ongoing issue you’re experiencing. Rest assured that one of my colleagues from our Help Desk is already working on resolving this matter. Please note that we cannot provide assistance for premium users through this forum.

    If you have further inquiries or concerns, please submit a new Support Ticket through our Help Desk.

    Plugin Support Darian

    (@d0153)

    Hi @qgotv

    It seems like it has been some time since we received a response from you, therefore, I will consider this matter as resolved. If you require any further assistance, please submit a new?Support Ticket?through our Help Desk.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘not unique table/alias: ‘wp-tec_occurrences’’ is closed to new replies.

Tags