http://urbangiraffe.com/support/ Urban Giraffe Support Topic: Wordpress database error when searching tags en Fri, 05 Dec 2008 02:51:21 +0000 http://urbangiraffe.com/support/topic/wordpress-database-error-when-searching-tags#post-345 Thu, 21 Aug 2008 07:05:46 +0000 John 345@http://urbangiraffe.com/support/ <p>Should be fixed now. </p> http://urbangiraffe.com/support/topic/wordpress-database-error-when-searching-tags#post-157 Tue, 08 Apr 2008 03:04:36 +0000 Widgett 157@http://urbangiraffe.com/support/ <p>Howdy. Maybe this is just me that's having this issue, but...running 2.3.2 WP with HS 3.4.1. I go to Manage &gt; Meta-Data and want to search my tags/keywords, for example, for the tag "morbid-whimsy". Here's the error I get:</p> <p>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 'WHERE (wp_postmeta.meta_value LIKE "%morbid-whimsy%" OR wp_posts.post_title LIKE' at line 1]<br /> SELECT SQL_CALC_FOUND_ROWS wp_posts.ID,wp_posts.post_title FROM wp_posts WHERE post_type='page' OR post_type='post' WHERE (wp_postmeta.meta_value LIKE "%morbid-whimsy%" OR wp_posts.post_title LIKE "%morbid-whimsy%") ORDER BY wp_posts.ID DESC LIMIT 0,25</p> <p>Please note that I don't put the quotes around it, I just type morbid-whimsy in the search space.</p> <p>Also, if I just list posts without putting anything in the search, those come up. It's only when I search for something in particular that it breaks.</p> <p>Any ideas? Thanks! </p>