Strange, something must have caused the migration to be aborted.
You should be able to reset by deleting the _ges_39_subscription_migration_in_progress option. If you have access to wp-cli, it’s easiest:
$ wp option delete _ges_39_subscription_migration_in_progress
You can delete directly from the database:
DELETE FROM wp_options WHERE option_name = '_ges_39_subscription_migration_in_progress';
If you don’t have access to either of these things, I could write a small plugin that will do it.
Thanks for the quick reply. I tried running the db query you provided but it said 0 rows affected. I ran this query to see what other values might be present in the wp_options table: SELECT * FROM wp_options WHERE option_name LIKE “%ges%”.
Here is a screenshot of the results.
Let me know if you have any other ideas on how I can proceed.
Plugin Author
r-a-y
(@r-a-y)
If you have access to the wp-cli command line tool, you can also do the migration there.
View the latter part of this article:
https://github.com/boonebgorges/buddypress-group-email-subscription/wiki/Migrating-to-3.9.0
Mine is also stuck on “Migrate subscriptions – In Progress” for the past 2 days now.
I do not have access to wp-cli.
Is there another way besides wp-cli or running a command directly on the db?
@graydawn1234 I followed the instructions @r-a-y posted and tested on my staging site and it looks like it worked. From the page he linked (https://github.com/boonebgorges/buddypress-group-email-subscription/wiki/Migrating-to-3.9.0):
If WP-CLI is unavailable, the following script may be used to force the migration in a single pageload. On large installations, this operation may timeout, but can be run repeatedly until the migration is complete.
Put the following script into an mu-plugin: https://gist.github.com/boonebgorges/14c0d1042e85d263d48f3eaf7ca25b6d
As an admin, visit wp-admin/?bpges-force-migrate=subscriptions to migrate subscriptions, or wp-admin/?bpges-force-migrate=queued_items to migrate queued items.
Thank you in advance for your guidance!
We ran the script and got the first two pieces of this migration to work, but I am unsure if I need to perform the last step of the migration.
If I run wp-admin/?bpges-force-migrate=queued_items – will it trigger emails that have been queued to be sent out?
When we click on View queued digest items in Group Email Subscription settings page, we get a blank screen so not sure if there is anything in the queue. Please give me some advice.
@ninabr – No emails will be triggered by this script.
The queue will be empty until the third step of the migration is complete.
