Database error for 's%' OR postmeta.meta_value LIKE
-
I’m getting database errors associated with CP Related posts. I think it has something to will tags that contain “apostrophe s”. Below is one of several examples:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's%' OR postmeta.meta_value LIKE '%chicago%' OR postmeta.meta_value LIKE '%announ' at line 1 for query SELECT posts.*, postmeta.meta_value FROM wp_7637posts as posts, wp_7637postmeta as postmeta WHERE posts.post_type IN ('post','page') AND posts.post_status='publish' AND posts.ID = postmeta.post_id AND posts.ID <> 4639 AND postmeta.meta_key = 'cprp_tags' AND (postmeta.meta_value LIKE '%sports%' OR postmeta.meta_value LIKE '%cubs%' OR postmeta.meta_value LIKE '%bloomberg%' OR postmeta.meta_value LIKE '%system%' OR postmeta.meta_value LIKE '%technology%' OR postmeta.meta_value LIKE '%baseball%' OR postmeta.meta_value LIKE '%partnership%' OR postmeta.meta_value LIKE '%analytic%' OR postmeta.meta_value LIKE '%evaluation%' OR postmeta.meta_value LIKE '%player%' OR postmeta.meta_value LIKE '%players%' OR postmeta.meta_value LIKE '%operations%' OR postmeta.meta_value LIKE '%customized%' OR postmeta.meta_value LIKE '%years%' OR postmeta.meta_value LIKE '%fans%' OR postmeta.meta_value LIKE '%will%' OR postmeta.meta_value LIKE '%video%' OR postmeta.meta_value LIKE '%partner%' OR postmeta.meta_value LIKE '%management%' OR postmeta.meta_value LIKE '%theo%' OR postmeta.meta_value LIKE '%analytics%' OR postmeta.meta_value LIKE '%teams%' OR postmeta.meta_value LIKE '%advanced%' OR postmeta.meta_value LIKE '%excited%' OR postmeta.meta_value LIKE '%data%' OR postmeta.meta_value LIKE '%department%' OR postmeta.meta_value LIKE '%leaders%' OR postmeta.meta_value LIKE '%world's%' OR postmeta.meta_value LIKE '%chicago%' OR postmeta.meta_value LIKE '%announced%' OR postmeta.meta_value LIKE '%design%' OR postmeta.meta_value LIKE '%mlb%' OR postmeta.meta_value LIKE '%step%' OR postmeta.meta_value LIKE '%state-of-the-art%') AND postmeta.post_id NOT IN ( SELECT post_id FROM wp_7637postmeta WHERE meta_key = 'cprp_exclude_from_posts') made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/legatus-theme/single.php'), get_template_part, locate_template, load_template, require('/themes/legatus-theme/includes/news-single.php'), the_content, apply_filters('the_content'), call_user_func_array, cprp_content, _cprp_content
- The topic ‘Database error for 's%' OR postmeta.meta_value LIKE’ is closed to new replies.