WordPress database error

Anonymous

#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

#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

#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

#28753

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

Thanks, Ross!

[Author]

Posts