Page 1 of 20 12311 ... LastLast
Results 1 to 10 of 808

Hybrid View

  1. #1
    Join Date
    Mar 2009
    Posts
    89
    Plugin Contributions
    0

    Default Dynamic Filter [Support Thread]

    Hi there, I'm using dynamic filter mod by damian taylor - which is an awesome mod btw, you can see it at work on his website http://www.snowrepublic.co.uk/ (click on a category). It's a product filter for prices, manufacturer, attributes etc...

    Anyway, the mod has been updated to work with 1.5 and I'm testing it on a brand new install with no other mods.

    When I switch admin->configure->productlisting->display category/manufacturer filter off (which is the default zencart product filter and required to be turned off to make parts of damians mod to work) I get errors.

    Here's one:
    [03-Mar-2012 13:36:42] PHP Fatal 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 '), 'Y', 'N') as flag FROM manufacturers WHERE manufacturers_id IN (0,) ORDER BY ' at line 1 :: SELECT manufacturers_id, manufacturers_name, IF(manufacturers_id IN(0,), 'Y', 'N') as flag FROM manufacturers WHERE manufacturers_id IN (0,) ORDER BY manufacturers_name in C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php on line 101
    and another:
    [02-Mar-2012 15:20:10] PHP Fatal 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 'GROUP BY p.products_id' at line 1 :: select distinct p.products_id FROM products p LEFT JOIN manufacturers m USING(manufacturers_id) LEFT JOIN products_description pd on p.products_id = pd.products_id JOIN products_to_categories p2c on p.products_id = p2c.products_id JOIN categories c on p2c.categories_id = c.categories_id LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 LEFT JOIN tax_rates tr ON p.products_tax_class_id = tr.tax_class_id LEFT JOIN zones_to_geo_zones gz ON tr.tax_zone_id = gz.geo_zone_id AND (gz.zone_country_id IS null OR gz.zone_country_id = 0 OR gz.zone_country_id = 222) AND (gz.zone_id IS null OR gz.zone_id = 0 OR gz.zone_id = 193) WHERE (p.products_status = 1 AND pd.language_id = 1 AND p2c.products_id = p.products_id AND p2c.products_id = pd.products_id AND (p2c.categories_id = 5)) AND p.products_date_added >= '20100101' and p.products_date_added <= '20120101' AND (p.products_price_sorter * IF(gz.geo_zone_id IS null, 1, 1 + (tr.tax_rate / 100)) >= 5) AND (p.products_price_sorter * IF(gz.geo_zone_id IS null, 1, 1 + (tr.tax_rate / 100)) <= 55) group by p.products_id, tr.tax_priority GROUP BY p.products_id in C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php on line 101
    So the problem is the SQL, but which is more correct - the mod's version (which presumably is uptodate coz it's been passed for 1.5) or my xampp version?

    Also, I don't suppose if anyone knows if this is an easy fix? :)

    thanks

  2. #2
    Join Date
    May 2010
    Posts
    33
    Plugin Contributions
    0

    Default Re: Dynamic Filter - getting sql errors

    Really a great Mod. I installed in my 1.3.7.1 version and works perfect except with the prices ranges that show me the ranges without tax. For example if I select a price range between 100€ and 200€, the product list show me products until 236€, just 1,18% VAT.

    Any ideas about how to the price range selector include the TAX?

    Thank you.

  3. #3
    Join Date
    Mar 2009
    Posts
    89
    Plugin Contributions
    0

    Default Re: Dynamic Filter - getting sql errors

    well even though you're kind of hijacking my thread which will probably mean that no-one will ever answer me I suppose no-one had answered yet so... ah well

    the mod calculates the price ranges in the file includes/templates/your_template/sideboxes/tpl_dynamic_filter.php

    around line 71 is where it creates the $priceArray[] which is the products_price_sorter field from the products table in the DB (exactly the same as product_price field - ie the price without tax) I guess you just need to alter that line so that the price which ends up in the array is including tax. Not sure if there's a zen way of doing this, there probably is :)

    hth

    ps don't suppose you know anything about SQL?

  4. #4
    Join Date
    Mar 2009
    Posts
    89
    Plugin Contributions
    0

    Default Re: Dynamic Filter - getting sql errors

    In case it helps the sql gets made like this:

    $categories = $db->Execute("SELECT categories_id, categories_name, IF(categories_id IN (" . implode(',', $filteredCategories) . "), 'Y', 'N') as flag" .
    " FROM " . TABLE_CATEGORIES_DESCRIPTION .
    " WHERE categories_id IN (" . implode(',', $unfilteredCategories) . ")" .
    " ORDER BY categories_name");

    $filteredCategories and $unfilteredCategories are just arrays with master_category_id's in them.

    I'm currently reading through some sql text books but I haven't yet got my head around all these inner-queries and IN and IF and blaa blaa...

  5. #5
    Join Date
    Jul 2009
    Posts
    127
    Plugin Contributions
    0

    Default Re: Dynamic Filter - getting sql errors

    How do you control which filters show up. I thought it had to do with the option values but not all of the option values appear, more specifically the filter for that attribute or option doesn't even appear on the page. I left the include option blank on the Dynamic filter configuration page.

  6. #6
    Join Date
    Jul 2006
    Location
    Holland
    Posts
    27
    Plugin Contributions
    0

    Default Re: Dynamic Filter - getting sql errors

    Quote Originally Posted by ppsoyal View Post
    Really a great Mod. I installed in my 1.3.7.1 version and works perfect except with the prices ranges that show me the ranges without tax. For example if I select a price range between 100€ and 200€, the product list show me products until 236€, just 1,18% VAT.

    Any ideas about how to the price range selector include the TAX?

    Thank you.
    Hi, great mod, is there an solution fore issue mentioned above ?

  7. #7
    Join Date
    Aug 2009
    Posts
    368
    Plugin Contributions
    0

    Default Re: Dynamic Filter - getting sql errors

    I have just installed the module on a test system ( 1.5.0 ) and only Filter by price option is visible on left side . I would like to see also Filter by manufacturer , what should I check for ?
    Last edited by solo_400; 25 Apr 2013 at 12:42 PM.

  8. #8
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,846
    Plugin Contributions
    25

    Default Re: Dynamic Filter - getting sql errors

    Quote Originally Posted by solo_400 View Post
    I have just installed the module on a test system ( 1.5.0 ) and only Filter by price option is visible on left side . I would like to see also Filter by manufacturer , what should I check for ?
    did you remember to turn off the manufacturers dropdown (alpha filter)?

  9. #9
    Join Date
    Aug 2009
    Posts
    368
    Plugin Contributions
    0

    Default Re: Dynamic Filter - getting sql errors

    Bingo ! thank you so much

  10. #10
    Join Date
    Mar 2012
    Posts
    26
    Plugin Contributions
    0

    Default Dynamic Filter 1.0 not working for Options

    Hello,
    I installed Damian Taylor's Dynamic Filter 1.0 and it seems to work fine expect I always get no results when filtering on my 1 defined option (4 choices, test products have 2 of 4 assigned).

    I check and rechecked the options and they appear correct and hsow up on the prduct pages.

    The Filter displays the correct options (the 2 of the 4 I assigned to products) but when I choose one or the other, no products are found.

    Any thoughts?

    Thanks!
    David

 

 
Page 1 of 20 12311 ... LastLast

Similar Threads

  1. Hebrew Support - latest release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 19
    Last Post: 23 Jan 2023, 08:04 AM
  2. Empty Dynamic Filter
    By LadyoftheCave in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 6 Jun 2016, 12:47 PM
  3. v150 Dynamic filter
    By Dinoleix in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 13 Aug 2013, 10:23 AM
  4. v150 Dynamic filter - All pages
    By Okkwebmedia in forum Addon Sideboxes
    Replies: 0
    Last Post: 8 Jul 2013, 08:52 AM
  5. v138a Dynamic Filter
    By SoftCorpse in forum All Other Contributions/Addons
    Replies: 9
    Last Post: 18 Jun 2012, 01:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR