X-Cart forums - Adavanced Search not working

I am running 3.3.3

the search does not seem to search at all.
The entered text gives no results.

I noticed that my tables have the prefix

Code:

xcart_

but I changed this in the customer/search.php and I get sql errors

Code:

INVALID SQL: 1064 : You have an error in your SQL syntax near 'where categoryid=''' at line 1

SQL QUERY FAILURE: select category from where categoryid='' 



INVALID SQL: 1064 : You have an error in your SQL syntax near ') from , , where .productid=.productid and .quantity=1 and .categoryid=.categor' at line 1

SQL QUERY FAILURE: select count(distinct .productid) from , , where .productid=.productid and .quantity=1 and .categoryid=.categoryid AND (.membership='' OR .membership='') and (.membership='' or .membership='') and (.product like '%valve%' or .descr like '%valve%') and .category like '%' and .forsale='Y' AND .avail='Y'

So I assume this is wrong but why isnt the search searching?

Also when edititing the code is it required to edit
provider/search.php
customer/search.php
admin/search.php

or just the customer/search.php?

http://www.aeroaccess.com/parts/customer/search.php