Inability to edit my orders!

Same issue. Also using HPOS. Confirmed that switching back to using wp_posts resolves it.

Hello @dimitrisv and @koppit

Thank you for reaching out to us. We have already a bug open for this situation and have asked our developers to look into this with urgency. You can indeed switch back to avoid this situation. We will try to get a package available for version 2.2.1, so that you can have the updated version working with HPOS while you can still edit your orders.

Sorry for the inconvenience, we will try to come back to you as soon as we have any other options available for you.

Kind regards,
Joost

Additionally: more information can be found here on GitHub: https://github.com/woocommerce/woocommerce-paypal-payments/issues/1628

Thank you Joost. In my case I switched back to 2.2.0. (going back to non-HPOS will add about 2million records in my postmeta and I am happy with the speed we enjoy due to HPOS).

Please be so kind to post in this thread as soon as you release with the fix.

Hello,

We just got a fix for this issue from our developers and created a package for you that you can download here:
https://drive.google.com/uc?export=download&id=16GC-69a1JmA65HH0GIj4xOAQNL313hDP

We think we will try to release this as soon as possible as version 2.2.2, but we are still discussion this. For now, you should be able to use this package as a temporary fix until we do a next release.

Kind regards,
Joost

You are unbelievable!

Just installed it, it is looking good! ??

Thank you so much!

Hello @dimitrisv

That is great to hear! We are working on setting up a quick release for 2.2.2, but we are not sure about when that will happen. I will mark this thread as resolved, since we seem to understand what is causing it and how to fix it.

Thanks again for confirming the fix.

Kind regards,
Joost

I am affraid the issue was not solved completely.

[Thu Aug 31 15:15:41.170453 2023] [proxy_fcgi:error] [pid 18742:tid 140601475438336] [client 157.55.39.215:0] AH01071: Got error ‘PHP message: PHP Warning: ?Undefined property: wpdb::$wc_orders in public_html/wp-includes/class-wpdb.php on line 789PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘WHERE payment_method = ‘ppec_paypal” at line 1 for query SELECT 1 FROM ?WHERE payment_method = ‘ppec_paypal’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, WooCommerce\\PayPalCommerce\\{closure}, WooCommerce\\PayPalCommerce\\init, {closure}, WooCommerce\\PayPalCommerce\\Compat\\CompatModule->run, WooCommerce\\PayPalCommerce\\Compat\\CompatModule->initialize_ppec_compat_layer, WooCommerce\\PayPalCommerce\\Compat\\PPEC\\SubscriptionsHandler->maybe_hook, WooCommerce\\PayPalCommerce\\Compat\\PPEC\\PPECHelper::use_ppec_compat_layer_for_subscriptions, WooCommerce\\PayPalCommerce\\Compat\\PPEC\\PPECHelper::site_has_ppec_subscriptions’

Hello @dimitrisv

Sorry to hear that your site is still not behaving as you intended. I have forwarded the error to our team and asked them to investigate it further. I might come back later to request more details from you, since we have not received any other complaints about the fix so far.

Kind regards,
Joost

Hello @dimitrisv

My team responded: Most likely this message is unrelated to the HPOS issue we resolved earlier. This is only a warning and shouldn’t cause any problems, but will investigate a bit deeper.

When I get any other response, I will let you know.

Kind regards,
Joost

Hello @dimitrisv

Our team has responded to me that this error is unrelated, so they have opened a new bug to look into this further. Hopefully I will have more details about this for you soon.

Kind regards,
Joost

Hola. ?Se pudo solucionar el problema que comentaba Dimitri? Acabo de pasar a HPOS y me salta el mismo warning:

Undefined property: wpdb::$wc_orders in /public_html/wp-includes/class-wpdb.php on line 783

Gracias.

Hello @samuelibon

yes, that error is related to the issue that still remains. We have an open bug for this, and I will ask for the team to review and see what they can do for this. This is the only thread we have open at the moment reporting about this case, so it is not a very common issue. I will try to prioritize, but because of the scarce amount of reports, the priority might also be low.

Kind regards,
Joost

Muchas gracias por tu respuesta, Joost.

Se me olvidó comentar que justamente he actualizado a php8.1.

Gracias y quedo a la espera de que llegue la solución.

Saludos.