• Resolved leuno

    (@leuno)


    Hello, I have a big problem with donations. No matter which method the user chooses, after the donation, the loading continues indefinitely and I have this error in the logs:

    Failed creating a donor
    {
    "donor": {
    "Object Class": "Give\Donors\Models\Donor",
    "\u0000\u0000attributes": { "id": null, "userId": null, "createdAt": null, "name": "Daniele Leonetti", "firstName": "Daniele", "lastName": "Leonetti", "email": "[email protected]", "phone": "", "prefix": "", "additionalEmails": [], "totalAmountDonated": null, "totalNumberOfDonations": null }, "\u0000\u0000original": {
    "id": null,
    "userId": null,
    "createdAt": null,
    "name": "Daniele Leonetti",
    "firstName": "Daniele",
    "lastName": "Leonetti",
    "email": "[email protected]",
    "phone": "",
    "prefix": "",
    "additionalEmails": [],
    "totalAmountDonated": null,
    "totalNumberOfDonations": null
    },
    "\u0000\u0000properties": { "id": "int", "userId": [ "int", 0 ], "createdAt": "DateTime", "name": "string", "firstName": "string", "lastName": "string", "email": "string", "phone": "string", "prefix": "string", "additionalEmails": [ "array", [] ], "totalAmountDonated": "Give\Framework\Support\ValueObjects\Money", "totalNumberOfDonations": "int" }, "\u0000\u0000relationships": {
    "donations": "has-many",
    "subscriptions": "has-many"
    },
    "\u0000Give\Framework\Models\Model\u0000cachedRelations": []
    }
    }

    Additionally, I often get this error:
    Uncaught database exception
    {
    "Query": "SELECT id, user_id AS userId, email, phone, name, purchase_value AS totalAmountDonated, purchase_count AS totalNumberOfDonations, payment_ids AS paymentIds, date_created AS createdAt, token, verify_key AS verifyKey, verify_throttle AS verifyThrottle, give_donormeta_attach_meta_firstName.meta_value AS firstName, give_donormeta_attach_meta_lastName.meta_value AS lastName, give_donormeta_attach_meta_prefix.meta_value AS prefix FROM wp_give_donors LEFT JOIN wp_give_donormeta give_donormeta_attach_meta_firstName ON ID = give_donormeta_attach_meta_firstName.donor_id AND give_donormeta_attach_meta_firstName.meta_key = '_give_donor_first_name' LEFT JOIN wp_give_donormeta give_donormeta_attach_meta_lastName ON ID = give_donormeta_attach_meta_lastName.donor_id AND give_donormeta_attach_meta_lastName.meta_key = '_give_donor_last_name' LEFT JOIN wp_give_donormeta give_donormeta_attach_meta_prefix ON ID = give_donormeta_attach_meta_prefix.donor_id AND give_donormeta_attach_meta_prefix.meta_key = '_give_donor_title_prefix' WHERE user_id = '1'",
    "Query Errors": {
    "db_delta_error": [
    "Unknown column 'phone' in 'field list'"
    ]
    }
    }

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Support Matheus Martins

    (@matheusfd)

    Hi, @leuno.

    I’m glad you reached out. I can certainly help you.

    There is a failure regarding a field missing in your database. What likely happened here is that you did not run the database upgrades even though you had the latest version of the GiveWP plugins on your site. For example, if you navigate to donations > tools > data > database updates, you will find a migration called Add phone column to donors table, and that’s likely the migration that did not occur or failed.

    You can fix it by navigating to donations > settings > advanced > advanced options and there you enable the Advanced Database Updates. Then, navigate to donations > tools > data > database updates, look for Add phone column to donors table and re-run this update.

    Before taking any steps for troubleshooting or updating, I highly recommend taking a good backup of the site you can confidently restore from. Having a backup of your site is essential to a solid workflow, and will allow you to restore to a previous version of the site if you run into any issues. You can read more about our top recommendations for taking a backup here: https://givewp.com/backup-for-faster-troubleshooting/

    Feel free to reach out to us if you have any further inquiries or require additional assistance. We’re always happy to help!

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