• Resolved Rose

    (@thorned-rose)


    Migration process is stuck on preview. It says “0 events previewed” “0 remaining”.

    Steps I took:

    1. Initially I just tried the upgrade but got a “Migration error – Migration was canceled” error.
    2. Disabled my caching (Litespeed Cache and Cloudflare)
    3. It went past the initial back and forth progress bar and said “6 events previewed” “0 remaining” which was correct at the time as I had 6 events. However it remained forever stuck on the completely full progress bar and “6 events previewed”.
    4. I then went through the rest of these suggestions: https://theeventscalendar.com/knowledgebase/migrating/#troubleshooting including adding a snippet with add_filter( 'tec_events_custom_tables_v1_db_transactions_supported', function(){ return false; } ); which made absolutely no difference.
    5. I have tried disabling and re-enabling the plugin. I have deleted all 6 events (which I put a lot of time into creating). No difference, it’s just stuck on 0 events instead of 6 events.
    6. While I have spent many hours trying to fix this, a new version of The Events Calendar was released. So I upgraded. No difference.
    7. I checked WP-cron – it’s fine. I have enough memory, disabling all other plugins, etc. No difference.
    8. I tried resetting the migration process with the supplied snippet in the link above. It did indeed reset the migration process but as soon as I set off the migration, it went straight back to being stuck on “0 events previewed” and that was with the snippet that supposedly forces migration to skip the preview.

    I’m now at my wits end. I have spent so many hours on this, deleted all our events and it’s still not working 🙁

    I’m pretty much ready for the nuclear option at this point – is there some way I can completely reset The Events Calendar and start from fresh?

    • This topic was modified 1 week, 3 days ago by Rose.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter Rose

    (@thorned-rose)

    I note other people have had the same issue but I can’t find any resolution: https://wordpress.org/support/topic/migration-preview-in-progress-but-never-completes/page/2/#post-16438839

    Plugin Support Darian

    (@d0153)

    Hi @thorned-rose

    Thanks for reaching out. Let me help you with this one.

    Would it be possible for you to set up a staging version of your live site and try to re-do the migration from there before applying to your live site?

    Here are the steps to revert and re-do the migration:

    1. Update to the latest versions of The Events Calendar and Events Calendar Pro.
    2. Remove any un-needed draft events and empty the Trash.
    3. Please create at least one event if you have none.
    4. Activate only our plugins and use the 2020 theme.
    5. Make sure server-side caching is disabled temporarily while you’re migrating your events.
    6. Install and activate the Code Snippets plugin.
    7. Add this snippet and run it once (be sure it does not stay activated).
    8. Go to Events > Settings > Upgrades and go through the migration process again.

    Please re-do the migration on your staging site.

    Let me know how it goes.

    Plugin Support Darian

    (@d0153)

    Hi there,

    It appears that there hasn’t been any recent activity on this thread, so we’ll consider it resolved. However, if you have any additional questions or concerns, feel free to start a new thread.

    Thread Starter Rose

    (@thorned-rose)

    Apologies for the slow reply, I got locked out of my WordPress account for several days :/ Thanks for getting back to me so quickly.

    I went through the database and found some VERY old entries for events, like 6 year old entries that did not show in The Events Calendar events. They came from when we were first using TEC many years ago, then for a while we stopped doing events and I uninstalled the plugin. It’s only now that we’re doing regular events again and needed to reinstall it.

    I suspect that somehow those original events became corrupted or the way that TEC stored events in the database changed in that time so those original events became sort of orphaned and sort of not, and that might be what was causing the migration to stall.

    In the end, I decided to take the nuclear option and manually searched the database to delete every single instance I could (searched for “tribe” and “tec” and removed all relevant rows). I noted that there were some (I assume?) new tables prepended with “tec” in the database and I that they were created by the migration? At any rate, I dropped those tables too.

    After deleting absolutely everything, I reinstalled and happy to say that it’s now working flawlessly 🎉

    For those perhaps considering the full deletion option where manually migrating your events, I opened every single event I had (in admin, not front end) and left them open until I had done all the database deletion and reinstall. That way I was able to at least copy-paste all the details into the fresh install. (You could alternately save the pages as html if you wanted an offline backup that doesn’t rely on leaving browser tabs open).

    So yeah, thanks again for your help even if I ended up resolving it in a very time consuming and destructive way.

    Plugin Support Darian

    (@d0153)

    Hi @thorned-rose

    I’m glad to hear that you were able to resolve the issue.

    Please do not hesitate to bump a new thread on our way if you have other questions or concerns. This allows us to track topics/issues efficiently and follow the WordPress Forum Guidelines.

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.