chodos

Thank you @johnpaulbyrne
It worked for me too!

I solved the problem based on the solution of topic #11172400.

After disabling all the plugins, keeping only the WooCommerce and the default theme of WordPress, the problem persisted, which indicated my idea of something wrong in the database.

Some update, I do not know if WordPress or WooCommerce, should change the length of the column “post_password” in “wp_posts” from varchar(20) to varchar(255), but this did not happen on my installation, either on the local server or on the production server. In other installations this change occurred normally, but in this installation not.

Based on topic #11172400, I changed the length of the column, in my case I need to change to 191, I could not change to 255 because the collation used is utf8mb4, to collation utf8 should work 255.

After the change I was able to complete the orders without errors, with tests done in the local server and in the online server.

I hope this helps in some way.

Yes, first I deactivated all the plugins, leaving only WooCommerce and the ‘Twenty Nineteen’ theme active. Now I have removed all the plugins and themes, keeping only WooCommerce and the ‘Twenty Nineteen’ and the problem remains.

I noticed that upon completing the checkout, entries in the wp_woocommerce_order_items table with order_id 0 are created. I think this can be a problem in generating the ID, in the save() function in woocommerce/includes/class-wc-order.php.

I do not know why, if there could be some conflict in the database, but it was as far as I could get.

Apparently in Woo 3.6.4 it’s trying to test if order exist and shows the error. On 3.2.6 this test not exist.

This is the only code included in this snippet of version 3.6.4, but I can not understand why.

Hi, thank you for your attention.

Ok, “Can not create order” it’s a direct translation from portuguese. Now I changed the WP’s language to english and the theme for ‘Twenty Nineteen’.

With Woo 3.2.6 everything works, with 3.6.4 the error message is “Unable to create order.”. I found it on woocommerce/includes/class-wc-checkout.php line 1117.

The problem started after update to WooCommerce 3.4.4

Okay, I’ll do it. Thanks!

Thanks @vankaa, but it does not solve. This filter only changes what is displayed, the ID remains the same. I would like to change the ID in the database to find the order again with the ID that I receive through the API.
But I do not think it’s possible, I’ll use metadata.