ajax container and products count

Anonymous

#114823

Ok, now category filter works fine, but meta filter for variants (“dlzka” witch means “length) not work.
When I change S&F settings “Search in the following post types:” to search in products and variants:

• category filter not works
• meta filter for variants works correct

Anonymous

#115592

any news in this ticket ?
I would like to start production version of my site and this is last issue I have.

Ross Moderator

#116432

Hi Veronika

I had another look. This issue is very confusing.

What I can see is some very strange behavior – and I think its a conflict with your theme + S&F.

Basically the meta variations now don’t work, because they are part of “variants” and in S&F you have only “products”.

If we enable “variations”, then categories filter doesn’t work.

I think what happens is, when there is a search for “products” + “variants” your theme (or another plugin) jumps in and makes some strange modifications to the query, which cause the unexpected results.

I cannot think of many options left except 2 (sorry but you need to do this to continue):

1) Disable all other plugins except content, woocommerce and S&F

Do you still get the issue?

2) Try another theme, just temporarily..

Do you still get the issue?

I bet, after one of these S&F will work normally, then we know where to investigate and I can set up a dev environment locally.

Thanks

Ross Moderator

#116434

This reply has been marked as private.

Anonymous

#116466

I’ve tried my tests (June/13) wo most of plugins and in twenty-sixteen theme.
I think that problem is not caused by SSL certificate error, but I’ve change certificate to valid one (certificate error was caused because certificate was issued to final/production domain name).

Again, I’ve disabled nearly all plugins and change theme to twenty-sixteen. You can do all tests you need.

From June 13, I’ve tried to find good combination of settings and also tried to looking into WP and S&F code to understand how this searching works. But I’m not as good in PHP/WP coding.

Maybe we can resolve this issue earlier without category filter. I don’t need it. I can replace it with product attributes.

Ross Moderator

#116662

This reply has been marked as private.

Anonymous

#117081

any news please ?

Ross Moderator

#117121

This reply has been marked as private.

Ross Moderator

#117226

This reply has been marked as private.

Anonymous

#117522

Yes, this is really bad news.
I really appreciate your support.
My site is in dev version, but filter is last thing I need to do. And it was lot of works to make actual version (all plugins and theme is turned off now). Complex WP reinstall will be really last of possibilities.

I’ve thought if it should not be problem in any DB compatibility. My install is:
Server type: MariaDB
Server version: 5.5.53-MariaDB-1ubuntu0.14.04.1 – (Ubuntu)
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)

Another idea was, that we can compare relevant DB tables and maybe we will find some diffs in good install and my (bad) install.
It will be fine, if we would know how look final (search) DB SELECT, after filter change. Is there exist any debug log for this purposes ?

I’ve deleted all products and all attributes, also categories and tags. And make new simple attributes “size1”. And make two variable products with this attribute.

Filter not work correctly. Size1 taxonomy filter shows zero products in combobox and after choose any of variant (i.e. “L”), it shows me all products and all variants.

Can we view what is DB SELECT, when Combo Box is filled ?
Can we view what is DB SELECT, when one of taxonomy (“L”) is choosed ?

Can you make wp installation with same attributes and products ? and give me a read access to this WP DB ? I will try to find any diffs 😉

I’m including some outputs from my DB:
You can see, that all products variants has attribute set:
SELECT pm.*,p.post_type,p.post_title FROMkqsglnpostmeta` pm
join kqsglnposts p on pm.post_id = p.id
where pm.meta_key like ‘%pa_size%’`

 meta_id 	post_id 	meta_key 	meta_value 	post_type 	post_title 	
76410 	2730 	attribute_pa_size1 	xl 	product_variation 	variable_product_2 - XL
76444 	2731 	attribute_pa_size1 	l 	product_variation 	variable_product_2 - L
76479 	2732 	attribute_pa_size1 	m 	product_variation 	variable_product_1 - M
76513 	2733 	attribute_pa_size1 	l 	product_variation 	variable_product_1 - L

Also terms relationship looks good on first view:
SELECT tr.object_id,p.post_type,p.post_title, tr.term_taxonomy_id, tt.*, t.name, t.slug FROMkqsglnterm_relationships` tr
join kqsglnposts p on p.id = tr.object_id
join kqsglnterm_taxonomy tt on tt.term_taxonomy_id = tr.term_taxonomy_id
join kqsglnterms t on t.term_id = tt.term_id
where p.post_type like ‘%product%’`

 object_id 	post_type 	post_title 	term_taxonomy_id 	term_taxonomy_id 	term_id 	taxonomy 	description 	parent 	count 	name 	slug 	
2724 	product 	variable_product_1 	4 	4 	4 	product_type 		0 	2 	variable 	variable
2727 	product 	variable_product_2 	4 	4 	4 	product_type 		0 	2 	variable 	variable
2724 	product 	variable_product_1 	176 	176 	176 	pa_size1 	medium 	0 	1 	M 	m
2724 	product 	variable_product_1 	177 	177 	177 	pa_size1 	large 	0 	2 	L 	l
2727 	product 	variable_product_2 	177 	177 	177 	pa_size1 	large 	0 	2 	L 	l
2727 	product 	variable_product_2 	178 	178 	178 	pa_size1 	extra large 	0 	1 	XL 	xl

[Author]

Posts