Hi,
Below is the error I’m getting copied from debug.log . But I’m not so sure if the below is responsible for the internal server error.
Also this is a screenshot of the error page I’m getting.
Error
[22-Jan-2019 19:02:25 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘%l\’organisation%’) OR (wp_posts.post_excerpt LIKE ‘%l\’organisation%’) OR (wp_p’ at line 3 for query SELECT SQL_CALC_FOUND_ROWS DISTINCT 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) LEFT JOIN wp_postmeta AS pb_meta ON wp_posts.ID = pb_meta.post_id WHERE 1=1 AND wp_posts.ID NOT IN (38529,44687,44683,44679,46000,42290,42293,29882,36366,1632,1050,53829,53847,1038,790,57539,58306,58725,58724,59632,59634,59635,59677,59688,59689,1627,1477,41452,1051,52199,59163,59165,59162,59164,1467,54846,54845,1468,54839,54838,2005,1625,1052,34094,34088,59160,34091,14109,62110,62112,62113) AND (((wp_posts.post_title LIKE ‘%Cherche%’) OR (pb_meta.meta_value LIKE ‘%Cherche%’) OR (wp_posts.post_excerpt LIKE ‘%Cherche%’) OR (wp_posts.post_content LIKE ‘%Cherche%’)) AND ((wp_posts.post_title LIKE ‘%l\’) OR (pb_meta.meta_value LIKE ‘%l\’organisation%’) OR (wp_posts.post_excerpt LIKE ‘%l\’organisation%’) OR (wp_posts.post_content LIKE ‘%l\’organisation%’)) AND ((wp_posts.post_title LIKE ‘%du%’) OR (pb_meta.meta_value LIKE ‘%du%’) OR (wp_posts.post_excerpt LIKE ‘%du%’) OR (wp_posts.post_content LIKE ‘%du%’)) AND ((wp_posts.post_title LIKE ‘%CIC%’) OR (pb_meta.meta_value LIKE ‘%CIC%’) OR (wp_posts.post_excerpt LIKE ‘%CIC%’) OR (wp_posts.post_content LIKE ‘%CIC%’))) AND (wp_posts.post_password = ”) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘sdm_downloads’, ‘portfolio’, ‘documentation’) AND (wp_posts.post_status = ‘publish’) AND ( ( ( wpml_translations.language_code = ‘en’ OR 0 ) AND wp_posts.post_type IN (‘post’,’page’,’attachment’,’mc4wp-form’,’portfolio’,’documentation’ ) ) OR wp_posts.post_type NOT IN (‘post’,’page’,’attachment’,’mc4wp-form’,’portfolio’,’documentation’ ) ) AND wp_posts.id NOT IN (SELECT post_id FROM wp_wpfront_ure_post_type_permissions WHERE role IN (‘wpfront-guest-role-1’) AND enable_permissions = 1 AND has_read = 0 GROUP BY post_id HAVING COUNT(*) = 1) AND wp_posts.id NOT IN (SELECT post_id FROM wp_wpfront_ure_post_type_permissions WHERE role IN (‘wpfront-guest-role-1’) AND enable_permissions = 1 AND has_read = 0 GROUP BY post_id HAVING COUNT(*) = 1) AND wp_posts.id NOT IN (SELECT post_id FROM wp_wpfront_ure_post_type_permissions WHERE role IN (‘wpfront-guest-role-1’) AND enable_permissions = 1 AND has_read = 0 GROUP BY post_id HAVING COUNT(*) = 1) AND wp_posts.id NOT IN (SELECT post_id FROM wp_wpfront_ure_post_type_permissions WHERE role IN (‘wpfront-guest-role-1’) AND enable_permissions = 1 AND has_read = 0 GROUP BY post_id HAVING COUNT(*) = 1) AND wp_posts.id NOT IN (SELECT post_id FROM wp_wpfront_ure_post_type_permissions WHERE role IN (‘wpfront-guest-role-1’) AND enable_permissions = 1 AND has_read = 0 GROUP BY post_id HAVING COUNT(*) = 1) ORDER BY (CASE WHEN wp_posts.post_title LIKE ‘%Cherche l\’organisation du CIC %’ THEN 1 WHEN wp_posts.post_title LIKE ‘%Cherche%’ AND wp_posts.post_title LIKE ‘%l\’organisation%’ AND wp_posts.post_title LIKE ‘%du%’ AND wp_posts.post_title LIKE ‘%CIC%’ THEN 2 WHEN wp_posts.post_title LIKE ‘%Cherche%’ OR wp_posts.post_title LIKE ‘%l\’organisation%’ OR wp_posts.post_title LIKE ‘%du%’ OR wp_posts.post_title LIKE ‘%CIC%’ THEN 3 WHEN wp_posts.post_excerpt LIKE ‘%Cherche l\’organisation du CIC %’ THEN 4 WHEN wp_posts.post_content LIKE ‘%Cherche l\’organisation du CIC %’ 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
