evade
Forum Replies Created
-
Forum: Plugins
In reply to: [W3 Total Cache] Data base errorThank 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?
Thank you!
Forum: Fixing WordPress
In reply to: Data base error and mix of storage engineHello,
I don’t understand, but even that I have changed all tables to utf8mb4_unicode_ci as you have indicated and now they all look correctcly, I still have the same issue, this is the error I find:
[31-Jul-2024 16:19:04 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 ‘%OGEA-103合格対策 ?? OGEA-103対応資料 ?? OGEA-103実際試験 ?? ? https://www.goshiken.com ??で使える無料オンライン版? OGEA-103 ?? の試験問題OGEA-103試験概要%’) OR (wp_posts.post_excerpt LIKE ‘%OGEA-103合格対策 ?? OGEA-103対応資料 ?? OGEA-103実際試験 ?? ? https://www.goshiken.com ??で使える無料オンライン版? OGEA-103 ?? の試験問題OGEA-103試験概要%’) OR (wp_posts.post_content LIKE ‘%OGEA-103合格対策 ?? OGEA-103対応資料 ?? OGEA-103実際試験 ?? ? https://www.goshiken.com ??で使える無料オンライン版? OGEA-103 ?? の試験問題OGEA-103試験概要%’))) AND (wp_posts.post_password = ”) AND ((wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’)) OR (wp_posts.post_type = ‘page’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’)) OR (wp_posts.post_type = ‘attachment’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’)) OR (wp_posts.post_type = ‘project’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’)) OR (wp_posts.post_type = ‘profile’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’)) OR (wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’))) AND ( ( ( wpml_translations.language_code = ‘ca’ OR 0 ) AND wp_posts.post_type IN (‘post’,’page’,’attachment’,’wp_block’,’wp_template’,’wp_template_part’,’wp_navigation’,’project’,’profile’,’tribe_venue’,’tribe_organizer’,’tribe_events’ ) ) OR wp_posts.post_type NOT IN (‘post’,’page’,’attachment’,’wp_block’,’wp_template’,’wp_template_part’,’wp_navigation’,’project’,’profile’,’tribe_venue’,’tribe_organizer’,’tribe_events’ ) )ORDER BY (CASE WHEN wp_posts.post_title LIKE '%OGEA-103合格対策 ?? OGEA-103対応資料 ?? OGEA-103実際試験 ?? ? www.goshiken.com ??で使える無料オンライン版? OGEA-103 ?? の試験問題OGEA-103試験概要%' THEN 1 WHEN wp_posts.post_title LIKE '%OGEA-103合格対策 ?? OGEA-103対応資料 ?? OGEA-103実際試験 ?? ? www.goshiken.com ??で使える無料オンライン版? OGEA-103 ?? の試験問題OGEA-103試験概要%' THEN 2 WHEN wp_posts.post_excerpt LIKE '%OGEA-103合格対策 ?? OGEA-103対応資料 ?? OGEA-103実際試験 ?? ? www.goshiken.com ??で使える無料オンライン版? OGEA-103 ?? の試験問題OGEA-103試験概要%' THEN 4 WHEN wp_posts.post_content LIKE '%OGEA-103合格対策 ?? OGEA-103対応資料 ?? OGEA-103実際試験 ?? ? www.goshiken.com ??で使える無料オンライン版? OGEA-103 ?? の試験問題OGEA-103試験概要%' 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, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_queryThere is a message regarding cache, but I have installed it yesterday after changing the database.
I will appreciate if you have any ideas.
Thank you
Eva
Forum: Fixing WordPress
In reply to: Data base error and mix of storage engineThank you so much, IO do appreciate very much your help!