ATUM table doesn't exist

cebr1994

Hello. I am using Wordpress locally with localwp to create a website with Woocommerce.

I downloaded the ATUM Inventory plugin, but none of my products appear in Stock Central. I have researched on this forum and followed the steps to get the Wordpress debug log, which indicates that the 'local.wp_atum_product_data' table does not exist.

I deleted the plugin by activating the option to delete the data and downloaded it again, the error continues. For some reason, the ATUM table is not created.

I attach the log here:

[23-Apr-2023 17:54:10 UTC] WordPress database error Table 'local.wp_atum_product_data' doesn't exist for query SELECT DISTINCT posts.ID
FROM wp_posts posts
LEFT JOIN wp_atum_product_data AS apd ON (posts.ID = apd.product_id)
LEFT JOIN wp_wc_product_meta_lookup AS pml ON (posts.ID = pml.product_id)
WHERE posts.post_type IN ('product','product_variation')
AND posts.post_status IN ('publish','private','future')
AND apd.inheritable != 1
AND pml.stock_quantity IS NULL made by do_action('toplevel_page_atum-dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, Atum\Dashboard\Dashboard->display, Atum\Inc\Helpers::load_view, include('/plugins/atum-stock-manager-for-woocommerce/views/dashboard.php'), Atum\Dashboard\Dashboard->add_widget, Atum\Inc\Helpers::load_view, include('/plugins/atum-stock-manager-for-woocommerce/views/widgets/widget-wrapper.php'), Atum\Dashboard\Widgets\StockControl->render, Atum\Dashboard\WidgetHelpers::get_stock_levels, Atum\Inc\Helpers::get_unmanaged_products

Salva

Hi cebr1994

Yes, it seems for some reason, the ATUM table was not created.
Please, try this:

Make sure the user you have configured on your wp-config.php has full privileges to create and alter db tables.
Go to ATUM settings >> Advanced and check the "Delete data when uninstalling" option and save.
Go to the plugins page and disable + uninstall ATUM
Go to the "Add new" on the plugins page, search for ATUM and install it back

And let me know whether it worked, please.

Best Regards,
Salva.

cebr1994

Hello Salva Thank you for answering. I checked and the user has full privileges. I checked "Delete data when uninstalling" option and saved. I disabled + uninstalled + reinstalled ATUM many times. It didn't work. I tried by creating the Atum table manually, but it is dropped each time I install the plugin.

Salva

Hi cebr1994

Might you check your PHP error log, please?
Perhaps you have some errors there that can give us a clue about what's causing this.
Not the error you posted about the table that doesn't exist, but any error that throws when ATUM tries to run the "CREATE TABLE" SQL query.

If you need to know how to enable and get this log, please read this article:

https://wordpress.org/documentation/article/debugging-in-wordpress/

Best Regards,
Salva.

cebr1994

Salva Should I copypaste the full log here? It is quite long. I copypasted just the first part of the error log here n my first post.

Salva

Hi cebr1994

Please, open a private ticket and attach the file there.

Best Regards,
Salva.