21
Unable to view Donations and Donors list in the backend
under review
Rick Alday
A handful of users have reported that the Donations and Donors list in the backed do not load or load an error message.
Our team has not been able to replicate this issue but we're still investigating. This issue does not affect the donation process in the frontend.
Ben Meredith
Update here: We're not sure the underlying cause for the timeouts (and are working under the assumption it's a combination of an over-taxed server with too many donations/donors/forms to query) and are going to dedicate some time over the next weeks to look into that.
In the meantime, we've created a snippet for switching the new list views to the legacy views for all administrators in a site. To use it, do the following:
- Add the snippet (linked below) to functions.php or some other place that runs arbitrary PHP. You can use the Code Snippets plugin too.
- Go to /wp-admin/index.php?givewp_set_legacy_lists=1 — be sure to add your own domain name at the beginning
- It will redirect you back to the same page, and now the lists should be legacy.
Here's the link to the snippet: https://gist.github.com/rickalday/ffb27e660cd4b1c7b1d9cf92ef696264
Stay tuned here for a potential fix for the larger issue, but we're short-staffed currently (and hiring!) on the development team for this issue.
Activity Feed
Sort by
J
Jonathon Aulette
{
"Query": "SELECT ID AS id, post_date AS createdAt, post_modified AS updatedAt, post_status AS status, post_parent AS parentId, give_donationmeta_attach_meta_0.meta_value AS amount, give_donationmeta_attach_meta_1.meta_value AS baseAmount, give_donationmeta_attach_meta_2.meta_value AS currency, give_donationmeta_attach_meta_3.meta_value AS exchangeRate, give_donationmeta_attach_meta_4.meta_value AS feeAmountRecovered, give_donationmeta_attach_meta_5.meta_value AS gateway, give_donationmeta_attach_meta_6.meta_value AS donorId, give_donationmeta_attach_meta_7.meta_value AS firstName, give_donationmeta_attach_meta_8.meta_value AS lastName, give_donationmeta_attach_meta_9.meta_value AS email, give_donationmeta_attach_meta_10.meta_value AS subscriptionId, give_donationmeta_attach_meta_11.meta_value AS mode, give_donationmeta_attach_meta_12.meta_value AS formId, give_donationmeta_attach_meta_13.meta_value AS formTitle, give_donationmeta_attach_meta_14.meta_value AS billingCountry, give_donationmeta_attach_meta_15.meta_value AS billingAddress2, give_donationmeta_attach_meta_16.meta_value AS billingCity, give_donationmeta_attach_meta_17.meta_value AS billingAddress1, give_donationmeta_attach_meta_18.meta_value AS billingState, give_donationmeta_attach_meta_19.meta_value AS billingZip, give_donationmeta_attach_meta_20.meta_value AS purchaseKey, give_donationmeta_attach_meta_21.meta_value AS donorIp, give_donationmeta_attach_meta_22.meta_value AS anonymous, give_donationmeta_attach_meta_23.meta_value AS levelId, give_donationmeta_attach_meta_24.meta_value AS company, give_donationmeta_attach_meta_25.meta_value AS gatewayTransactionId, give_donationmeta_attach_meta_26.meta_value AS subscriptionInitialDonation, give_donationmeta_attach_meta_27.meta_value AS isRecurring FROM wpfq_posts LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_0 ON ID = give_donationmeta_attach_meta_0.donation_id AND give_donationmeta_attach_meta_0.meta_key = '_give_payment_total' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_1 ON ID = give_donationmeta_attach_meta_1.donation_id AND give_donationmeta_attach_meta_1.meta_key = '_give_cs_base_amount' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_2 ON ID = give_donationmeta_attach_meta_2.donation_id AND give_donationmeta_attach_meta_2.meta_key = '_give_payment_currency' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_3 ON ID = give_donationmeta_attach_meta_3.donation_id AND give_donationmeta_attach_meta_3.meta_key = '_give_cs_exchange_rate' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_4 ON ID = give_donationmeta_attach_meta_4.donation_id AND give_donationmeta_attach_meta_4.meta_key = '_give_fee_amount' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_5 ON ID = give_donationmeta_attach_meta_5.donation_id AND give_donationmeta_attach_meta_5.meta_key = '_give_payment_gateway' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_6 ON ID = give_donationmeta_attach_meta_6.donation_id AND give_donationmeta_attach_meta_6.meta_key = '_give_payment_donor_id' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_7 ON ID = give_donationmeta_attach_meta_7.donation_id AND give_donationmeta_attach_meta_7.meta_key = '_give_donor_billing_first_name' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_8 ON ID = give_donationmeta_attach_meta_8.donation_id AND give_donationmeta_attach_meta_8.meta_key = '_give_donor_billing_last_name' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_9 ON ID = give_donationmeta_attach_meta_9.donation_id AND give_donationmeta_attach_meta_9.meta_key = '_give_payment_donor_email' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_10 ON ID = give_donationmeta_attach_meta_10.donation_id AND give_donationmeta_attach_meta_10.meta_key = 'subscription_id' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_11 ON ID = give_donationmeta_attach_meta_11.donation_id AND give_donationmeta_attach_meta_11.meta_key = '_give_payment_mode' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_12 ON ID = give_donationmeta_attach_meta_12.donation_id AND give_donationmeta_attach_meta_12.meta_key = '_give_payment_form_id' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_13 ON ID = give_donationmeta_attach_meta_13.donation_id AND give_donationmeta_attach_meta_13.meta_key = '_give_payment_form_title' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_14 ON ID = give_donationmeta_attach_meta_14.donation_id AND give_donationmeta_attach_meta_14.meta_key = '_give_donor_billing_country' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_15 ON ID = give_donationmeta_attach_meta_15.donation_id AND give_donationmeta_attach_meta_15.meta_key = '_give_donor_billing_address2' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_16 ON ID = give_donationmeta_attach_meta_16.donation_id AND give_donationmeta_attach_meta_16.meta_key = '_give_donor_billing_city' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_17 ON ID = give_donationmeta_attach_meta_17.donation_id AND give_donationmeta_attach_meta_17.meta_key = '_give_donor_billing_address1' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_18 ON ID = give_donationmeta_attach_meta_18.donation_id AND give_donationmeta_attach_meta_18.meta_key = '_give_donor_billing_state' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_19 ON ID = give_donationmeta_attach_meta_19.donation_id AND give_donationmeta_attach_meta_19.meta_key = '_give_donor_billing_zip' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_20 ON ID = give_donationmeta_attach_meta_20.donation_id AND give_donationmeta_attach_meta_20.meta_key = '_give_payment_purchase_key' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_21 ON ID = give_donationmeta_attach_meta_21.donation_id AND give_donationmeta_attach_meta_21.meta_key = '_give_payment_donor_ip' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_22 ON ID = give_donationmeta_attach_meta_22.donation_id AND give_donationmeta_attach_meta_22.meta_key = '_give_anonymous_donation' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_23 ON ID = give_donationmeta_attach_meta_23.donation_id AND give_donationmeta_attach_meta_23.meta_key = '_give_payment_price_id' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_24 ON ID = give_donationmeta_attach_meta_24.donation_id AND give_donationmeta_attach_meta_24.meta_key = '_give_donation_company' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_25 ON ID = give_donationmeta_attach_meta_25.donation_id AND give_donationmeta_attach_meta_25.meta_key = '_give_payment_transaction_id' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_26 ON ID = give_donationmeta_attach_meta_26.donation_id AND give_donationmeta_attach_meta_26.meta_key = '_give_subscription_payment' LEFT JOIN wpfq_give_donationmeta give_donationmeta_attach_meta_27 ON ID = give_donationmeta_attach_meta_27.donation_id AND give_donationmeta_attach_meta_27.meta_key = '_give_is_donation_recurring' WHERE post_type = 'give_payment' ORDER BY post_date DESC LIMIT 1",
"Query Errors": {
"db_delta_error": [
"The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay"
]
}
}
laith Aljazaeri
The legacy pages work fine, it's only the "new" versions that have a timeout issue.
Ben Meredith
under review
Getting reports that the fix in 2.21.1 did not resolve this. We are still unable to replicate the problem, and keen to have a spot to do so. The workaround in the pinned comment is still working for folks.
Ben Meredith
complete
Ben Meredith
Update here: In 2.21.1 we optimized a query that was failing on older versions of MySQL, and believe that it likely fixes this issue as well. Since we were never able to replicate this one, it's hard to confirm. Update to 2.21.1 and let us know if you are still experiencing the issue!
Zakir Faizal
If I may, I found that I had to update my finance team's account from "Give Accountant" to "Give Manager" in order for the account to be able to view the Donation Forms List, Donor List, and Donations List. Unsure why, but this issue started only around the first couple of weeks in May.
Ben Meredith
Update here: We're not sure the underlying cause for the timeouts (and are working under the assumption it's a combination of an over-taxed server with too many donations/donors/forms to query) and are going to dedicate some time over the next weeks to look into that.
In the meantime, we've created a snippet for switching the new list views to the legacy views for all administrators in a site. To use it, do the following:
- Add the snippet (linked below) to functions.php or some other place that runs arbitrary PHP. You can use the Code Snippets plugin too.
- Go to /wp-admin/index.php?givewp_set_legacy_lists=1 — be sure to add your own domain name at the beginning
- It will redirect you back to the same page, and now the lists should be legacy.
Here's the link to the snippet: https://gist.github.com/rickalday/ffb27e660cd4b1c7b1d9cf92ef696264
Stay tuned here for a potential fix for the larger issue, but we're short-staffed currently (and hiring!) on the development team for this issue.
A
Alex Ferguson
Ben Meredith: That temporary fix has worked for us, thanks. Looking forward to hearing about the broader fix.
E
Evan Barash
We are experiencing this too and no sensible workaround has been given other than to use the User Role Editor plugin, which doesn't fix the problem as you describe. https://feedback.givewp.com/bug-reports/p/givewp-accountant-role-does-not-have-the-access-it-should
Ben Meredith
Evan Barash: At this point I think these are two separate issues, one regarding user roles, and the other regarding essentially the server getting overloaded by too many donations. forms, and donors to be able to load. The fix for the two issues is unrelated. The user role plugin will fix the other issue, but not this one, as it's based on the number of donors/donations/forms present on the site, not on the user's ability to view them.
We're working to resolve both issues, but this one is far more urgent as it's site-wide regardless of user capability.
E
Evan Barash
Ben Meredith: Thanks Ben... It looks like they might be related, its certainly worth considering since granting the "edit_posts" permission to the GiveWP Accountant Role appears to fix the problem and the data now appears. A side-effect is that the user now also can Add/Edit non-Give Posts, Comments, etc. Is there a proper combination of permissions where we can restrict the GiveWP user roles to ONLY access areas of GiveWP and nothing else? I never looked at the roles before I noticed this happening bc we've been building our site and hadn't really tested different user roles until now.
Ben Meredith
under review
In most cases this is related to having a very large number of donations or donors or forms in the database, and is something we're trying to replicate using sample customer data currently.
There's not a workaround for the Donations Screen or the Donors screen as of yet.
We're using this feedback post to assess how many folks this is affecting. please comment and vote here.
E
Evan Barash
Ben Meredith: I have 4 donations, so I don't think that's it.
Ben Meredith
Evan Barash: Your case is almost certainly not this issue, then. It's a user permission-related issue. This issue is one that affects any admin user, too, so it's not the same as your issue. The comments here are not the place to get this resolved, so if you still need assistance, please follow up on your support ticket.
E
Evan Barash
Ben Meredith: I opened a ticket re: this issue and I was directed to look here 🤷🏻Thanks for all the help!! :)
Ben Meredith
Evan Barash: Definitely. Here's how it usually works, for reference:
- Support ticket with a problem.
- If it's just a problem on one site, and not a bug, it stays there and is resolved. If it's reproducible on other sites, we document steps to reproduce it, and escalate it to our team here, and link the customer to it so that they will hear back once it's resolved.
- Development team leads (along with the product managers) prioritize based on urgency (etc) and get the fix out.
All of the back-and-forth if you need further assistance should stay in the ticket (it's really just logistics... there are not enough people monitoring this feedback site, and your comment might not get seen).
And again (in answer to your other thread here) I assure you that the issue you are experiencing is NOT this issue, even though it has similar symptoms. The folks on this issue are getting a 500 error and not seeing the page at all, which is not what you are getting. Yours is a permissions issue, and is resolved with the user roles plugin.
B
Brock O
Ben Meredith: We have 390,000 donations and over 14,000 subscriptions. The legacy pages work fine, it's only the "new" versions that have a timeout issue.