Advanced search repeatable bug with price search

cheapo · **Posted:** Wed Jul 22, 2009 5:24 pm

In CRELoaded Standard 6.3.3 and 6.4 (CE) if you use advanced search and enter in a price you will get this error:

Error reported on page /onstore/advanced_search_result.php

MySQL error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') >= 200) and (if(s.status and s.specials_new_products_price, p.products_price) ' at line 5

select count(distinct p.products_id) as total from ( products p left join specials_retail_prices s using(products_id) ) left join manufacturers m on p.manufacturers_id = m.manufacturers_id , products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (if(s.status and s.specials_new_products_price, p.products_price) >= 200) and (if(s.status and s.specials_new_products_price, p.products_price) <= 400)

This error also occurs on the demo site:
http://demos.creloaded.com/creloaded_ce ... from=&dto=

Mike

CRE Loaded Expert · **Posted:** Thu Jul 23, 2009 10:18 am

please try it on the b2b demo site.. as it works on my b2b installs.. which i would be happy to share those two files with you

the other demo site shows an internal error which may or may not be the same as your error

cheapo · **Posted:** Thu Jul 23, 2009 10:02 pm

It does work on the demo store for B2B. I would welcome the files to try then if it works I'll to a compate to try and figure out the difference between the two.

Thank you,
Mike

cheapo · **Posted:** Sun Aug 16, 2009 8:43 pm

Jason,

I haven't heard back from you in a little while on this so I was checking in to see if you could provide me the files to see if it fixes this issue?

Thanks!

Mike

minkglove · **Joined:** Thu Oct 21, 2004 12:00 am **Posts:** 281

I have the same issue on 6.4 Std... Any solutions yet? Thanks

cheapo · **Posted:** Wed Sep 30, 2009 10:00 pm

Unfortunately no reply from Jason nor anyone else.....

Nimitz1061 · **Posted:** Sun Nov 15, 2009 6:17 pm

This issue turns out to be related to a MySQL syntax error.

Change the and in lines 250 to 256 to a comma - as follows

Code:

  if (DISPLAY_PRICE_WITH_TAX == 'true') {
      if ($pfrom > 0) $where_str .= " and (IF(s.status , s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) >= " . (double)$pfrom . ")";
      if ($pto > 0) $where_str .= " and (IF(s.status , s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) <= " . (double)$pto . ")";
    } else {
      if ($pfrom > 0) $where_str .= " and ((IF(s.status , s.specials_new_products_price, p.products_price)) >=  " . (double)$pfrom . ")";
      if ($pto > 0) $where_str .= " and ((IF(s.status , s.specials_new_products_price, p.products_price)) <=  " . (double)$pto . ")";
    }
  }

I've reported this in the tracker at:

http://creforge.com/tracker/index.php?f ... 9&atid=543

cheapo · **Posted:** Mon Nov 16, 2009 6:04 pm

Cool!

Thank you VERY much!

ccwjr · **Posted:** Thu Nov 19, 2009 9:52 am

Nimitz1061 wrote:

I've reported this in the tracker at:

http://creforge.com/tracker/index.php?f ... 9&atid=543

The tracker has been closed with a new copy of the template/content/advanced_search.tpl.php file attached.

CRE Loaded Community

Advanced search repeatable bug with price search

Who is online

Main Menu

Login

Top Listing

Members Online

Follow Us on Twitter

CRE Loaded Community Chat hosted by CRE Loaded.