Cannot Delete Staging Site

Hello @markisparki

The orange bar is a staging attribute. It appears on the live site because you have migrated the staging site to the live site using the migration feature instead of the option ‘Copy the staging site to live’. That’s also why the ‘Delete’ and other options are gone.

To delete the orange bar, you can use phpMyAdmin to delete the ‘wpvivid_staging_data’ option in the wp_options table of the live site database.

Then to delete the staging data:

1. You can first use FTP or file manager to delete the staging folder from the root or /wp-content directory(depending on which directory you chose to install the staging site to when you created the staging site) of the live site.

2. Then use phpMyAdmin to delete the staging tables(all tables with a staging prefix which is wpvividstg01_ by default) from the database.

All the best,

Ok, that makes sense, thank you. The automatic copy option had failed and so I did have to use the manual migration method.

I had already dropped the now superfluous vivid tables and deleted the staging site, as you recommend, but I did not know about deleting the staging data from the normal options table. I will do that on Monday on my return to the office and let you know how it goes.

As a follow up question, doesn’t the ‘remove staging sites when you uninstall’ option in settings do this housekeeping then? Or did the manual migration break that setting?

Hi @markisparki

No problem.

The automatic copy option had failed and so I did have to use the manual migration method.

I see. Since the option ‘Copy the staging site to live’ is a pro version feature and we are not permitted to support pro version questions here. Please feel free to submit a ticket next time you get the issue.

but I did not know about deleting the staging data from the normal options table.

The staging tables are actually not in the options table. They are not in any tables and can be directly seen after you use phpMyAdmin to open the database. Please see this attached example screenshot.

doesn’t the ‘remove staging sites when you uninstall’ option in settings do this housekeeping then? Or did the manual migration break that setting?

Normally, it does. But in your case, the staging site is no longer identified due to the manual migration, then it does not.

All the best,

No, no. I am using the lite version, so don’t worry about the pro issue.

What I meant was I used the automatic copy site using the “copy and paste a key option”, which is in the lite version and was what failed.

Yes, I did delete the staging tables from the normal database as I said. What I didn’t know was to delete the staging data from the wp_options table (I said “options” table before, should have said “wp_options” table).

I’ll let you know how it goes on Monday.

Hi @markisparki

No problem. We will be waiting for your further update.

All the best,

To delete the orange bar, you can use phpMyAdmin to delete the ‘wpvivid_staging_data’ option in the wp_options table of the live site database.

That did the trick! Thank you – I can now create a fresh staging site if and when I want to.

Suggestion: Maybe have an option in the settings that will ‘force’ a return to fresh installation if a user requires it? You already have the option to delete the staging site and remove all files on uninstall, perhaps include the removal of this data from the wp_options table too?

Thanks for this marvellous plugin!

Hi @markisparki

No problem and glad the issue is resolved.

Thanks for the suggestions!

Maybe have an option in the settings that will ‘force’ a return to fresh installation if a user requires it?

Can you please give more information about this suggestion? For example, the usage scenario. Thanks.

perhaps include the removal of this data from the wp_options table too?

The staging attribute(the orange bar data) is actually with a staging site, normally after the staging site is deleted with the ‘Delete’ button or the uninstallation of the plugin, it will be deleted as well.

All the best,

Can you please give more information about this suggestion? For example, the usage scenario. Thanks

Yes, of course. The following has now happened to me more than once.

1. Create a staging site
2. As there is no automatic push staging to live in the lite edition, instead attempt to restore the staging site using the key method, which then fails.
3. Restore the site instead using manual migration.
4. The live site is now a copy of the staging site (good) but with extra tables in the database all starting with the WP vivid identifier and an orange bar as the live site thinks it is a staging site (bad).
5. Perform some housekeeping to sort the database out.

Maybe there is a better way to do 3. above if 2. fails to prevent this?

Hi @markisparki

I see. Thanks for your clarification.

It’s nice idea, but since we offer fully functional and simple option of ‘copy the staging site to live’ in the pro version as a difference between the free and pro version, any other options that can do the same job is not formally supported and recommended. We need to keep something for pro users only for team survival. We would appreciate your understanding on this.

All the best,