Dynamic Filter [Support Thread]

[Justrimless]

The first 40 or so, up to around
http://one stopglasses.co.uk/index.php?main_page=product_info&cPath=55&products_id=998

[Design75]

The first 40 or so, up to around
http://one stopglasses.co.uk/index.php?main_page=product_info&cPath=55&products_id=998

Is there any difference in how you set up this attribute as compared to for example the Head_size attribute?

[Justrimless]

Apart from the fact that I set up Head Width filter a couple of years ago, no.

[Justrimless]

Apart from the fact that I set up Head Size filter a couple of years ago, no.

Head Size, sorry.

I set up the Head Size/Colour/Frame Type attributes some years ago, they filter fine. As will some other ones if I enable them (pupil distance for example)

Just no results on any newly added ones.

[slf3]

Hi

This is a brillant plugin - many thanks.

Summary: In my implementation the plugin only returns products with 32 or less products_attributes records.

Is this just me or has anyone else come across it? I've searched similar postings on this thread but not found any, so my apologies if this has already been covered and solved before.

Symptoms: go to a category and then 'narrow your results', say by selecting a colour. The result that comes back includes all matching products EXCEPT for those with more than 32 products_attributes.

Solving the problem: I deleted a few of the product_attributes from one of the products affected, taking the number down to 27, and it worked. That product now appears in the 'refine your results' page.

How I investigated: I spent three days, on and off, checking everything I could think of including the code, walking through the generated SQL, our data, and removing then re-installing the code, and couldn't find anything. Then I realised that this only happened to products with a large number of product_attributes.

Could it be a configuration issue? I couldn't see a maximum products_attributes variable but there may be one.

Any ideas welcome?

BTW (since some people may ask) we do need more than 32 variants for some of the products.

Zencart 1.5.5a
Database: MySQL 5.5.5-10.1.22-MariaDB
PHP Version: 5.6.30 (Zend: 2.6.0)
PHP Memory Limit: 128M

We have been running live on zencart since around 2010.

[Justrimless]

Hi

Summary: In my implementation the plugin only returns products with 32 or less products_attributes records.

Is this just me or has anyone else come across it? I've searched similar postings on this thread but not found any, so my apologies if this has already been covered and solved before.

Symptoms: go to a category and then 'narrow your results', say by selecting a colour. The result that comes back includes all matching products EXCEPT for those with more than 32 products_attributes.

Solving the problem: I deleted a few of the product_attributes from one of the products affected, taking the number down to 27, and it worked. That product now appears in the 'refine your results' page.

How I investigated: I spent three days, on and off, checking everything I could think of including the code, walking through the generated SQL, our data, and removing then re-installing the code, and couldn't find anything. Then I realised that this only happened to products with a large number of product_attributes.

Could it be a configuration issue? I couldn't see a maximum products_attributes variable but there may be one.

Any ideas welcome?

Hi,
Are you on shared hosting.

Most of the issues I have had with this mod, where it works sporadically, have been resource based.

[slf3]

Hi, just a single website on a Cloud server, plenty of memory etc. I can adjust resources as much as I want if that would help. Which ones should I look at?

Server OS: Linux 3.10.0-229.14.1.el7.centos.onapp.x86_64
HTTP Server: Apache
PHP Version: 5.6.30 (Zend: 2.6.0)
PHP Memory Limit: 128M
Database: MySQL 5.5.5-10.1.22-MariaDB
Database Data Size: 95,400 kB
Database Index Size: 24,807 kB

[slf3]

Does anyone have a website where a single product has more than 32 product attributes? And if so, does that product get returned when you use the 'narrow your results' function?

[Justrimless]

I set up the Head Size/Colour/Frame Type attributes some years ago, they filter fine. As will some other ones if I enable them (pupil distance for example)

Just no results on any newly added ones.

I have had a minor breakthrough. I think.
I noted that all my attributes up to option ID '35' filter fine, ones after that do not.

I have some missing options IDs where I have deleted old attributes, so in phpmyadmin I copied a row and gave it an id of '2', set up test products and attributes of that ID and it seems to search fine.

Whatever works eh?

[strelitzia]

Can this mod filter on read only attributes as well?