Latest Update Broke Payment Processing

  • Resolved andy_brazil

    (@andy_brazil)


    5 years ago

    The latest update to the plugin broke it with the latest version of woocommerce 3.9.2.

    Rolling back the square plugin from 2.1 to 2.0 fixed this issue for us.

    We found a logged error relating to this.

    [03-Mar-2020 13:01:42 UTC] WordPress database error Table ‘padr_bc.wp_woocommerce_square_customers’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_woocommerce_square_customers made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::do_wc_ajax, do_action(‘wc_ajax_checkout’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::checkout, WC_Checkout->process_checkout, WC_Checkout->process_order_payment, SkyVerge\WooCommerce\PluginFramework\v5_4_0\SV_WC_Payment_Gateway_Direct->process_payment, WooCommerce\Square\Gateway->get_order, WooCommerce\Square\Gateway\Customer_Helper::add_customer

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support AW a11n

    (@slash1andy)

    Automattic Happiness Engineer

    Hey there!

    That error message essentially means that the plugin can’t create a table for Square customer like it needs to (typically this is a an issue with permissions or similar).

    If you or your host can create that table manually, the plugin should work as normal again.

    Hopefully that helps! Have a great one!

    Thread Starter andy_brazil

    (@andy_brazil)

    Hi Andrew,

    How do I know which columns to include in the manual creation of the table?

    I looked at other sites utilizing woocommerce and square and they do not have this customer table in the database…

    Plugin Support AW a11n

    (@slash1andy)

    Automattic Happiness Engineer

    Hey there again!

    So sorry about the delay here @andy_brazil .

    The table is created (or needs to be) when tokenization (allow customers to save cards) is enabled.

    The table structure is here: https://d.pr/i/ZX9BBB

    Hopefully that helps! Have a great one!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Latest Update Broke Payment Processing’ is closed to new replies.