Title: Data base error
Last modified: August 23, 2024

---

# Data base error

 *  Resolved [evade](https://wordpress.org/support/users/evade/)
 * (@evade)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/data-base-error-19/)
 * 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受験記 🎇 ▶ [http://www.goshiken.com](http://www.goshiken.com/) ◀サイト
   にて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%’) OR (wp_posts.post_excerpt
   LIKE ‘%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ [http://www.goshiken.com](http://www.goshiken.com/)
   ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%’) OR (wp_posts.post_content
   LIKE ‘%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ [http://www.goshiken.com](http://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受験記 🎇 
   ▶ [http://www.goshiken.com](http://www.goshiken.com/) ◀サイトにて▶ PAM-DEF ◀問題
   集を無料で使おうPAM-DEF試験勉強書%’ THEN 1 WHEN wp_posts.post_title LIKE ‘%PAM-
   DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ [http://www.goshiken.com](http://www.goshiken.com/)
   ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%’ THEN 2 WHEN wp_posts.
   post_excerpt LIKE ‘%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇
   ▶ [http://www.goshiken.com](http://www.goshiken.com/) ◀サイトにて▶ PAM-DEF ◀問題
   集を無料で使おうPAM-DEF試験勉強書%’ THEN 4 WHEN wp_posts.post_content LIKE ‘%
   PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ [http://www.goshiken.com](http://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受験記 🎇 
   ▶ [http://www.goshiken.com](http://www.goshiken.com/) ◀サイトにて▶ PAM-DEF ◀問題
   集を無料で使おうPAM-DEF試験勉強書%’) OR (wp_posts.post_excerpt LIKE ‘%PAM-DEF
   模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ [http://www.goshiken.com](http://www.goshiken.com/)
   ◀サイトにて▶ PAM-DEF ◀問題集を無料で使おうPAM-DEF試験勉強書%’) OR (wp_posts.post_content
   LIKE ‘%PAM-DEF模擬対策 🌱 PAM-DEF復習テキスト 🏆 PAM-DEF受験記 🎇 ▶ [http://www.goshiken.com](http://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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdata-base-error-19%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Contributor [Marko Vasiljevic](https://wordpress.org/support/users/vmarko/)
 * (@vmarko)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/data-base-error-19/#post-17971627)
 * Hello [@evade](https://wordpress.org/support/users/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](https://wordpress.org/support/users/evade/)
 * (@evade)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/data-base-error-19/#post-17974240)
 * 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](https://wordpress.org/support/users/vmarko/)
 * (@vmarko)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/data-base-error-19/#post-17975790)
 * Hello [@evade](https://wordpress.org/support/users/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)

The topic ‘Data base error’ is closed to new replies.

 * ![](https://ps.w.org/w3-total-cache/assets/icon-256x256.png?rev=1041806)
 * [W3 Total Cache](https://wordpress.org/plugins/w3-total-cache/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/w3-total-cache/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/w3-total-cache/)
 * [Active Topics](https://wordpress.org/support/plugin/w3-total-cache/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/w3-total-cache/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/w3-total-cache/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Marko Vasiljevic](https://wordpress.org/support/users/vmarko/)
 * Last activity: [1 year, 9 months ago](https://wordpress.org/support/topic/data-base-error-19/#post-17975790)
 * Status: resolved