• Resolved Berkinka

    (@berkinka)


    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?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Stock Management Labs

    (@stockmanagementlabs)

    Hi Berkinka,

    Thank you very much for your post.

    Sorry to hear you have issues in your site. I am forwarding this on our devs.
    We hope to get you some update on the next step in then ext few hours.

    Best Regards,

    Pavel

    Plugin Author Salva Machi

    (@salvamb)

    Hi @berkinka,

    The SQL error you described was fixed on ATUM version 1.5.0.2.

    Anyway, please check that the atum_product_data table was created on your database and that was populated with data after upgrading to ATUM 1.5.
    If you can’t see the table or the table is empty, try this:

    1.- If you don’t have the latest version of ATUM, please update it.
    2.- If you have an empty table, remove it from the db first.
    3.- Go to your wp_options table and search for an option named atum_version
    4.- Change the option_value for that key to 1.4.18.2
    5.- Got to your site’s wp-admin and try again

    I hope this helps.

    Best Regards,
    Salva.

    Thread Starter Berkinka

    (@berkinka)

    Hi!

    When i checked my database, “atum_product_data” was not exist.

    So i just changed the value of the atum_version to 1.4.18.2, went to wp-admin and boom. Everything fixed.

    Thanks for your quick help!

    Berkin

    Plugin Author Salva Machi

    (@salvamb)

    Good to hear!

    Salva

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘wp_atum_product_data Doesnt Exist’ is closed to new replies.