There was a problem running the migrations. Please reach out to GiveWP support f

I got this perplexing warning too that is far from helpful or informative.

I don’t know if it’s related but either shortly before or after both PayPal and Stripe connections were severed and I was forced to reapply to both companies and verify identity (which suggests maybe it’s not related to the migrations issue).

Hello @lmp3940wp & @sassymonkey,

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 running an outdated version of MySQL 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.
4. 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!

Thanks for the critical help here. Your timely expertise is much appreciated!

I’m running v2.10.1 of Give and latest WP 5.7 with MySQL 5.7.31 on PHP 7.4.15.

I followed the directions and turned on Adv DB Updates to rerun create_revenue_table without problem in Tools > Data > Database Updates.

Before retuning the above, the following items were showing as Pending:

• Delete give_logs and give_logmeta tables
• Delete old synchronizer logs
• Delete old email logs

All reran fine except “Delete give_logs and give_logmeta tables” which now is marked as Failed. Here is the data dump from this error: https://www.dropbox.com/s/6noel6owi2pgk6t/gro-give-error-log-tools-data-database_updates.txt?dl=0

From Tools > Logs there is an error for a Stripe payment test from last week, April 9: https://www.dropbox.com/s/v7hmz7pttiil477/gro-give-error-log-tools-logs.txt?dl=0

At least the problem running migrations error is no longer appearing, though I haven’t tried a test donation with Stripe again yet.
_______

OTHER (KINDA FOGGY) DETAILS
Not sure if related but, around same time as migration error notice appeared, both Paypal and Stripe disconnected. After reconnecting Stripe, got the error in Tools > Logs mentioned above.

• This reply was modified 3 years, 10 months ago by sassymonkey.

Hey @sassymonkey,

From your logs, this is what caught my attention:

DROP command denied to user '...'@'localhost' for table 'gqnmo82ga_give_logs'

It means that GiveWP tried to drop the table but your user didn’t have the privileges to do so. In this case, you need to contact your hosting company and ask them to add this privilege to your user, so GiveWP can delete that table.

After they add the drop table privilege to your user, try to rerun the failed upgrades. After that, try the payment with Stripe and let me know how it goes.

Thanks for using GiveWP! Have a great day.

Thanks again, @matheusfd, for the excellent help!

So I fixed perms with the user profile for the database on the website (Drop was deselected as a permission for the user of the db).

After that the Delete give_logs and give_logmeta tables portion succeeded and everything is green on the Tools > Data > Database Updates section.

LOG ERRORS / PENDING ISSUES REMAIN

Afterward, however, I tested a donation using Stripe and the charge is not going through to my bank as there’s no record in my statement after about 20 hours.

The transaction in Give Donations > Donations continues to show as Pending.

Also, in Donations > Tools > Logs, I see two errors for the transaction in question. See the dump for more information:

• https://www.dropbox.com/s/girjoqjo1jbjjii/stripe-error-20210414-06-58.txt?dl=0
• https://www.dropbox.com/s/hewa48y7iamuox1/stripe-error-20210414-07-30.txt?dl=0

MYSTERIOUS

I’m not sure what else to try here as I don’t know where the fault is. Is it Give plugin(s), Stripe, db/its user, WordPress, plugin conflict?

VERSIONS

Here are all of the Give plugins currently running:

• Donation Plugin v2.10.1
• PayPal Pro Gateway v1.0.3
• Per Form Gateways v1.0.2
• Recurring Donations v1.12.1
• Stripe Gateway v2.2.14