Title: No ATUM database tables
Last modified: July 18, 2018

---

# No ATUM database tables

 *  Resolved [QuokkaCoders](https://wordpress.org/support/users/sync4489/)
 * (@sync4489)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/no-atum-database-tables/)
 * Hi,
 * we have a problem adding products to purchase orders, they are added in the page
   but once it is updated, they are in fact not added.
 * looking at the server logs we found plenty of these errors:
 * AH01071: Got error ‘Table->display_rows,…
    PHP message: WordPress error on database
   Table ‘wp_atum_order_items’ doesn’t exist for query
 * and in fact looking at the database there are no wp_atum tables present…
    The
   plugin has been installed by the wordpress ‘Add plugin’ and gave no errors during
   installation.
 * Maybe it is enough to add the tables by manually running the queries? However
   we could not find the CREATE sql queries in the plugin…
 * Thanks in advance

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [Stock Management Labs](https://wordpress.org/support/users/stockmanagementlabs/)
 * (@stockmanagementlabs)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/no-atum-database-tables/#post-10505119)
 * Hi Sync,
 * Thank you very much for your post.
 * I am sorry you have come across some issues. We have no known ATUM issues of 
   any kind in this version. It seems that this will be your site related.
 * Any chance of sending over your PHP error log? Are all your plugins up to date?
 * Pavel
 *  Thread Starter [QuokkaCoders](https://wordpress.org/support/users/sync4489/)
 * (@sync4489)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/no-atum-database-tables/#post-10505230)
 * Hi,
 * here is an excerpt of the log:
 *     ```
       Jul 17 16:15:18 192.168.130.239 apache2[20249]: [u1614] [xxxxxxxx.onpressidium.com] [xxx.xxx.xxx.xxx] [error] [pid 20249:rid MbRYQNycqa8:tid 139683619112704] mod_proxy_fcgi.c(673): [client xxx.xxx.xxx.xxx:57412] AH01071: Got error 'Table->display_rows,...
       PHP message: WordPress error on database Table 'db_xxxxxxxx.wp_atum_order_items' doesn't exist for query 
   
       SELECT SUM(oim2.<code>meta_value</code>) AS quantity
       FROM <code>wp_atum_order_items</code> AS oi 
       LEFT JOIN <code>wp_atum_order_itemmeta</code> AS oim ON oi.<code>order_item_id</code> = oim.<code>order_item_id</code>
       LEFT JOIN <code>wp_atum_order_itemmeta</code> AS oim2 ON oi.<code>order_item_id</code> = oim2.<code>order_item_id</code>
       LEFT JOIN <code>wp_posts</code> AS p ON oi.<code>order_id</code> = p.<code>ID</code>
       WHERE oim.<code>meta_key</code> IN ('_product_id', '_variation_id') AND <code>order_item_type</code> = 'line_item' 
       AND p.<code>post_type</code> = 'atum_purchase_order' AND oim.<code>meta_value</code> = 76803 AND <code>post_status</code> = 'atum_pending' AND oim2.<code>meta_key</code> = '_qty'
       GROUP BY oim.<code>meta_value</code>; fatta da do_action('wp_ajax_atum_fetch_stock_central_list'), WP_Hook->do_action, WP_Hook->apply_filters, Atum\\Inc\\Ajax->fetch_stock_central_list, Atum\\Components\\AtumListTables\\AtumListTable->ajax_response, WP_List_Table->display_rows_or_placeholder, WP_List_Table->display_rows,...
   
       PHP message: WordPress error on database Table 'db_xxxxxxxxxxxx.wp_atum_order_items' doesn't exist for query 
       SELECT SUM(oim2.<code>meta_value</code>) AS quantity
       FROM <code>wp_atum_order_items</code> AS oi 
       LEFT JOIN <code>wp_atum_order_itemmeta</code> AS oim ON oi.<code>order_item_id</code> = oim.<code>order_item_id</code>
       LEFT JOIN <code>wp_atum_order_itemmeta</code> AS oim2 ON oi.<code>order_item_id</code> = oim2.<code>order_item_id</code>
       LEFT JOIN <code>wp_posts</code> AS p ON oi.<code>order_id</code> = p.<code>ID</code>
       WHERE oim.<code>meta_key</code> IN ('_product_id', '_variation_id') AND <code>order_item_type</code> = 'line_item' 
       AND p.<code>post_type</code> = 'atum_purchase_order' AND oim.<code>meta_value</code> = 77081 AND <code>post_status</code> = 'atum_pending' AND oim2.<code>meta_key</code> = '_qty'\t
       GROUP BY oim.<code>meta_value</code>; fatta da do_action('wp_ajax_atum_fetch_stock_central_list'), WP_Hook->do_action, WP_Hook->apply_filters, Atum\\Inc\\Ajax->fetch_stock_central_list, Atum\\Components\\AtumListTables\\AtumListTable->ajax_response, WP_List_Table->display_rows_or_placeholder, WP_List_Table->display_rows,...
       ```
   
 * we checked the database and the two tables really do not exist…
 * WP: 4.9.7
    WC: 3.2.5 PHP: 7.0.x
 * Thanks in advance
 *  Plugin Author [Stock Management Labs](https://wordpress.org/support/users/stockmanagementlabs/)
 * (@stockmanagementlabs)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/no-atum-database-tables/#post-10505398)
 * Hi S,
 * Thank you very much for this.
 * It seems the tables did not install correctly in your site. Not sure why and 
   what has happened during the installation?
 * Here is a suggestion from my senior dev:
 * “I’d suggest that the user to do this for debugging:
 * 1.- disable ATUM from plugins page
    2.- go to wp_options table and remove the
   atum_version key 3.- empty the PHP error logs 4.- enable ATUM again 5.- check
   the logs (if something failed installing the tables should be there)
 * Also, I’d suggest to upgrade WC to latest version”
 * Hope this helps.
 * Pavel
 *  Thread Starter [QuokkaCoders](https://wordpress.org/support/users/sync4489/)
 * (@sync4489)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/no-atum-database-tables/#post-10505467)
 * Great!
 * doing exactly what you wrote created the two missing MySQL tables.
 * Many many thanks for your quick reply
 * Can’t wait for your premium PO Add-on!
 *  Plugin Author [Stock Management Labs](https://wordpress.org/support/users/stockmanagementlabs/)
 * (@stockmanagementlabs)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/no-atum-database-tables/#post-10505544)
 * Hi S,
 * Glad to hear you fixed the issue.
 * Happy to help anytime.
 * Pavel

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘No ATUM database tables’ is closed to new replies.

 * ![](https://ps.w.org/atum-stock-manager-for-woocommerce/assets/icon.svg?rev=1634692)
 * [ATUM WooCommerce Inventory Management and Stock Tracking](https://wordpress.org/plugins/atum-stock-manager-for-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/atum-stock-manager-for-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/atum-stock-manager-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/atum-stock-manager-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/atum-stock-manager-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/atum-stock-manager-for-woocommerce/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Stock Management Labs](https://wordpress.org/support/users/stockmanagementlabs/)
 * Last activity: [7 years, 10 months ago](https://wordpress.org/support/topic/no-atum-database-tables/#post-10505544)
 * Status: resolved