← Back to Search & Filter

WordPress database error

Posted

by

Forums › Forums › Search & Filter Pro › WordPress database error

Viewing 4 posts – 1 through 4 (of 4 total)
  • Anonymous
    (Private)  November 2, 2015 at 7:14 pm #28741

    Hello,
    We’re getting a lot of PHP errors related to the Search & Filter plugin. Can you give me some insight into what may be causing these?

    Thanks!

    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query
    SELECT field_name, field_value, field_value_num
    FROM wp_search_filter_cache
    WHERE post_id = ‘568’
    made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query DELETE FROM wp_search_filter_cache WHERE post_id = 568 made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_delete_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query
    SELECT field_name, field_value, field_value_num
    FROM wp_search_filter_cache
    WHERE post_id = ‘571’
    made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query DELETE FROM wp_search_filter_cache WHERE post_id = 571 made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_delete_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query
    SELECT field_name, field_value, field_value_num
    FROM wp_search_filter_cache
    WHERE post_id = ‘572’
    made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query DELETE FROM wp_search_filter_cache WHERE post_id = 572 made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_delete_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query
    SELECT field_name, field_value, field_value_num
    FROM wp_search_filter_cache
    WHERE post_id = ‘575’
    made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query DELETE FROM wp_search_filter_cache WHERE post_id = 575 made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_delete_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query
    SELECT field_name, field_value, field_value_num
    FROM wp_search_filter_cache
    WHERE post_id = ‘576’
    made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query DELETE FROM wp_search_filter_cache WHERE post_id = 576 made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_delete_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query
    SELECT field_name, field_value, field_value_num
    FROM wp_search_filter_cache
    WHERE post_id = ‘577’
    made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query DELETE FROM wp_search_filter_cache WHERE post_id = 577 made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_delete_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query
    SELECT field_name, field_value, field_value_num
    FROM wp_search_filter_cache
    WHERE post_id = ‘579’
    made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query DELETE FROM wp_search_filter_cache WHERE post_id = 579 made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_delete_cache
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies
    [23-Oct-2015 18:57:31 UTC] WordPress database error Table ‘pantheon.wp_search_filter_cache’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_search_filter_cache made by do_action(‘wp_ajax_nopriv_process_cache’), call_user_func_array, Search_Filter_Post_Cache->process_cache, Search_Filter_Post_Cache->update_post_cache, Search_Filter_Post_Cache->post_update_taxonomies

    Anonymous
    (Private)  November 2, 2015 at 7:47 pm #28746

    I’m realizing now that the tables don’t exist. Maybe this was due to the way we upgraded from 1.x to 2.x? How can we create these tables?

    Thanks!
    John

    Ross Moderator
    (Private)  November 2, 2015 at 7:49 pm #28748

    All you need to do is deactivate S&F and re-activate and the tables should be created.

    I’m guessing you overwrote the plugin files via FTP and the activation process didn’t occur 🙂

    Thanks

    Anonymous
    (Private)  November 2, 2015 at 7:56 pm #28753

    You nailed it. Just followed your instructions and it’s working properly.

    Thanks, Ross!

  • Author
    Posts
Viewing 4 posts – 1 through 4 (of 4 total)
Search & Filter Support
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

We also use cookies to store items in your cart as well as allowing your to login on the site.

You can adjust all of your cookie settings by navigating the tabs on the left hand side.

By continuing to use this site, you also agree to our Privacy Policy.