Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Adavanced Search not working

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design
 
Thread Tools Search this Thread
  #1  
Old 03-03-2003, 07:44 PM
 
tcatrainer tcatrainer is offline
 

Advanced Member
  
Join Date: Nov 2002
Location: LI, NY
Posts: 50
 

Default 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
Reply With Quote
  #2  
Old 03-03-2003, 10:38 PM
  B00MER's Avatar 
B00MER B00MER is offline
 

X-Guru
  
Join Date: Sep 2002
Location: Keller, TX (Cart-Lab.com)
Posts: 3,165
 

Default

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.
__________________
Cart-Lab - 100+ Social Bookmarks for X-Cart.
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 04:12 AM.

   

 
X-Cart forums © 2001-2020