Database error

This topic contains 4 replies, has 3 voices, and was last updated by  Richard Parry 5 years, 1 month ago.

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

Open Support Ticket
  • Author
    Posts
  • #472528

    Richard Parry
    Expired Member
    Post count: 121

    I am getting the following error generated in my php error log:

    [05-Mar-2019 05:56:17 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation ‘=’ 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 rhp_31_geodir_post_locations l LEFT JOIN rhp_31_geodir_gd_place_detail pd ON ( pd.country = l.country AND pd.region = l.region AND pd.city = l.city ) LEFT JOIN rhp_31_posts p ON p.ID = pd.post_id LEFT JOIN

    rhp_31_term_relationships

    AS tr ON tr.object_id = p.ID LEFT JOIN

    rhp_31_term_taxonomy

    AS tt ON ( tt.term_taxonomy_id = tr.term_taxonomy_id AND tt.taxonomy = ‘gd_placecategory’ ) WHERE p.post_type = ‘gd_place’ 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(‘/wordpress-5.0.2/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, 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, GeoDir_Location_SEO::wpseo_sitemap_index, GeoDir_Location_SEO::wpseo_taxonomy_sitemap_index, GeoDir_Location_SEO::wpseo_sitemap_get_locations_taxonomies

    #472626

    Alex Rollin
    Moderator
    Post count: 27815

    The developers have been alerted, thanks for reporting the error.

    #473550

    Kiran
    Moderator
    Post count: 7069
    #473556

    Kiran
    Moderator
    Post count: 7069
    #473578

    Richard Parry
    Expired Member
    Post count: 121

    This can be closed. Thank you. Richard

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

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

Open Support Ticket