Migration never completed

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.

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.