Error when use option Update ATUM's stock control [Tools]

Mosiah

Hello, I am experiencing this error in my logs when I try to use the option: Update ATUM Stock Control [Update Now!] [Tools]

error.log (PHP)
[Wed Jun 29 14:10:05.976770 2022] [proxy_fcgi:error] [pid 1327797:tid 139728221816576] [client 2800:150:101:1e9a:dcd:158:673b:9cf5:0] AH01071: Got error 'PHP message: Error Table 'otrtest.wp_atum_product_data' doesn't exist de la base de datos de WordPress para la consulta \n\t\t\t\tUPDATE wp_atum_product_data SET atum_controlled = 1\t\t \t\t\n \tWHERE atum_controlled != 1 realizada por do_action('wp_ajax_atum_tool_control_stock'), WP_Hook->do_action, WP_Hook->apply_filters, Atum\Inc\Ajax->change_control_stock, Atum\Inc\Helpers::change_status_metaPHP message: Error Table 'otrtest.wp_atum_product_data' doesn't exist de la base de datos de WordPress para la consulta \n\t\t\t\tINSERT INTO wp_atum_product_data (product_id, atum_controlled) SELECT p.ID, 1\n\t\t\t\tFROM wp_posts p\n\t\t\t\tLEFT JOIN (SELECT * FROM wp_atum_product_data) ada ON p.ID = ada.product_id\n\t\t\t\tWHERE p.post_type IN('product', 'product_variation') AND ada.product_id IS NULL\n\t\t\t realizada por do_action('wp_ajax_atum_tool_control_stock'), WP_Hook->do_action, WP_Hook->apply_filters, Atum\Inc\Ajax->change_control_stock, Atum\Inc\Helpers::change_status_meta', referer: https://test.otrservices.cl/wp-admin/admin.php?page=atum-settings&tab=advanced

Any suggestion?
I tried to reinstall the plugin, but everything is still the same.

Thanks.

Salva

Hi Mosiah

By reading that error, it seems there is an ATUM table that doesn't exist in your database. Please, do check whether the wp_atum_product_data was created there or not.

If it isn't there, something wrong happened when you installed ATUM. This can happen if the database user you have configured in your wp-config.php hasn't full privileges and cannot create tables (for example).

After checking (and fixing if needed) the db user privileges, you can check the "delete ATUM data when uninstalling" option from ATUM settings then save and go to the plugins page and uninstall ATUM from there.
Thereafter, try to reinstall ATUM and check if the table was correctly created this time. And, if not, you'll probably have a new error saying what happened.

I hope this helps.

Best Regards,
Salva.