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
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
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
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!
Hi S,
Glad to hear you fixed the issue.
Happy to help anytime.
Pavel
