Your plugin lock my database

  • Resolved samisraeli

    (@samisraeli)


    2 years ago

    Hi,
    Your plugin version 1.9.4 lock my database
    function site_has_ppec_subscriptions
    SELECT 1 FROM {$wpdb->posts} p JOIN {$wpdb->postmeta} pm ON pm.post_id = p.ID
    WHERE p.post_type = %s AND p.post_status != %s AND pm.meta_key = %s AND pm.meta_value = %s LIMIT 1″,
    ‘shop_subscription’,
    ‘trash’,
    ‘_payment_method’,
    self::PPEC_GATEWAY_ID
    )
    );

    return ! empty( $result );
    }`

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Syde Joost

    (@joostvandevijver)

    Hello @samisraeli

    Thank you for reaching out to us, we are here to help.

    Can you please explain to us what you are experiencing? The function you are showing here is actually related to PayPal Checkout Express (PPEC), not our PayPal Payments (PPCP) plugin.

    Kind regards,
    Joost

    Thread Starter samisraeli

    (@samisraeli)

    The code appears in your plugin:
    \woocommerce-paypal-payments\modules\ppcp-compat\src\PPEC\PPECHelper.php Line 74
    Since we replaces the plugin:
    WooCommerce PayPal Checkout Gatway with your plugin we have many locks in our database.

    Sam

    Plugin Support Syde Joost

    (@joostvandevijver)

    Hello @samisraeli

    Sorry for the delay. I discussed this and understand now what we are talking about here.

    This function checks old subscriptions and converts them so that our plugin can continue charging them. Can you tell us what the issue is that this function/situation is causing you?

    There are talks to include an option to exclude this function, but nothing concrete at this moment.
    You could also comment out the code that is shown in yellow here: https://github.com/woocommerce/woocommerce-paypal-payments/blob/4c91e7afbb8dd008a037e03d4ddf70d635252f83/modules/ppcp-compat/src/PPEC/PPECHelper.php#L70-L83

    Pending your response.

    Kind regards,
    Joost

    Plugin Support Syde Niklas

    (@niklasinpsyde)

    Hi @samisraeli,

    There is also a filter that can be used to disable the migration layer:

    add_filter('woocommerce_paypal_payments_process_legacy_subscriptions', static function(){
return false;
});

    If you have any doubts or further questions, please do not hesitate to let us know.
    Thanks!

    Kind regards,
    Niklas

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Your plugin lock my database’ is closed to new replies.

Tags