Forums › Forums › Search & Filter Pro › Cache not rebuilding
Tagged: rebuild cache
- This topic has 11 replies, 3 voices, and was last updated 5 years, 7 months ago by
Ross.
-
Anonymous(Private) April 6, 2019 at 2:50 pm #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
NadaAnonymous(Private) April 16, 2019 at 3:05 pm #208525Hi,
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(Private) April 18, 2019 at 10:04 am #208712On 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_dataIt explains why nothing was inserted in the cache, but what can I do to fix the problem?
Thank you for your helpAnonymous(Private) April 18, 2019 at 10:04 am #208714Here 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 INTObbtest_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 -
AuthorPosts
