Support » Plugin: Wirecard WooCommerce Extension » WP Multisite: wrong behavior on get saved transactions

  • We use Wirecard WooCommerce Extension plugin in multisite mode.

    I see after each purchase such errors (looks like you try to search in false table):

    WordPress-Datenbank-Fehler Table 'db.111_wirecard_payment_gateway_tx' doesn't exist für Abfrage SELECT * FROM 123_wirecard_payment_gateway_tx WHERE transaction_id = '3999a80a-...-7e888d23d594' von require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, WC_API->handle_api_requests, do_action('woocommerce_api_wc_wirecard_payment_gateway_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Wirecard_Payment_Gateway->return_request, WC_Wirecard_Payment_Gateway->update_payment_transaction, Wirecard_Transaction_Factory->create_transaction, Wirecard_Transaction_Factory->get_transaction

    And after it (looks like you try to insert this transactions but already in right table):

    WordPress-Datenbank-Fehler Duplicate entry '3999a80a-...-7e888d23d594' for key 'transaction_id' für Abfrage INSERT INTO wirecard_payment_gateway_tx (transaction_id, parent_transaction_id, payment_method, transaction_state, transaction_type, amount, currency, order_id, response, transaction_link) VALUES (...) von require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, WC_API->handle_api_requests, do_action('woocommerce_api_wc_wirecard_payment_gateway_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Wirecard_Payment_Gateway->return_request, WC_Wirecard_Payment_Gateway->update_payment_transaction, Wirecard_Transaction_Factory->create_transaction

    It happens because the plugin has only one own table for saving transactions: wirecard_payment_gateway_tx, but you try to get transactions in subblogs content without callint this functions: switch_to_blog(get_network()->site_id); and after restore_current_blog();.

    • This topic was modified 1 month, 1 week ago by krut1.
    • This topic was modified 1 month, 1 week ago by krut1.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Hi Krut1,

    at the moment our shop extension does not support multisite setups. But I want to thank you for you suggestion which function we should use for the correct workflow. I have forwarded it to our dev department so they can have a look at it as soon as they make our extension suitable for multisite.

    Best regards,
    Wirecard Support Team

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.