Uncaught Database Exception Error

I have the same error. I see the exception, and at the bottom of the issue, it reads: “Out of sort memory, consider increasing server sort buffer size” I was able to make a donation today without an issue. What is the problem with error, and how can it be resolved? Could it have been a block initiated on his side? I see that the donor’s email address is @dol.gov

{
    "Query": "SELECT id, user_id AS userId, email, name, purchase_value AS totalAmountDonated, purchase_count AS totalDonations, payment_ids AS paymentIds, date_created AS createdAt, token, verify_key AS verifyKey, verify_throttle AS verifyThrottle, give_donormeta_attach_meta_0.meta_value AS firstName, give_donormeta_attach_meta_1.meta_value AS lastName, CONCAT('[',GROUP_CONCAT(DISTINCT CONCAT('\"',give_donormeta_attach_meta_2.meta_value,'\"')),']') AS additionalEmails, give_donormeta_attach_meta_3.meta_value AS prefix FROM _JXW_give_donors LEFT JOIN _JXW_give_donormeta give_donormeta_attach_meta_0 ON ID = give_donormeta_attach_meta_0.donor_id AND give_donormeta_attach_meta_0.meta_key = '_give_donor_first_name' LEFT JOIN _JXW_give_donormeta give_donormeta_attach_meta_1 ON ID = give_donormeta_attach_meta_1.donor_id AND give_donormeta_attach_meta_1.meta_key = '_give_donor_last_name' LEFT JOIN _JXW_give_donormeta give_donormeta_attach_meta_2 ON ID = give_donormeta_attach_meta_2.donor_id AND give_donormeta_attach_meta_2.meta_key = 'additional_email' LEFT JOIN _JXW_give_donormeta give_donormeta_attach_meta_3 ON ID = give_donormeta_attach_meta_3.donor_id AND give_donormeta_attach_meta_3.meta_key = '_give_donor_title_prefix' WHERE email = '[email protected]' GROUP BY ID,firstName,lastName,prefix",
    "Query Errors": {
        "db_delta_error": [
            "Out of sort memory, consider increasing server sort buffer size"
        ]
    }
}

Thank you for any guidance you can provide, GIVEWP

Decli

Hi folks,

The latest version of GiveWP fixed this issue for other users. Are you still experiencing this issue with GiveWP 2.21.1?

Is there a way to access the customer information, such as name and email address, for customers who encountered this error. I received payment, but have no way of knowing who paid. These transactions do not show up in the donor list.

I am using 2.2.1, but not sure if it was updated before or after the issue. I will monitor for future glitches.

@aacafga Got to tools >> logs >> and look for the “error”. Our donor attempted to give twice. The first error showed his email address at the bottom of the error text, the second error did not. However BOTH attempts were successful and were charged to PayPal. He fortunately contacted us to let us know about the issue.

…
give_donormeta_attach_meta_3 ON ID = give_donormeta_attach_meta_3.donor_id AND give_donormeta_attach_meta_3.meta_key = ‘_give_donor_title_prefix’ WHERE email = ‘[email protected]‘ GROUP BY ID,firstName,lastName,prefix”,
“Query Errors”: {
“db_delta_error”: [
“Out of sort memory, consider increasing …

@decli Thanks for sharing. Unfortunately the email address does not appear anywhere in the error log. I am hoping the information can be retrieved elsewhere, such as a confirmation email (if stored and retrievable) that might have been sent by WP. The payments were successful, but have no clue at this point who gave money!

@aacafga

Confirmation emails are not stored. They’re generated on the fly when a donation is marked as Complete.

At this point, Paypal is your best bet to get the donor’s info.
The donor’s name and email is part of the information that is sent to all payment gateways as part of the payment data.