Cache not rebuilding

Anonymous

#207715

Hi,
I had installed search and filter on my website, all worked fine. For some reason we had to change our server at the webhosting so I reinstalled all wordpress and plugins. Since then, I get the message “Fetching cache information…” but nothing happens. When I click on ‘rebuild cache’ it seams to start something but it stops after 2 seconds and nothing happens.
On the system status page I have :

search_filter_cache` Exists: ✔ 0 Rows Found
search_filter_term_results` Exists: ✔ 0 Rows Found
Total Number of Fields Cached: 0
Fields in Cache:

I think it might come from this but I don’t know how to fix this.
Thanks
Nada

Trevor

#207756

Are you using a table prefix in the database? If so, edit the wp-config.php file and see whether it contains any uppercase characters?

Also, place WordPress in debug mode and see if it gives you any errors?

Anonymous

#208525

Hi,
I checked the uppercases in the database prefix. It is ok.
After some tries, it finally succeeded in rebuilding cache, it says now ‘Cache up to date, all systems go. ‘ but the counts (number of posts in each taxonomy) are all to 0 so when I choose ‘hide empty terms’ nothing appears.
Is there something I can do?

Anonymous

#208529

Just in case, taxonomy slugs have changed, maybe it can come from this?

Trevor

#208533

In the Status sub menu item (WP Admin-> Search & Filter -> Status), how many rows does each cache table have?

Anonymous

#208555

Always to zero 🙁

Anonymous

#208565

Maybe the database prefix is stored somewhere in search and filters and is not updated correctly?

Trevor

#208624

This reply has been marked as private.

Anonymous

#208712

On the debug.log I get the message :

Database error WordPress Duplicate field ‘0’ for key ‘PRIMARY’ for query INSERT INTO bbtest_search_filter_cache (post_id, post_parent_id, field_name, field_value_num, field_value, term_parent_id) VALUES (…..
) done by do_action(‘wp_ajax_nopriv_process_cache’), WP_Hook->do_action, WP_Hook->apply_filters, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, do_action(‘search_filter_pre_update_post_cache’), WP_Hook->do_action, WP_Hook->apply_filters, Search_Filter_Third_Party->sf_woocommerce_update_post_cache, Search_Filter_Third_Party->sf_woo_post_cache_add_variation_product_data, do_action(‘search_filter_insert_post_data’), WP_Hook->do_action, WP_Hook->apply_filters, Search_Filter_Post_Cache->insert_post_custom_post_data, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_insert_data

It explains why nothing was inserted in the cache, but what can I do to fix the problem?
Thank you for your help

Anonymous

#208714

Here is the complete msg :
[18-Apr-2019 08:59:20 UTC] Erreur de la base de données WordPress Duplicata du champ ‘0’ pour la clef ‘PRIMARY’ pour la requête INSERT INTO bbtest_search_filter_cache (post_id, post_parent_id, field_name, field_value_num, field_value, term_parent_id) VALUES (‘80855’, ‘80847’, ‘_sft_language’, ‘2’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_type’, ’15’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_cat’, ‘298’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘3314’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2692’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘3218’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘1929’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2684’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2648’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘3312’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2694’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2164’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘3270’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2640’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2690’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘3318’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2686’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘3264’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘3272’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘3316’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘3214’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2656’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘3320’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘1917’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘3310’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘3262’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2644’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2680’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2682’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2642’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_product_tag’, ‘2708’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_type-produit’, ‘2117’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_galon-largeur’, ‘3712’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_galon-categorie’, ‘662’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_couleur’, ‘572’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_couleur’, ‘580’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_couleur’, ‘564’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_couleur’, ‘566’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_couleur’, ‘570’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_couleur’, ‘576’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_couleur’, ‘574’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sfm__stock_status’, ‘0’, ‘instock’, ‘0’), (‘80855’, ‘80847’, ‘_sft_pa_taille’, ‘484’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sft_pa_coloris’, ‘3450’, ”, ‘0’), (‘80855’, ‘80847’, ‘_sfm__price’, ‘0’, ”, ‘0’) faite par do_action(‘wp_ajax_nopriv_process_cache’), WP_Hook->do_action, WP_Hook->apply_filters, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, do_action(‘search_filter_pre_update_post_cache’), WP_Hook->do_action, WP_Hook->apply_filters, Search_Filter_Third_Party->sf_woocommerce_update_post_cache, Search_Filter_Third_Party->sf_woo_post_cache_add_variation_product_data, do_action(‘search_filter_insert_post_data’), WP_Hook->do_action, WP_Hook->apply_filters, Search_Filter_Post_Cache->insert_post_custom_post_data, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_insert_data

[Author]

Posts