Hi guys
I dont get any data returned from my search.
http://showroom.ie/?geodir_search=1&s=+&snear=&sgeo_lat=&sgeo_lon=
I have SQL profiller on and the sql outputted is listed below.
When I run this sql I get the following error
Table ‘whatreta_show.geodir__detail’ doesn’t exist
DO you know what the table geodir__detail represents.
Thanks a lot
dave
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, geodir__detail.* FROM wp_posts INNER JOIN geodir__detail ON (geodir__detail.post_id = wp_posts.ID) WHERE 1=1 AND ( ( wp_posts.post_title LIKE “%%” ) OR ( wp_posts.post_content LIKE “%%”) OR ( wp_posts.ID IN( SELECT wp_term_relationships.object_id as post_id FROM wp_term_taxonomy, wp_terms, wp_term_relationships WHERE wp_term_taxonomy.term_id = wp_terms.term_id AND wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id AND wp_term_taxonomy.taxonomy IN ( ‘gd_place_tags’,’gd_placecategory’ ) AND (wp_terms.name LIKE”%%” OR wp_terms.name IN (“”)) ) ) ) AND wp_posts.post_type IN (‘gd_place’) AND (wp_posts.post_status = ‘publish’) ORDER BY geodir__detail.is_featured asc, wp_posts.post_date desc, wp_posts.post_title LIMIT 0, 10