Solving a data corruption issue

  • Resolved twowheeler

    (@twowheeler)


    4 months, 1 week ago

    First, thank you for the awesome plugin! I love the way it looks.

    Second, about my issue. I have Woocommerce Subscriptions 6.5.0, and Donation Platform 1.3.2. Recurring donations have been working fine until recently. We hit an error on the server [skipping long unrelated story], and the result was that MariaDB queries started to hang and user sessions were timing out. One of the recurring donation orders was apparently corrupted in the process, and now an error pops up on the backend like “An error has occurred while processing a recent subscription related event. For steps on how to fix the affected subscription and to learn more about the possible causes of this error, please read our guide here.
    Affected event: subscription payment for #165865″ BTW I did read the guide but it doesn’t really address this issue.

    The order exists but contains no information except the email address – no items, no amounts, no purchaser detail, etc. It is stuck in “Pending payment” status. No payment transaction was created. I can’t resubmit this order because it contains no data. What would you recommend? Can I delete this order and restart the subscription process? Even though it is now a few days late, I’d like to capture the donation this user intended to give this month.

    Any help is appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Jonas

    (@flinnn)

    Hi twowheeler,

    First of all, thank you for your kind words about my plugin! I’m glad to hear that you love the way it looks.

    Regarding the issue you’re experiencing with the corrupted recurring donation order, I recommend the following steps to resolve the problem:

    1. Consult WooCommerce Subscriptions Support: Given that this issue involves subscription events and order processing, the WooCommerce Subscriptions support team might be in a better position to help you with this specific problem. They have more detailed knowledge of subscription handling and may offer a more targeted solution.
    2. Check Server Logs: Before deleting the order, you might want to check your server logs to identify the request with the corresponding data. This could help you recover some of the lost information related to the corrupted order.
    3. Delete the Corrupted Order: Since the order contains no data and cannot be resubmitted, it would be best to delete this corrupted order from your system. This will help avoid any further issues or confusion.
    4. Reach Out to the Customer: After deleting the order, please contact the affected customer directly via email. Explain the issue that occurred with their recent donation, and kindly request them to make the donation again. To make up for the inconvenience, you might consider offering a small compensation or a gift as a gesture of goodwill.

    I hope this helps! If you have any further questions or need additional assistance, feel free to reach out.

    Best regards,
    Jonas

    Thread Starter twowheeler

    (@twowheeler)

    Good advice. Thank you.

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