wp_woocommerce_order_items missing, had to close the shop.

Hi,

I’ve used WooCommerce for the last two years. It’s basically been unattended and has been working great.

A customer tried to purchase but got an error at PayPal saying the cart was empty. The customer sent me the funds manually instead and I gave him a 100% price reduction coupon. He spent the coupon but still couldn’t make a purchase. He got his receipt email, I got the “new purchase” emails but there are no products in his order.

If I open the order as admin, it’s empty. It shows the total amount, but no items. If I force it to “complete” the customer still can’t download the product because it says there are no items in the order.

I placed an order myself and sure enough, there are no items in the order even though I added them to the cart.

I went into my Apache logs and there it says the following:

[Tue Nov 19 12:01:18 2013] [error] [client 80.211.101.41] WordPress database error Table ‘gameinprogress.wp_woocommerce_order_items’ doesn’t exist for query INSERT INTO wp_woocommerce_order_items (order_item_name,order_item_type,order_id) VALUES (‘Test Product’,’line_item’,340) made by do_action(‘wp_ajax_woocommerce-checkout’), call_user_func_array, woocommerce_process_checkout, WC_Checkout->process_checkout, WC_Checkout->create_order, woocommerce_add_order_item, referer: http://www.gameinprogress.com/?page_id=162

I’ve tried the following:

* Made sure sessions are working.
* Disabled the APC cache.
* Updated the current theme (which is Wootique).
* Changed to two other themes.
* Updated WooCommerce
* Reactivated WooCommerce
* Made sure the WordPress URL’s match in Settings

The wp_woocommerce_order_items entry exists on older orders that went trough successfully, but isn’t created on new orders.

I’m so desperate. What on earth could be wrong?