Hi,
After doing an automatic upgrade from WP 3.0.2 to 3.1.3 the search function isn’t working properly. I disabled plugins etc.
http://thebeautifulhousecompany.com/search/ displays with an example search string of “Swimming Pool” (with quotes). With WP 3.0.2, this displayed all 8 properties with swimming pools. With WP 3.1.3, no properties are returned. I use quotes for exact matching otherwise properties with pool tables are returned. One word searches are fine. The problem only occurs when using double quotes.
If I go into the wp dashboard and click on posts, then enter "Swimming Pool" (with the quotes") in the 'search posts box' top right of the screen. I get the correct results back – the 8 properties with swimming pools.
The URL address after the dashboard search is:-
http://thebeautifulhousecompany.com/wp-admin/edit.php?s=%22swimming+pool%22&post_status=all&post_type=post&action=-1&m=0&cat=0&paged=1&mode=list&action2=-1
When I do the search via the search page, the URL address is:-
http://thebeautifulhousecompany.com/?s=%22Swimming+Pool%22&et-cat=0&et_searchform_submit=et_search_proccess
I was hoping to be able to see the SQL passed via the dashboard/search page by switching general logging on but JUSTHOST (who host the website) are unable to set logging on as it’s a shared MySQL server.
I have a version of the website on my desktop running under xampp/apache/MySQL. When I updated that from 3.0.2 to 3.1.3, the search works fine.
My initial thought was that as the dashboard search works ok, the problem must be somewhere around the search.php / page-search.php /searchform.php area, but then why does it work on localhost?
I’m not able to upgrade to 3.2 as JUSTHOST use PHP 5.2.14 (5.2.4 required).
Thanks
Chris