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
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