Dynamic Filter [Support Thread]

can some one help me dynamic Filter mod is not working By Size: it comes up

WARNING: An Error occurred, please refresh the page and try again.

http://barkingstud.com/index.php?mai...ex&cPath=19_20

Check your /logs folder (or /cache for Zencart version 1.3.9) for error log files.

I installed dynamic filter on my 1.51 store yesterday, and it seems to work OK. Just been checking my usually empty logs and surprised that its very full. They are all the same and state:

[29-Oct-2012 09:32:56] 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 'order by' at line 7 :: select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status
from products p left join specials s on p.products_id = s.products_id, products_description pd, manufacturers m
where p.products_status = 1
and pd.products_id = p.products_id
and pd.language_id = '1'
and p.manufacturers_id = m.manufacturers_id
and m.manufacturers_id = '1' order by pd.products_viewed DESC order by in /home/sites/xxxxxxxxx.co.uk/public_html/store/includes/classes/db/mysql/query_factory.php on line 120


Help please as this is totally over my head
Thanks

I guess its coming from the default_filter.php that I installed from the Dynamic Filter package. Hre are the suspect lines:


if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
if (isset($_GET['alpha_filter_id']) && (int)$_GET['alpha_filter_id'] > 0) {
//$alpha_sort = " and pd.products_name LIKE '" . chr((int)$_GET['alpha_filter_id']) . "%' ";
$filterid = (int)$_GET['alpha_filter_id'];
switch($filterid)
{


case 1:
$alpha_sort = " order by pd.products_viewed DESC";
break;
case 2:
$alpha_sort = " order by p.products_price";
break;
case 3:
$alpha_sort = " order by p.products_price DESC";
break;
case 4:
$alpha_sort = " order by pd.products_name";
break;
case 5:
$alpha_sort = " order by p.products_ordered DESC";
break;
case 6:
$alpha_sort = " order by p.products_date_added DESC";
break;
case 7:
$alpha_sort = " order by p.products_date_added";
break;

}
} else {
$alpha_sort = " order by pd.products_viewed DESC";
$filterid = 1;
}

OK just noticed that before I installed this mod that the only thing in the filter by drop down box was 'items beginning with'

That is still there in the dropdown box, I dont think it should be, is it that that is causing the error?

Also noticed that the url at top of web browser shows:

main_page=index&cPath=6&sort=&alpha_filter_id=0

when first going to a category page, from the above default_filter.php there is no id=0

When the filter by box is used then the filter_id changes to a 1 or what ever filter is selected as defined in the .php

Hi everybody!
I just installed Dynamic Filter mod but I get a bunch of errors:

Warning: array_filter() expects parameter 1 to be array, string given in /includes/modules/MYTEMPLATE/dynamic_filter.php on line 15
Warning: in_array() expects parameter 2 to be array, string given in /includes/templates/MYTEMPLATE/sideboxes/tpl_dynamic_filter.php on line 210
Warning: in_array() expects parameter 2 to be array, string given in /includes/templates/MYTEMPLATE/sideboxes/tpl_dynamic_filter.php on line 279
Warning: in_array() expects parameter 2 to be array, string given in /includes/templates/MYTEMPLATE/sideboxes/tpl_dynamic_filter.php on line 298
Warning: in_array() expects parameter 2 to be array, string given in /includes/templates/MYTEMPLATE/sideboxes/tpl_dynamic_filter.php on line 298

A lot of the latest actually.

What could be wrong because I have no idea?
Thank you!

Quote:

---

Originally Posted by SPH

It might be helpful if all Dynamic Filter posts could be in one support thread to easier locate and see any other issues and solutions.

---

I concur...


BTW, did you get that pricing thing figured out?

I'm having almost the exact opposite issue - - it works fine on All products, but really croaks when used in a category. any ideas where to look? (I'm on 1.5.0)....

Thanks a_berezin.

How to make the filter appear above the product listing going horizontal? I am trying to place it where the stock product filter is.

Which product listing php file would I have to modify. I tried both the tpl_modules_product_listings (in template folder) and product_listing (in modules folder) and have not had luck getting it to show.