05-01-2014, 11:08 AM
I also did a search on test site (http://edir.freeserver.me/) with only the city London and this is the error that came back:
ERROR: http://edir.freeserver.me/results.php
Query: SELECT location_ AS location_id FROM Listing_Summary WHERE Listing_Summary.status = 'A' AND MATCH (Listing_Summary.fulltextsearch_where) AGAINST ('(+london) (+londons)' IN BOOLEAN MODE) AND location_ > 0
Errno: 1054
Error: Unknown column 'location_' in 'field list'
_SERVER data
REMOTE_ADDR : 70.197.2.26
REMOTE_PORT : 36228
SCRIPT_FILENAME : /home/u396189393/public_html/results.php
REQUEST_METHOD : GET
QUERY_STRING : where=london&keyword=
REQUEST_URI : /results.php?where=london&keyword=
ERROR: http://edir.freeserver.me/results.php
Query: SELECT location_ AS location_id FROM Listing_Summary WHERE Listing_Summary.status = 'A' AND MATCH (Listing_Summary.fulltextsearch_where) AGAINST ('(+london) (+londons)' IN BOOLEAN MODE) AND location_ > 0
Errno: 1054
Error: Unknown column 'location_' in 'field list'
_SERVER data
REMOTE_ADDR : 70.197.2.26
REMOTE_PORT : 36228
SCRIPT_FILENAME : /home/u396189393/public_html/results.php
REQUEST_METHOD : GET
QUERY_STRING : where=london&keyword=
REQUEST_URI : /results.php?where=london&keyword=