• Resolved patwik

    (@patwik)


    Hi,

    When trying to access the Donations, a critical issue is occuring.
    /edit.php?post_type=give_forms&page=give-payment-history

    Here is the error:

    {
        "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 wp_posts LEFT JOIN wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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 wp_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"
            ]
        }
    }
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Critical error in Donations Dashboard’ is closed to new replies.