X-Cart forums

[tcatrainer]

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

xcart_

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

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

[B00MER]

http://www.blazingdragon.com/store/customer/search.php?substring=&price_search_1=&price_search _2=&in_category=&x=46&y=2

works fine for me in 3.3.3, yes all tables have xcart_ so thats not the issue.