Critical Error when submitting donation

  • Resolved SAT

    (@stronganchortech)


    1 year, 8 months ago

    When a user attempts to submit a donation through WP Give, we are getting a generic WordPress error: “There has been a critical error on this website.”

    Talking with the hosting provider, they said it is an issue with the code of the plugin. Here is the error from the error log:

    [23-Jun-2023 11:20:33 UTC] WordPress database error Table ‘[…].JUb_give_revenue’ doesn’t exist for query INSERT INTO JUb_give_revenue (donation_id, form_id, amount) VALUES (310, 83, 100) 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_offline_process_payment, give_insert_payment, do_action(‘give_insert_payment’), WP_Hook->do_action, WP_Hook->apply_filters, Give\Helpers\Hooks::Give\Helpers{closure}, call_user_func_array, Give\Revenue\DonationHandler->handle, Give\Revenue\Repositories\Revenue->insert, Give\Framework\Database\DB::__callStatic, Give\Framework\Database\DB::runQueryWithErrorChecking, Give\Framework\Database\DB::Give\Framework\Database{closure}, call_user_func_array
    [23-Jun-2023 11:20:33 UTC] PHP Fatal error: Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Database Query in /home/domainprivacy/destituteorphans.org/wp-content/plugins/give/src/Framework/Database/DB.php:247
    Stack trace:

    0 /[…]/wp-content/plugins/give/src/Framework/Database/DB.php(95): Give\Framework\Database\DB::runQueryWithErrorChecking(Object(Closure))

    1 /[…]/wp-content/plugins/give/src/Revenue/Repositories/Revenue.php(47): Give\Framework\Database\DB::__callStatic(‘insert’, Array)

    2 /[…]/wp-content/plugins/give/src/Revenue/DonationHandler.php(30): Give\Revenue\Repositories\Revenue->insert(Array)

    3 [internal function]: Give\Revenue\DonationHandler->handle(310)

    4 /[…]/wp-content/plugins/give/src/Helpers/Hooks.php(43): call_user_func_array(Array, Array)

    5 /[…]/wp-includes/class-wp-hook.php(310): Give\Helpers\Hooks::Give\Helpers{closure}(310)

    6 /ho in /[…]/wp-content/plugins/give/src/Framework/Database/DB.php on line 247

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

    (@matheusfd)

    Hi, @stronganchortech.

    Glad you reached out. I can help you with that.

    For a bit of context, the latest GiveWP update included some database upgrades in order to provide new features right now and for the future, but some hosts prevented the upgrade from being completed correctly.

    The first thing you need to check right now is your MySQL version (or MariaDB version, depending on the server you are using). You need to contact your host ask and them to update your MySQL version to 5.7 or later, otherwise, GiveWP will not be able to create the needed database tables.

    After that, do the following:

    1. First, I’d recommend taking a backup of the site that you can confidently restore from. Here’s an article we wrote that explains more clearly how to do that: https://givewp.com/backup-for-faster-troubleshooting/
    2. Next, enable Advanced Database Updates in Donations > Settings > Advanced.
    3. Next, run the update in Donations -> Tools -> Data, and based on the Run Order columns, re-run the create_revenue_table update. If you notice any pending updates, run them as well.
    4. Check the logs at Donations > Tools > Logs for errors. If there are any errors, pass those along here.
    5. Last, navigate back to Donations > Settings > Advanced and disable Advanced Database Updates.

    Please let us know if you have further questions on this or need any additional assistance!

    Thread Starter SAT

    (@stronganchortech)

    It looks like running this database update fixed the issue. Thank you!

    Plugin Support Matheus Martins

    (@matheusfd)

    I’m glad to hear that, @stronganchortech.

    We’d love to get a public review about what you think of GiveWP both from a product standpoint as well as how it is to deal with our team. Here are some options:

    https://reviews.capterra.com/new/286934/89e00484-d257-4f08-ad39-f8f2ab7461d7?lang=en
    https://www.ads-software.com/support/view/plugin-reviews/give
    https://g.page/givewp/review?rc
    https://www.facebook.com/pg/wpgive/reviews/

    The reviews help others to decide if it’s worth doing business with us!

    Have a great day!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Critical Error when submitting donation’ is closed to new replies.