Error Message after successful payment

Hi There,

No reply in almost 4 weeks….

Here is some more information, the errors seem to trigger a series of events (below info is from email logs).

Order #54327 has been cancelled
Order #54328 has been received
New Order #54329

Your Order #54518 has been received
Order #54516 has been cancelled
New Order #54517

I’ve been through various logs and can’t find a definitive reason for the ongoing issues.

I’m starting to lean towards a timeout issue. There was a long delay after the OTP/bank app authorisation step. The browser (Chrome v88) was waiting for online.yoco before ventually displaying up the “There was a network error while preparing your payment. Please retry.” message.

When clicking on “retry”. I was shown the “This order’s status is “Processing”—it cannot be paid for. Please contact us if you need assistance.” message. There did not appear to be an actual retry of the payment process. The Cart was cleared of contents.

Hi there

Thank you for using Yoco payments.

We’re really sorry to hear you are facing this issue.
We apologize for not getting back to you sooner. We always strive to respond in a timely manner, and we are sorry this slipped through the cracks.

Our team has been investigating the cause of errors like this and suspect it is related to fatal errors which occur within WordPress during the $order->payment_complete() call and subsequent hooks. An example of this is when the server runs out of memory.

We have been implementing recovery mechanisms that we hope will allow the plugin to recover from server errors. The features will be available in a future release.

If your website is still affected, we are happy to make the beta version of the plugin available to you ahead of time.

Thank you for your patience, and please keep us posted on how you get on.

Hi Guys,

We’ve had a few recent issues occur.
Looking through the error logs, I noticed the following.

Got error 'ay_rows, WP_Posts_List_Table->_display_rows, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_shop_order_posts_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, class_yoco_wc_error->add_order_error_column_contentPHP 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 ''wp_yoco_order_errors' WHERE order_id = 55319 ORDER BY id DESC LIMIT 1' at line 1 for query SELECT error_code, error_msg FROM 'wp_yoco_order_errors' WHERE order_id = 55319 ORDER BY id DESC LIMIT 1 made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_shop_order_posts_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, class_yoco_wc_error->add_order_error_column_contentPHP 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 ''wp_yoco_order_errors' WHERE order_id = 55313 ORDER BY id DESC LIMIT 1' at line 1 for query SELECT error_code, error_msg FROM 'wp_yoco_order_errors' WHERE order_id = 55313 ORDER BY id DESC LIMIT 1 made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_shop_order_posts_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, class_yoco_wc_error->add_order_error_column_contentPHP 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 ''wp_yoco_order_errors' WHERE order_id = 55307 ORDER BY id DESC LIMIT 1' at line 1 for query SELECT error_code, error_msg FROM 'wp_yoco_order_errors' WHERE order_id = 55307 ORDER BY id DESC LIMIT 1 made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_shop_order_posts_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, class_yoco_wc_error->add_order_error_column_contentPHP 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 ''wp_yoco_order_errors' WHERE order_id = 55306 ORDER BY id DESC LIMIT 1' at line 1 for query SELECT error_code, error_msg FROM 'wp_yoco_order_errors' WHERE order_id = 55306 ORDER BY id DESC LIMIT 1 made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_shop_order_posts_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, class_yoco_wc_error->add_order_error_column_contentPHP 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 ''wp_yoco_order_errors' WHERE order_id = 55305 ORDER BY id DESC LIMIT 1' at line 1 for query SELECT error_code, error_msg FROM 'wp_yoco_order_errors' WHERE order_id = 55305 ORDER BY id DESC LIMIT 1 made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_shop_order_posts_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, class_yoco_wc_error->add_order_error_column_contentPHP 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 ''wp_yoco_order_errors' WHERE order_id = 55304 ORDER BY id DESC LIMIT 1' at line 1 for query SELECT error_code, error_msg FROM 'wp_yoco_order_errors' WHERE order_id = 55304 ORDER BY id DESC LIMIT 1 made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_shop_order_posts_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, class_yoco_wc_error->add_order_error_column_contentPHP 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 ''wp_yoco_order_errors' WHERE order_id = 55301 ORDER BY id DESC LIMIT 1' at line 1 for query SELECT error_code, error_msg FROM 'wp_yoco_order_errors' WHERE order_id = 55301 ORDER BY id DESC LIMIT 1 made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_shop_order_posts_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, class_yoco_wc_error->add_order_error_column_contentPHP 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 ''wp_yoco_order_errors' WHERE order_id = 55294 ORDER BY id DESC LIMIT 1' at line 1 for query SELECT error_code, error_msg FROM 'wp_yoco_order_errors' WHERE order_id = 55294 ORDER BY id DESC LIMIT 1 made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_shop_order_posts_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, class_yoco_wc_error->add_order_error_column_contentPHP 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 ''wp_yoco_order_errors' WHERE order_id = 55293 ORDER BY id DESC LIMIT 1' at line 1 for query SELECT error_code, error_msg FROM 'wp_yoco_order_errors' WHERE order_id = 55293 ORDER BY id DESC LIMIT 1 made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action('manage_shop_order_posts_custom_column'), WP_Hook->do_action, WP_Hook->apply_filters, class_yoco_wc_error->add_order_error_column_content'

Thank you for bringing this to our attention.

We can confirm this issue is occurring on specific installations. It is an error display helper that is failing, but is not something that will affect the checkout process for your customers or your backend order management.

We have since worked on a fix that will be available in the next release.

Let us know if we can help with anything else.

Hi there,

We published a release that solves the issue you were facing.
Thank you for reporting, and let us know if you have any other questions.