Doesn’t work, getting the the endless spinning wheel

Hi @niron,

Happy to help. The Classic and Multi-step form templates load via an iframe. When I tried to make a donation on your form, the iframe generated a 500 server error in the browser console. That means that some PHP script is crashing.

Your server error log should have a copy of the exact error that generated the problem. Check the error log file for any recent “fatal errors”.

In the meantime, make sure you have set a Donation Success page in GiveWP’s General settings. Make sure the date/time settings in the WordPress General Settings page are set. You don’t need to use a specific time/date setting just make sure they’re not set to “Custom” and the fields are not blank.

Thanks!

Hi,

Thanks for the prompt reply. Here’s the log file error report:

[27-Apr-2022 20:47:17 UTC] WordPress database error Table 'c75f41477068473.wp_give_revenue' doesn't exist for query INSERT INTOwp_give_revenue(donation_id,form_id,amount) VALUES (19979, 18709, 1000) 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_paypal'), 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\LegacyPaymentGatewayAdapter->createPayment, Give\PaymentGateways\Actions\CreatePaymentAction->__invoke, 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
[27-Apr-2022 20:47:17 UTC] PHP Fatal error:  Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Query failed in database in /var/www/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php:34
Stack trace:
#0 /var/www/wp-content/plugins/give/src/Framework/Database/DB.php(242): Give\Framework\Database\Exceptions\DatabaseQueryException::create(Array)
#1 /var/www/wp-content/plugins/give/src/Framework/Database/DB.php(90): Give\Framework\Database\DB::runQueryWithErrorChecking(Object(Closure))
#2 /var/www/wp-content/plugins/give/src/Revenue/Repositories/Revenue.php(45): Give\Framework\Database\DB::__callStatic('insert', Array)
#3 /var/www/wp-content/plugins/give/src/Revenue/DonationHandler.php(30): Give\Revenue\Repositories\Revenue->insert(Array)
#4 [internal function]: Give\Revenue\DonationHandler->handle(19979)
#5 /var/www/wp-content/plugins/give/src/Helpers/Hooks.php(43): call_user_func_array(Array, Array)
#6 /var/www/wp-includes/class-wp-hook.php(309): Give\Helpers\Hooks::Give\Helpers\{closure}(19979)
#7 /var/w in /var/www/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php on line 34
[27-Apr-2022 20:47:34 UTC] WordPress database error Table 'c75f41477068473.wp_give_revenue' doesn't exist for query INSERT INTO wp_give_revenue (donation_id, form_id, amount) VALUES (19980, 18709, 1000) 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_paypal'), 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\LegacyPaymentGatewayAdapter->createPayment, Give\PaymentGateways\Actions\CreatePaymentAction->__invoke, 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
[27-Apr-2022 20:47:34 UTC] PHP Fatal error:  Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Query failed in database in /var/www/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php:34
Stack trace:
#0 /var/www/wp-content/plugins/give/src/Framework/Database/DB.php(242): Give\Framework\Database\Exceptions\DatabaseQueryException::create(Array)
#1 /var/www/wp-content/plugins/give/src/Framework/Database/DB.php(90): Give\Framework\Database\DB::runQueryWithErrorChecking(Object(Closure))
#2 /var/www/wp-content/plugins/give/src/Revenue/Repositories/Revenue.php(45): Give\Framework\Database\DB::__callStatic('insert', Array)
#3 /var/www/wp-content/plugins/give/src/Revenue/DonationHandler.php(30): Give\Revenue\Repositories\Revenue->insert(Array)
#4 [internal function]: Give\Revenue\DonationHandler->handle(19980)
#5 /var/www/wp-content/plugins/give/src/Helpers/Hooks.php(43): call_user_func_array(Array, Array)
#6 /var/www/wp-includes/class-wp-hook.php(309): Give\Helpers\Hooks::Give\Helpers\{closure}(19980)

• This reply was modified 2 years, 10 months ago by Jan Dembowski.

Thanks. So the give_revenue table is missing. Here’s what you need to do:

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.

That should do the trick.

Alright. I have followed your orders and I think it’s working now!!!

Errors in the logs:

Log ID: 4
Description:
An error occurred while retrieving donation records
Category:
Core
Source:
Donor Dashboard
Date & Time:
2022-04-27 19:43:30
Error details:
Donor ID:1
Error:Query failed in database

Log ID: 5
Description:
An error occurred while retrieving donation records
Category:
Core
Source:
Donor Dashboard
Date & Time:
2022-04-27 19:45:03
Error details:
Donor ID:1
Error:Query failed in database

Were those errors recorded before or after you created the missing database table?

Before.

I have tested it now and it seems to be working.

Thanks so much @mrdaro Rick for all your support!