Data base error

  • Resolved evade

    (@evade)


    3 months ago

    I have had a database error that was initially solved (see image of database attached) but for some reason, since I have installed W3 Cache pluguin is coming back again. I delete cache and everything seems to be normal, but after 2 or 3 days the error comes up again. Any of the database tables are with (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) f as I had change them all to utf8mb4_unicode_ci

    This is the error:

    [23-Aug-2024 04:20:40 UTC] WordPress database error Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation ‘like’ for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT(‘post_’, wp_posts.post_type) WHERE 1=1 AND (((wp_posts.post_title LIKE ‘%PAM-DEF模擬対策 ?? PAM-DEF復習テキスト ?? PAM-DEF受験記 ?? ??https://www.goshiken.com??サイトにて? PAM-DEF ?問題集を無料で使おうPAM-DEF試験勉強書%’) OR (wp_posts.post_excerpt LIKE ‘%PAM-DEF模擬対策 ?? PAM-DEF復習テキスト ?? PAM-DEF受験記 ?? ??https://www.goshiken.com??サイトにて? PAM-DEF ?問題集を無料で使おうPAM-DEF試験勉強書%’) OR (wp_posts.post_content LIKE ‘%PAM-DEF模擬対策 ?? PAM-DEF復習テキスト ?? PAM-DEF受験記 ?? ??https://www.goshiken.com??サイトにて? PAM-DEF ?問題集を無料で使おうPAM-DEF試験勉強書%’))) AND (wp_posts.post_password = ”) AND ((wp_posts.post_type = ‘attachment’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘expired’)) OR (wp_posts.post_type = ‘gt3_gallery’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘expired’)) OR (wp_posts.post_type = ‘job_listing’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘expired’)) OR (wp_posts.post_type = ‘page’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘expired’)) OR (wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘expired’)) OR (wp_posts.post_type = ‘projects’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘expired’)) OR (wp_posts.post_type = ‘team’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘expired’))) AND ( ( ( wpml_translations.language_code = ‘en’ OR 0 ) AND wp_posts.post_type IN (‘post’,’page’,’attachment’,’wp_block’,’wp_template’,’wp_template_part’,’wp_navigation’,’job_listing’) ) OR wp_posts.post_type NOT IN (‘post’,’page’,’attachment’,’wp_block’,’wp_template’,’wp_template_part’,’wp_navigation’,’job_listing’) ) ORDER BY (CASE WHEN wp_posts.post_title LIKE ‘%PAM-DEF模擬対策 ?? PAM-DEF復習テキスト ?? PAM-DEF受験記 ?? ??https://www.goshiken.com??サイトにて? PAM-DEF ?問題集を無料で使おうPAM-DEF試験勉強書%’ THEN 1 WHEN wp_posts.post_title LIKE ‘%PAM-DEF模擬対策 ?? PAM-DEF復習テキスト ?? PAM-DEF受験記 ?? ??https://www.goshiken.com??サイトにて? PAM-DEF ?問題集を無料で使おうPAM-DEF試験勉強書%’ THEN 2 WHEN wp_posts.post_excerpt LIKE ‘%PAM-DEF模擬対策 ?? PAM-DEF復習テキスト ?? PAM-DEF受験記 ?? ??https://www.goshiken.com??サイトにて? PAM-DEF ?問題集を無料で使おうPAM-DEF試験勉強書%’ THEN 4 WHEN wp_posts.post_content LIKE ‘%PAM-DEF模擬対策 ?? PAM-DEF復習テキスト ?? PAM-DEF受験記 ?? ??https://www.goshiken.com??サイトにて? PAM-DEF ?問題集を無料で使おうPAM-DEF試験勉強書%’ THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, W3TCDbCache_WpdbNew->query, W3TCDbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TCDbCache_WpdbNew->query, W3TCDbCache_WpdbInjection->query, W3TCDbCache_WpdbNew->default_query [23-Aug-2024 04:20:40 UTC] WordPress database error Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation ‘like’ for query SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT(‘post_’, wp_posts.post_type) WHERE 1=1 AND (((wp_posts.post_title LIKE ‘%PAM-DEF模擬対策 ?? PAM-DEF復習テキスト ?? PAM-DEF受験記 ?? ??https://www.goshiken.com??サイトにて? PAM-DEF ?問題集を無料で使おうPAM-DEF試験勉強書%’) OR (wp_posts.post_excerpt LIKE ‘%PAM-DEF模擬対策 ?? PAM-DEF復習テキスト ?? PAM-DEF受験記 ?? ??https://www.goshiken.com??サイトにて? PAM-DEF ?問題集を無料で使おうPAM-DEF試験勉強書%’) OR (wp_posts.post_content LIKE ‘%PAM-DEF模擬対策 ?? PAM-DEF復習テキスト ?? PAM-DEF受験記 ?? ??https://www.goshiken.com??サイトにて? PAM-DEF ?問題集を無料で使おうPAM-DEF試験勉強書%’))) AND (wp_posts.post_password = ”) AND wp_posts.post_password = ” AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘team’, ‘projects’, ‘job_listing’, ‘gt3_gallery’) AND ((wp_posts.post_status = ‘publish’)) AND ( ( ( wpml_translations.language_code = ‘en’ OR 0 ) AND wp_posts.post_type IN (‘post’,’page’,’attachment’,’wp_block’,’wp_template’,’wp_template_part’,’wp_navigation’,’job_listing’) ) OR wp_posts.post_type NOT IN (‘post’,’page’,’attachment’,’wp_block’,’wp_template’,’wp_template_part’,’wp_navigation’,’job_listing’) ) ORDER BY wp_posts.post_date DESC LIMIT 0, 10 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/listingeasy/search.php’), get_posts, WP_Query->query, WP_Query->get_posts, W3TCDbCache_WpdbNew->query, W3TCDbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TCDbCache_WpdbNew->query, W3TCDbCache_WpdbInjection->query, W3TCDbCache_WpdbNew->default_query

    Thank you

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hello @evade

    Thank you for reaching out and I am happy to help!
    It seems taht you are using both Object Cache and DB Cache and both on disk. Is there a reason you are using both OC and DB Cache and I would recommend disabling those if the only caching method available is Disk. Please consider using memory-based caching like Redis or Memcached.
    Does the issue continue to persist if you disable DB Cache?

    Thanks!

    Thread Starter evade

    (@evade)

    Thank you for you answer.

    I am using a shared hosting and I have also activated Varnish cache (on server offered by the hosting) as well. In W3TC I have only activated Database Cache, Object Cache and Browser Cache. Opcode: Zend Opcache. For a shared server the only option I see is Disk. Memcached is offered for Multiple servers. Do you think it would work?

    Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hello @evade

    It’s recommended to use memory based caching like Memcached or Redis for DB Caching and Object Cahcing.
    If you do not have the option for this, it’s recommeded not to use OC or DB Caching.

    I hope this helps!
    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.