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.

Loaded Commerce Community

Advanced search repeatable bug with price search

Who is online

Main Menu

Login

Forums Latest Activity

Top Listing