{"id":11485974,"date":"2019-05-01T16:08:25","date_gmt":"2019-05-01T16:08:25","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/wordpress-database-error-135\/"},"modified":"2019-05-01T16:08:25","modified_gmt":"2019-05-01T16:08:25","slug":"wordpress-database-error-135","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/wordpress-database-error-135\/","title":{"rendered":"WordPress database error"},"content":{"rendered":"

Hello.
\nWouldn’t you know what could cause this error?<\/p>\n

[01-May-2019 16:04:33 UTC] WordPress database error Table ‘database_name.wp_posts’ doesn’t exist for query
\nSELECT filtered_post.id, filtered_post.out_of_stock, COUNT(filtered_post.ID) as post_count FROM
\n(
\n SELECT filtered_post.*, max_filtered_post.max_meta_count, stock_table.out_of_stock_init as out_of_stock FROM
\n (
\n SELECT jk2d_posts.id as var_id, jk2d_posts.post_parent as ID, COUNT(jk2d_posts.id) as meta_count FROM jk2d_posts
\n INNER JOIN jk2d_postmeta AS pf1 ON (jk2d_posts.ID = pf1.post_id)
\n WHERE jk2d_posts.post_type = “product_variation”
\n AND jk2d_posts.post_status != “trash”
\n AND pf1.meta_key IN (“attribute_pa_color”) AND pf1.meta_value IN (“red”)
\n GROUP BY jk2d_posts.id
\n ) as filtered_post
\n INNER JOIN
\n (
\n SELECT ID, MAX(meta_count) as max_meta_count FROM
\n (
\n SELECT jk2d_posts.id as var_id, jk2d_posts.post_parent as ID, COUNT(jk2d_posts.id) as meta_count FROM jk2d_posts
\n INNER JOIN jk2d_postmeta AS pf1 ON (jk2d_posts.ID = pf1.post_id)
\n WHERE jk2d_posts.post_type = “product_variation”
\n AND pf1.meta_key IN (“attribute_pa_color”) AND pf1.meta_value IN (“red”)
\n GROUP BY jk2d_posts.id
\n ) as max_filtered_post
\n GROUP BY ID
\n ) as max_filtered_post ON max_filtered_post.ID = filtered_post.ID AND max_filtered_post.max_meta_count = filtered_post.meta_count
\n LEFT JOIN
\n (
\n SELECT wp_posts.id as id, COALESCE(stock_table_init.out_of_stock_init1, “0”) as out_of_stock_init
\n FROM wp_posts
\n LEFT JOIN (
\n SELECT jk2d_posts.id as id, “1” as out_of_stock_init1
\n FROM jk2d_posts
\n WHERE jk2d_posts.id IN
\n (
\n SELECT object_id FROM jk2d_term_relationships
\n WHERE term_taxonomy_id IN ( 10 )
\n )
\n ) as stock_table_init on wp_posts.id = stock_table_init.id
\n GROUP BY id
\n ) as stock_table
\n ON filtered_post.var_id = stock_table.id
\n GROUP BY filtered_post.ID, out_of_stock
\n) as filtered_post
\nGROUP BY filtered_post.ID
\nHAVING post_count = 1 AND out_of_stock = 1
\n made by require(‘wp-blog-header.php’), require_once(‘wp-includes\/template-loader.php’), include(‘\/themes\/vantage-child\/woocommerce\/archive-product.php’), do_shortcode, preg_replace_callback, do_shortcode_tag, BeRocket_AAPF_single_filter->shortcode, the_widget, BeRocket_new_AAPF_Widget_single->widget, the_widget, BeRocket_AAPF_Widget->widget, BeRocket_AAPF_Widget::get_attribute_values, apply_filters(‘berocket_add_out_of_stock_variable’), WP_Hook->apply_filters, BeRocket_AAPF_compat_woocommerce_variation::out_of_stock_variable
\n[01-May-2019 16:04:33 UTC] WordPress database error Table ‘database_name.wp_posts’ doesn’t exist for query
\nSELECT filtered_post.id, filtered_post.out_of_stock, COUNT(filtered_post.ID) as post_count FROM
\n(
\n SELECT filtered_post.*, max_filtered_post.max_meta_count, stock_table.out_of_stock_init as out_of_stock FROM
\n (
\n SELECT jk2d_posts.id as var_id, jk2d_posts.post_parent as ID, COUNT(jk2d_posts.id) as meta_count FROM jk2d_posts
\n INNER JOIN jk2d_postmeta AS pf1 ON (jk2d_posts.ID = pf1.post_id)
\n WHERE jk2d_posts.post_type = “product_variation”
\n AND jk2d_posts.post_status != “trash”
\n AND pf1.meta_key IN (“attribute_pa_color”) AND pf1.meta_value IN (“silver”)
\n GROUP BY jk2d_posts.id
\n ) as filtered_post
\n INNER JOIN
\n (
\n SELECT ID, MAX(meta_count) as max_meta_count FROM
\n (
\n SELECT jk2d_posts.id as var_id, jk2d_posts.post_parent as ID, COUNT(jk2d_posts.id) as meta_count FROM jk2d_posts
\n INNER JOIN jk2d_postmeta AS pf1 ON (jk2d_posts.ID = pf1.post_id)
\n WHERE jk2d_posts.post_type = “product_variation”
\n AND pf1.meta_key IN (“attribute_pa_color”) AND pf1.meta_value IN (“silver”)
\n GROUP BY jk2d_posts.id
\n ) as max_filtered_post
\n GROUP BY ID
\n ) as max_filtered_post ON max_filtered_post.ID = filtered_post.ID AND max_filtered_post.max_meta_count = filtered_post.meta_count
\n LEFT JOIN
\n (
\n SELECT wp_posts.id as id, COALESCE(stock_table_init.out_of_stock_init1, “0”) as out_of_stock_init
\n FROM wp_posts
\n LEFT JOIN (
\n SELECT jk2d_posts.id as id, “1” as out_of_stock_init1
\n FROM jk2d_posts
\n WHERE jk2d_posts.id IN
\n (
\n SELECT object_id FROM jk2d_term_relationships
\n WHERE term_taxonomy_id IN ( 10 )
\n )
\n ) as stock_table_init on wp_posts.id = stock_table_init.id
\n GROUP BY id
\n ) as stock_table
\n ON filtered_post.var_id = stock_table.id
\n GROUP BY filtered_post.ID, out_of_stock
\n) as filtered_post
\nGROUP BY filtered_post.ID
\nHAVING post_count = 1 AND out_of_stock = 1
\n made by require(‘wp-blog-header.php’), require_once(‘wp-includes\/template-loader.php’), include(‘\/themes\/vantage-child\/woocommerce\/archive-product.php’), do_shortcode, preg_replace_callback, do_shortcode_tag, BeRocket_AAPF_single_filter->shortcode, the_widget, BeRocket_new_AAPF_Widget_single->widget, the_widget, BeRocket_AAPF_Widget->widget, BeRocket_AAPF_Widget::get_attribute_values, apply_filters(‘berocket_add_out_of_stock_variable’), WP_Hook->apply_filters, BeRocket_AAPF_compat_woocommerce_variation::out_of_stock_variable
\n[01-May-2019 16:04:33 UTC] WordPress database error Table ‘database_name.wp_posts’ doesn’t exist for query
\nSELECT filtered_post.id, filtered_post.out_of_stock, COUNT(filtered_post.ID) as post_count FROM
\n(
\n SELECT filtered_post.*, max_filtered_post.max_meta_count, stock_table.out_of_stock_init as out_of_stock FROM
\n (
\n SELECT jk2d_posts.id as var_id, jk2d_posts.post_parent as ID, COUNT(jk2d_posts.id) as meta_count FROM jk2d_posts
\n INNER JOIN jk2d_postmeta AS pf1 ON (jk2d_posts.ID = pf1.post_id)
\n WHERE jk2d_posts.post_type = “product_variation”
\n AND jk2d_posts.post_status != “trash”
\n AND pf1.meta_key IN (“attribute_pa_color”) AND pf1.meta_value IN (“yellow”)
\n GROUP BY jk2d_posts.id
\n ) as filtered_post
\n INNER JOIN
\n (
\n SELECT ID, MAX(meta_count) as max_meta_count FROM
\n (
\n SELECT jk2d_posts.id as var_id, jk2d_posts.post_parent as ID, COUNT(jk2d_posts.id) as meta_count FROM jk2d_posts
\n INNER JOIN jk2d_postmeta AS pf1 ON (jk2d_posts.ID = pf1.post_id)
\n WHERE jk2d_posts.post_type = “product_variation”
\n AND pf1.meta_key IN (“attribute_pa_color”) AND pf1.meta_value IN (“yellow”)
\n GROUP BY jk2d_posts.id
\n ) as max_filtered_post
\n GROUP BY ID
\n ) as max_filtered_post ON max_filtered_post.ID = filtered_post.ID AND max_filtered_post.max_meta_count = filtered_post.meta_count
\n LEFT JOIN
\n (
\n SELECT wp_posts.id as id, COALESCE(stock_table_init.out_of_stock_init1, “0”) as out_of_stock_init
\n FROM wp_posts
\n LEFT JOIN (
\n SELECT jk2d_posts.id as id, “1” as out_of_stock_init1
\n FROM jk2d_posts
\n WHERE jk2d_posts.id IN
\n (
\n SELECT object_id FROM jk2d_term_relationships
\n WHERE term_taxonomy_id IN ( 10 )
\n )
\n ) as stock_table_init on wp_posts.id = stock_table_init.id
\n GROUP BY id
\n ) as stock_table
\n ON filtered_post.var_id = stock_table.id
\n GROUP BY filtered_post.ID, out_of_stock
\n) as filtered_post
\nGROUP BY filtered_post.ID
\nHAVING post_count = 1 AND out_of_stock = 1
\n made by require(‘wp-blog-header.php’), require_once(‘wp-includes\/template-loader.php’), include(‘\/themes\/vantage-child\/woocommerce\/archive-product.php’), do_shortcode, preg_replace_callback, do_shortcode_tag, BeRocket_AAPF_single_filter->shortcode, the_widget, BeRocket_new_AAPF_Widget_single->widget, the_widget, BeRocket_AAPF_Widget->widget, BeRocket_AAPF_Widget::get_attribute_values, apply_filters(‘berocket_add_out_of_stock_variable’), WP_Hook->apply_filters, BeRocket_AAPF_compat_woocommerce_variation::out_of_stock_variable<\/p>\n

I am getting this when I enable WP debug. The filter works correctly itself.
\nThanks.<\/p>\n","protected":false},"template":"","class_list":["post-11485974","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/11485974","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/11485974\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=11485974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}