Urban Giraffe Support | HeadSpace
Wordpress database error when searching tags
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 > Meta-Data and want to search my tags/keywords, for example, for the tag "morbid-whimsy". Here's the error I get:
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]
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
Please note that I don't put the quotes around it, I just type morbid-whimsy in the search space.
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.
Any ideas? Thanks!
Responses
Posted 6 days ago by Key Master
Should be fixed now.
Reply
You must log in to post.