Search Filter Strangeness

Upgraded and updated to 1.3.9c. Since 1.3.9a, I'm having a sort of problem-within-a-problem regarding product display and the search filters.

First, products no longer display alphabetically by title upon clicking a manufacturer's index or category. I'm using the product search filter mod to jazz up my alpha sorter. So one can always choose "Title" from the altered alpha filter to fix that. However, I thought I might avoid that extra click by setting the product listing display, but I'm not sure what the setting should be. I used the given example of "2a" as a starting point of reference. Then received an SQL error in the store when clicking a category.

The 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 '' at line 7
in:
[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 zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '110' order by ]

Secondly, the Category/Manufacturer filter doesn't display when clicking a manufacturer category vs. clicking their name from the manufacturer sidebox. Meaning, if you click from the category, only the alpha sorter filter shows, but if you click from the sidebox you get both filters. How can I get the Category/'Manufacturer filter to display regardless of how one arrives to a category?

Thank you very much! :)

Are you sure it was fine in your 1.3.9a ? The reason I ask is because I don't recall changing anything related to search or alpha filters etc in 139b or 139c. There were several improvements from 138a to 139a related to filters etc, and I'm wondering if maybe the problem is related to something missed in your 138-to-139 upgrade?

Or maybe it's just a broken addon?

Do you mind providing a URL and a click-for-click to reproduce the problem? Ajeh wants to peek :)

Hi, DrB!

No, it wasn't fine in 1.3.9a. I'm sorry if that wasn't clear in my original post. I've noticed these issues happening since that initial upgrade.

You know where my site is. By all means, Linda is more than welcome to take a look. If you need me to post it here, will you please delete it afterwards?

I'm not sure what a "click-for-click" means. What I clicked to receive the error?

The product listing not being in alpha order "by default" is able to be reproduced by visiting any manufacturer index. There is also a category called "Shop by Designer" which mirrors the manufacturer sidebox. The product listing display seems to be the same via both, while clicking any manufacturer from their category vs. clicking from the sidebox results in only one search filter. Could this be because they're technically subcategories of Shop by Designer? Doh. That just dawned on me. LOL!

I'd have to set the Product Listing setting back to 2a to reproduce the SQL error, which I'd rather not do on my live site. I can set my testing site that way if you'd like and PM you with a link.

Thanks, DrB! :)

What happens if you switch to the Classic Template?

And can you search in the Developers Tool Kit in the bottom input box for:
default_filter.php

what is the version on that?

and where is it located?

Hi, Linda!

I should have thought to try reverting templates before posting. Looking suitably ashamed. Hehe!

Using Classic, it seems the mod may be interfering a bit. Product display is alphabetical again. I don't get the SQL error if I set Product Listing to 2a, either. I'll have to look more closely at the changes in their default_filter.php file, which I'd merged with the new Zen file after upgrading. So the version now is:

@version $Id: default_filter.php 14870 2009-11-19 22:36:24Z drbyte $

When using my template, the modded file is located in an override directory:

/includes/index_filters/my_template/default_filter.php

When using Classic, the original file, which is here:

/includes/index_filters/default_filter.php

One down, maybe one to go.

I'm still missing the Category/'Manufacturer search filter in Classic when clicking a manufacturer index via their "subcategory" as opposed to arriving from the sidebox, where I get both filters. I get both filters when visiting other subcategories, the left filter displaying manufacturers.

Which leads me to think this too may be solved (or explained, if never a problem to begin with LOL) if I assume the category side doesn't kick in when the filter "thinks" a subcategory is already drilled-down and therefore doesn't need additional category filtering. Even though it does. And it would be nice. ;)

Sooo . . . not sure if I'm still in fix-it land or now we've ventured into wish list territory. LOL! Many thanks in either case! :)

Check the settings in Configuration ... Product Listing ...

Display Category/Manufacturer Filter (0=off; 1=on)
Do you want to display the Category/Manufacturer Filter?

On 1. Or I wouldn't see it at all, right?

It's funny, if I turn off the alpha filter, the category/manufacturer filter also goes away. I'd like both filters all the time - if possible. :)

Did you try turning off the:

Include Product Listing Alpha Sorter Dropdown
Do you want to include an Alpha Filter dropdown on the Product Listing?

true
false

There was a problem, I believe, in v1.3.8 ... v1.3.9 has this fixed ...

So again, check your templates ...

Linda, is this correct for overriding files in the index_filters folder?

When using my template, the modded file is located in an override directory:

/includes/index_filters/my_template/default_filter.php

When using Classic, the original file, which is here:

/includes/index_filters/default_filter.phpI ask because I have been searching if there is an override directory for these files as there is no Classic folder here lol and I'd like to make sure of this is correct before blithely going ahead and doing it :P

Good question ...

I am pretty sure that there is no overrides directory for that ... I haven't played there for awhile ...

You can test it by making one ... and no change says ... there isn't one ... :smile:

Then, when you discover it does not work, remove your template directory and save a backup of the original file then overwrite it with your changes ...

Thanx Linda, I did try it, and it looked like it didn't work....however the modification I made to the original which works on my store doesn't seem to be working on my client's store and I don't know why LOL so I will have to dig into that further...it's just a small code edit that is supposed to make the product listing sort by newest products added

Been one of those days lmao

Be sure to let us know what you discover to be the missing piece of code ... :smile:

Weeeellllll....it turned out to be user blondeness LOL a piece I missed editing and it's working now LOL

:oops:

I have yet to test it in an override directory...hopefully will get a chance to do that later LOL

It is always those little things that sneak up to get you ... :lamo:

lol yeah it's gremlins I say :wacko: LOL