• Resolved heathern

    (@heathern)


    Our donation page is not working. When a donation is entered it just circles and never completes nor fails. This is for an offline/manually entered donation.

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Robin Joshua Del Mundo

    (@robindelmundo)

    Hi @heathern,

    Glad you reached out! Happy to help with this one.

    Sorry for the slow turnaround here as well.

    Anytime there’s a payment error in the front-end, there’s a more detailed message in the back-end under Donations → Tools → Logs. Click the eye icon next to any recent error message, and then copy and paste the full error message in your next reply. Here’s a screencast on how to get error logs: https://screencast-o-matic.com/watch/c3eD0AVFgVG.

    This will give us more details about the error.

    Please let me know if you have further questions.

    I’m always happy to help!

    Hi, I have the same problem. It throws a fatal error in php / SQL query. Here is the php log.

    PHP Fatal error: Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Database Query in /web/htdocs/www.fondazioneuspidalet.it/home/wp-content/plugins/give/src/Framework/Database/DB.php:247

    Alredy tried php 7.4 and 8.2, same error.

    Also updated the plugin to last version and same error

    Give WP logs:

    Descrizione:
    Database Query
    Categoria:
    Uncaught database exception
    Sorgente:
    Give Core
    Data e ora:
    2024-11-05 23:30:39
    Dettagli dell'errore:
    {
    "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 wp914_give_donors LEFT JOIN wp914_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 wp914_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 wp914_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 id = '3'",
    "Query Errors": {
    "db_delta_error": [
    "Unknown column 'phone' in 'field list'"
    ]
    }
    }
    Descrizione:
    Failed creating a donor
    Categoria:
    Core
    Sorgente:
    Give Core
    Data e ora:
    2024-11-05 16:32:25
    Dettagli dell'errore:
    {
    "donor": {
    "Object Class": "Give\\Donors\\Models\\Donor",
    "\u0000*\u0000attributes": {
    "id": null,
    "userId": null,
    "createdAt": null,
    "name": "Test Test",
    "firstName": "Test",
    "lastName": "Test",
    "email": "[email protected]",
    "phone": "",
    "prefix": "",
    "additionalEmails": [],
    "totalAmountDonated": null,
    "totalNumberOfDonations": null
    },
    "\u0000*\u0000original": {
    "id": null,
    "userId": null,
    "createdAt": null,
    "name": "Test Test",
    "firstName": "Test",
    "lastName": "Test",
    "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": []
    }
    }

    More php logs:

    WARNING: [pool www.fondazioneuspidalet.it] child 69 said into stderr: "[05-Nov-2024 16:46:05 UTC] WordPress database error Unknown column 'phone' in 'field list' for 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 wp914_give_donors LEFT JOIN wp914_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 wp914_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"

    WARNING: [pool www.fondazioneuspidalet.it] child 69 said into stderr: "_donor_last_name' LEFT JOIN wp914_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 = '2' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, give_post_actions, do_action('give_purchase'), WP_Hook->do_action, WP_Hook->apply_filters, give_process_donation_form, give_send_to_gateway, do_action('give_gateway_offline'), WP_Hook->do_action, WP_Hook->apply_filters, Give\Framework\LegacyPaymentGateways\Adapters\LegacyPaymentGatewayRegisterAdapter::Give\Framework\LegacyPaymentGateways\Adapters\{closure}, Give\LegacyPaymentGateways\Adapters\LegacyPaymentGatewayAdapter->handleBeforeGateway, Give\LegacyPaymentGateways\Adapters\LegacyPaymentGatewayA"

    WARNING: [pool www.fondazioneuspidalet.it] child 69 said into stderr: "dapter->getOrCreateDonor, Give\DonationForms\Actions\GetOrCreateDonor->__invoke, Give\Donors\Models\Donor::whereUserId, Give\Donors\Repositories\DonorRepositoryProxy->__call, Give\Donors\Repositories\DonorRepository->getByWpUserId, Give\Donors\Models\DonorModelQueryBuilder->get, Give\Framework\Database\DB::__callStatic, Give\Framework\Database\DB::runQueryWithErrorChecking, Give\Framework\Database\DB::Give\Framework\Database\{closure}, call_user_func_array"

    WARNING: [pool www.fondazioneuspidalet.it] child 69 said into stderr: "[05-Nov-2024 16:46:05 UTC] PHP Fatal error: Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Database Query in /web/htdocs/www.fondazioneuspidalet.it/home/wp-content/plugins/give/src/Framework/Database/DB.php:247"

    05/11/2024 17:46:05 WARNING: [pool www.fondazioneuspidalet.it] child 69 said into stderr: "Stack trace:"
    05/11/2024 17:46:05 WARNING: [pool www.fondazioneuspidalet.it] child 69 said into stderr: "#0 /web/htdocs/www.fondazioneuspidalet.it/home/wp-content/plugins/give/src/Framework/Database/DB.php(95): Give\Framework\Database\DB::runQueryWithErrorChecking()"
    05/11/2024 17:46:05 WARNING: [pool www.fondazioneuspidalet.it] child 69 said into stderr: "#1 /web/htdocs/www.fondazioneuspidalet.it/home/wp-content/plugins/give/src/Donors/Models/DonorModelQueryBuilder.php(22): Give\Framework\Database\DB::__callStatic()"
    05/11/2024 17:46:05 WARNING: [pool www.fondazioneuspidalet.it] child 69 said into stderr: "#2 /web/htdocs/www.fondazioneuspidalet.it/home/wp-content/plugins/give/src/Donors/Repositories/DonorRepository.php(76): Give\Donors\Models\DonorModelQueryBuilder->get()"
    05/11/2024 17:46:05 WARNING: [pool www.fondazioneuspidalet.it] child 69 said into stderr: "#3 /web/htdocs/www.fondazioneuspidalet.it/home/wp-content/plugins/give/src/Donors/Repositories/DonorRepositoryProxy.php(68): Give\Donors\Repositories\DonorRepository->getByWpUserId()"
    05/11/2024 17:46:05 WARNING: [pool www.fondazioneuspidalet.it] child 69 said into stderr: "#4 /web/htdocs/www.fondazioneuspidalet.it/home/wp-content/plugins/give/src/Donors/Models/Donor.php(113): Give\Donors\Repositories\DonorRepository in /web/htdocs/www.fondazioneuspidalet.it/home/wp-content/plugins/give/src/Framework/Database/DB.php on line 247"
    • This reply was modified 1 year, 7 months ago by orlandofatix.
    • This reply was modified 1 year, 7 months ago by orlandofatix.
    • This reply was modified 1 year, 7 months ago by orlandofatix.
    • This reply was modified 1 year, 7 months ago by James Huff.
    Plugin Support Robin Joshua Del Mundo

    (@robindelmundo)

    Hi @heathern ,

    It’s been a while since we’ve heard back, and I know troubleshooting needs a little extra time. I’m marking this as resolved for now, but if you still have questions, you can send them along right here, and I’ll be happy to hop back in.

    Thank you for sending your error logs @orlandofatix ! Although, this might be a different issue than what the original poster of this ticket had. Can you create a new ticket for this one? I’ll be happy to continue the conversation in there.

    Thank you for using GiveWP!

    Have a great day!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘GiveWP Forms not Working’ is closed to new replies.