geodir_sitemap creates error in error_log – wp_term_relationships doesn't exist

This topic contains 3 replies, has 3 voices, and was last updated by  Kiran 7 years, 8 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #384458

    wci
    Expired Member
    Post count: 1035

    Hi support team,

    Please help to solve the problem found in server error_log

    WordPress database error Table ‘worldche_wcimsgd.wp_term_relationships’ doesn’t exist for query SELECT tt.term_id,…

    screen shot – https://www.screencast.com/t/HRwgWgY7FMc

    [23-Jun-2017 10:19:13 UTC] WordPress database error Table ‘worldche_wcimsgd.wp_term_relationships’ doesn’t exist for query SELECT tt.term_id, MAX(p.post_modified_gmt) AS date_gmt, l.country_slug AS country, l.region_slug AS region, l.city_slug AS city FROM ms_1_geodir_post_locations l LEFT JOIN ms_1_geodir_gd_video_detail pd ON pd.post_location_id = l.location_id LEFT JOIN ms_1_posts p ON p.ID = pd.post_id LEFT JOIN wp_term_relationships AS tr ON tr.object_id = p.ID LEFT JOIN wp_term_taxonomy AS tt ON ( tt.term_taxonomy_id = tr.term_taxonomy_id AND tt.taxonomy = ‘gd_video_tags’ ) WHERE pd.post_locations LIKE CONCAT( ‘[‘, l.city_slug, ‘],[‘, l.region_slug , ‘],[‘, l.country_slug , ‘]’ ) AND p.post_type = ‘gd_video’ AND p.post_status = ‘publish’ AND l.location_id IS NOT NULL AND tt.term_id IS NOT NULL GROUP BY CONCAT(tt.term_id, ‘-‘, l.country_slug, ‘-‘, l.region_slug, ‘-‘, l.city_slug) ORDER BY date_gmt DESC made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WPSEO_Sitemaps->redirect, WPSEO_Sitemaps->build_sitemap, WPSEO_Sitemaps->build_root_map, WPSEO_Sitemaps_Renderer->get_index, apply_filters(‘wpseo_sitemap_index’), WP_Hook->apply_filters, call_user_func_array, geodir_sitemap_index, geodir_sitemap_taxonomies_sitemap_index, geodir_sitemap_get_locations_taxonomies

    #384459

    wci
    Expired Member
    Post count: 1035
    This reply has been marked as private.
    #384529

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    i have assigned this to kiran who wrote the sitemap functions, he will reply on monday.

    Thanks,

    Stiofan

    #384705

    Kiran
    Moderator
    Post count: 7069

    Hi There,

    Please check, we have fixed the problem, and it has been updated to your site too.

    Thanks,
    Kiran

Viewing 4 posts - 1 through 4 (of 4 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount