GiveWP Database management tools should be backward compatible to MySQL 5.6
complete
Jason Adams
Hi folks!
I just wanted to chime in and let everyone we just released GiveWP 2.10.2 which corrects MysQL 5.5+ compatibility with the logs table. We also went a step further and made
absolutely sure
that the logging system can't throw site-breaking exceptions, which I know some were having issues with.Please reach out to support if you have any further issues and we'll be happy to help!
C
Clifford Hill
I'm running v2.10.1 of Give and latest WP 5.7 on PHP 7.4.15 and getting the "problem running migrations" issue. Not sure if related but around same time both Paypal and Stripe disconnected. After reconnecting Stripe, it fails to take credit card payment with an error in logs. I notice in Donations > Tools > Data there are 3 items pending (see attached image). Far as I know nothing changed other than updated Give plugins and possible WP (though I don't remember when that updated exactly). Also my System Info is all green (except for a few email notifications that are turned off for inconsequential things).
C
Clifford Hill
SOLUTION FOUND:
A Give rep recently solved the migration warning issue with these instructions:
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:
- 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/
- Next, enable Advanced Database Updates in Donations > Settings > Advanced.
- 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.
- Check the logs at Donations > Tools > Logs for errors. If there are any errors, pass those along here.
- Last, navigate back to Donations > Settings > Advanced and disable Advanced Database Updates.
___________
NOTE: for me one table still would not update afterward. The Give rep suggested there was a perms problem on the database. I found there were perms restrictions on the user of the database that my WordPress install was loading (which I confirmed in the root wp-config file DB_PASSWORD / DB_USER sections). Once I fixed that, all database updates succeeded.
Stephen Edwards
Hi, I've updated to GiveWP 2.10.1 but still have an error about the migration log. I'm using MySQL 5.7.33. Could you provide the table details (i.e. fieldnames and datatypes) so I can create the table manually? Will creating the table manually fix the problem?
Jason Adams
complete
I'm happy to report this has been resolved in the GiveWP 2.10.1 release!
J
Joe
Any update on this item?
Ante Laca
in progress
Ben Meredith
under review
Our team is actively monitoring this for a hotfix release.