Display Results As Thumbnails

Ross Moderator

#37943

This reply has been marked as private.

Anonymous

#37985

Hey, Ross,

the php developer I mentioned before noticed this:

“The table of Search&Filter for example has only 2 IDs for the taxonomy «Qualitaeten» although there should be 3. Moreover these 2 are corrupt AND not deposited in the WP-table.”

Does that help?

Ross Moderator

#38002

Hey Jurgen

I’m not sure what the dev meant about the IDs for taxonomies, but they probably don’t know how those tables are used with our caching system.

Anyway, they mentioned something about the table being corrupt.

If this is true, then it might help to rebuild the tables.

This should be quite easy – follow these steps:

1) Disable S&F (do not remove)
2) Manually delete both the S&F tables – wp_search_filter_cache & wp_search_filter_term_results
3) Enable S&F
4) Go to edit you search form and choose “Rebuild Cache”

When you enable S&F, it should detect and rebuild the tables automatically.

Hopefully this will fix your issue

Thanks

Anonymous

#38026

Hey, Ross,

I did exactly what you proposed, the tbles had been rebuilt, but regretfully it did not help.

I thought of what you said in another context: “How did you install S&F initially? It sounds like it might have been via FTP, in which case I’m sure there is something wrong with the permissions on the S&F folder.”

May it be that any permissions became corrupt in the context with the release of S&F 2.1?

Please see that we need a solution until Sunday. This is because the app we use runs out then. If we don´t find a solution with S&F we must install an alternative plugin.

Ross Moderator

#38052

This reply has been marked as private.

Anonymous

#39063

Hi all, I don’t know if this helps but I’m getting the same problem here… I did a little digging and found out that when excluding taxonomies the query does something rather odd… here is the query:

SELECT SQL_CALC_FOUND_ROWS wp_ifxo_posts.ID FROM wp_ifxo_posts WHERE 1=1 AND wp_ifxo_posts.ID IN (15949,15952,15954,16384,16415,16416,16417,16422,16423,16424,16425,16426,16427,16428,16429,16430,16431,16432,16433) AND ( 0 = 1 ) AND wp_ifxo_posts.post_type = 'attachment' AND ((wp_ifxo_posts.post_status = 'publish' OR wp_ifxo_posts.post_status = 'inherit')) GROUP BY wp_ifxo_posts.ID ORDER BY wp_ifxo_posts.post_date DESC LIMIT 0, 20

As you can see, there is a ( 0 = 1 ) and that will never give a result. The only way I can make the query work is by taking out the exclude. My belief is that there is a bug in the construction of the query when including/excluding taxonomies and when we filter our results.

If you want to see the layout of my query you can visit this page: http://media-pes.eu/search/ and then filter on the media type on the right. The query object is displayed below the results.

If you want more information let me know.

Ross Moderator

#39064

Hi Daniel

I took a look, certainly seems strange, but I think you have a different issue.

If I refresh the page, after a search, you get results… this means it should work with ajax disabled?

In this case there is something else going on, but keen to get to the bottom of it, can you open a new ticket and we can carry on there?

Thanks

Anonymous

#39076

done! here’s the link to the post: https://support.searchandfilter.com/forums/topic/ajax-query-not-working-properly-when-excluding-taxonomies/

[Author]

Posts