Just searched over Google for this type of error and this is what I have determined;
In your admin/customers.php file,
find :
PHP Code:
$search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%' or c.customers_telephone rlike '" . $keywords . "' or a.entry_company rlike '" . $keywords . "' or a.entry_street_address rlike '" . $keywords . "' or a.entry_city rlike '" . $keywords . "' or a.entry_postcode rlike '" . $keywords . "'";
replace with:
PHP Code:
$search = "where (c.customers_lastname like '%" . $keywords . "%') or (c.customers_firstname like '%" . $keywords . "%') or (c.customers_email_address like '%" . $keywords . "%') or (c.customers_telephone rlike '" . $keywords . "') or (a.entry_company rlike '" . $keywords . "') or (a.entry_street_address rlike '" . $keywords . "') or (a.entry_city rlike '" . $keywords . "') or (a.entry_postcode rlike '" . $keywords . "')";
Additionally, this is what admin/linkpoint_review.php states similarly:
PHP Code:
$search = "where lp.customer_id = c.customers_id and (c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%' or c.customers_telephone rlike '" . $keywords . "' or c.customers_id='" . $keywords . "')";
The parenthese are in.
Bookmarks