wp_atum_product_data Doesnt Exist
-
Hello,
Since last update, we can’t use ATUM anymore. Stock central doesnt show any product. (We have all products controlled with ATUM, also tried to control again via tools.)
We tried,
–> Changing theme, disabling all plugins (except ATUM and Woocommerce)
–> Delete ATUM completely with FTP and make fresh install
–> Delete Woocommerce completely and make fresh install
–> Refresh database with WooCommerce
When we turn on WP DEBUG we saw these errors,
1.)
WordPress database error: [Table ‘ourdatabasename.wp_atum_product_data’ doesn’t exist]
SELECT COUNT(*) FROM wp_atum_product_data ap INNER JOIN wp_posts p ON p.ID = ap.product_id WHERE ap.out_stock_threshold IS NOT NULL AND p.post_status IN (‘publish’, ‘future’, ‘private’);
____________________________
2.)
WordPress database error: [Table ‘ourdatabasename.wp_atum_product_data’ doesn’t exist]
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_atum_product_data ON ( wp_posts.ID = wp_atum_product_data.product_id ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (2,3,4) ) AND wp_posts.post_type = ‘product’ AND ((wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘private’)) AND ( ( CAST(wp_atum_product_data.atum_controlled AS SIGNED) = ‘1’ ) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC
3.)
WordPress database error: [Table ‘ourdatabasename.wp_atum_product_data’ doesn’t exist]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_atum_product_data ON ( wp_posts.ID = wp_atum_product_data.product_id ) WHERE 1=1 AND wp_posts.post_parent IN (1945,2907,2915,3212,2470,2737,2701,2281,2687,2843,2925,1791,2562,2647,2141,1954,2938,2714,2433,3081,2634,2339,2255,2268,3222,2012,2880,2293,3194,2419,3031,2549,2053,2328,2367,2394,2659,2163,2191,2230,2615,2025,2861,2977,2494,2507,2066,2456,3074,2889,2897,2948,2204,2726,2987,2481,3002,2243,3039,3061,2036,2085,3050,2588,2406,2853,2306,2114,1931,2518,2152,2178,3202,2380,2674,2445,2218,3010,3020,2575,2969,2354,2130,1994,2099,2601,2869) AND wp_posts.post_type = ‘product_variation’ AND ((wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘private’)) AND ( ( CAST(wp_atum_product_data.atum_controlled AS SIGNED) = ‘1’ ) ) ORDER BY wp_posts.menu_order ASC
4.)
WordPress database error: [Table ‘ourdatabasename.wp_atum_product_data’ doesn’t exist]
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_atum_product_data ON ( wp_posts.ID = wp_atum_product_data.product_id ) WHERE 1=1 AND wp_posts.ID NOT IN (1945,2907,2915,3212,2470,2737,2701,2281,2687,2843,2925,1791,2562,2647,2141,1954,2938,2714,2433,3081,2634,2339,2255,2268,3222,2012,2880,2293,3194,2419,3031,2549,2053,2328,2367,2394,2659,2163,2191,2230,2615,2025,2861,2977,2494,2507,2066,2456,3074,2889,2897,2948,2204,2726,2987,2481,3002,2243,3039,3061,2036,2085,3050,2588,2406,2853,2306,2114,1931,2518,2152,2178,3202,2380,2674,2445,2218,3010,3020,2575,2969,2354,2130,1994,2099,2601,2869) AND ( wp_term_relationships.term_taxonomy_id IN (2,3,4) ) AND wp_posts.post_type = ‘product’ AND ((wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘private’)) AND ( ( CAST(wp_atum_product_data.atum_controlled AS SIGNED) = ‘1’ ) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC LIMIT 0, 20
Can you help us with that problem please?
- The topic ‘wp_atum_product_data Doesnt Exist’ is closed to new replies.