[wp-trac] [WordPress Trac] #35361: Error in SQL syntax search pagr

[WordPress Trac]

#35361: Error in SQL syntax search pagr
----------------------------+-----------------------------
 Reporter:  salvoaranzulla  |      Owner:
     Type:  defect (bug)    |     Status:  new
 Priority:  normal          |  Milestone:  Awaiting Review
Component:  Query           |    Version:  4.4.1
 Severity:  normal          |   Keywords:
  Focuses:                  |
----------------------------+-----------------------------
 Hi,

 After I have updated Wordpress to last version WordPress 4.4.1, Wordpress
 sometimes crashes on search page:

 [07-Jan-2016 13:05:32 UTC] WordPress errore sul database 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 'ELSE 5 END),
 sa2013_posts.post_date DESC LIMIT 0, 25' at line 1 per la query SELECT
 SQL_CALC_FOUND_ROWS  sa2013_posts.ID FROM sa2013_posts  WHERE 1=1  AND
 (((sa2013_posts.post_title LIKE '%lenovo%') OR (sa2013_posts.post_content
 LIKE '%lenovo%')) AND ((sa2013_posts.post_title LIKE '%lenovo%') OR
 (sa2013_posts.post_content LIKE '%lenovo%')) AND ((sa2013_posts.post_title
 LIKE '%tab%') OR (sa2013_posts.post_content LIKE '%tab%')) AND
 ((sa2013_posts.post_title LIKE '%2%') OR (sa2013_posts.post_content LIKE
 '%2%')) AND ((sa2013_posts.post_title LIKE '%a10-70l%') OR
 (sa2013_posts.post_content LIKE '%a10-70l%')) AND
 ((sa2013_posts.post_title LIKE '%za010058de%') OR
 (sa2013_posts.post_content LIKE '%za010058de%')) AND
 ((sa2013_posts.post_title NOT LIKE '%%') AND (sa2013_posts.post_content
 NOT LIKE '%%')) AND ((sa2013_posts.post_title LIKE '%blu%') OR
 (sa2013_posts.post_content LIKE '%blu%')))  AND
 (sa2013_posts.post_password = '')  AND sa2013_posts.post_type = 'post' AND
 (sa2013_posts.post_status = 'publish')  ORDER BY (CASE ELSE 5 END),
 sa2013_posts.post_date DESC LIMIT 0, 25 fatta da require('wp-blog-
 header.php'), wp, WP->main, WP->query_posts, WP_Query->query,
 WP_Query->get_posts
 [07-Jan-2016 16:57:01 UTC] WordPress errore sul database 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 'ELSE 5 END),
 sa2013_posts.post_date DESC LIMIT 0, 25' at line 1 per la query SELECT
 SQL_CALC_FOUND_ROWS  sa2013_posts.ID FROM sa2013_posts  WHERE 1=1  AND
 (((sa2013_posts.post_title LIKE '%Rito%') OR (sa2013_posts.post_content
 LIKE '%Rito%')) AND ((sa2013_posts.post_title LIKE '%Trailer%') OR
 (sa2013_posts.post_content LIKE '%Trailer%')) AND
 ((sa2013_posts.post_title LIKE '%Italiano%') OR (sa2013_posts.post_content
 LIKE '%Italiano%')) AND ((sa2013_posts.post_title LIKE '%Finale%') OR
 (sa2013_posts.post_content LIKE '%Finale%')) AND ((sa2013_posts.post_title
 LIKE '%Ufficiale%') OR (sa2013_posts.post_content LIKE '%Ufficiale%')) AND
 ((sa2013_posts.post_title LIKE '%HD%') OR (sa2013_posts.post_content LIKE
 '%HD%')) AND ((sa2013_posts.post_title NOT LIKE '%%') AND
 (sa2013_posts.post_content NOT LIKE '%%')) AND ((sa2013_posts.post_title
 LIKE '%TopCinema.it%') OR (sa2013_posts.post_content LIKE
 '%TopCinema.it%')))  AND (sa2013_posts.post_password = '')  AND
 sa2013_posts.post_type = 'post' AND (sa2013_posts.post_status = 'publish')
 ORDER BY (CASE ELSE 5 END), sa2013_posts.post_date DESC LIMIT 0, 25 fatta
 da require('wp-blog-header.php'), wp, WP->main, WP->query_posts,
 WP_Query->query, WP_Query->get_posts

--
Ticket URL: <https://core.trac.wordpress.org/ticket/35361>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform