• Resolved lcklem

    (@lcklem)


    I created a staging site some time ago with the free version of the wp-staging plugin for a website that I manage. Last year I migrated the site without using the wp-staging pro plugin. Since that time I believed I had fully converted from the staging site to the live site, but I am now finding remnants in the live site database table wp_options to the old staging site. I have had to remove the plugin, the old staging site and associated tables from the database because it was causing the site to constantly exceed the resources available for mysql and they wanted us to upgrade to something that is out of the realm of affordability at this time. With that being said, I have 5 references left in the table that I need to remove the staging from the URL, but when I do it affects the live site by either crashing, or causing the loss of customization made through the theme options. I am not sure I understand how these references became intertwined, and I have confirmed that the home and site URLs are pointed to the live site. How do I get these cleaned up so I have no references of the staging site left without causing damage or harm to the site? This I believe is causing a couple of issues in the WordPress Admin:

    1. I cannot login through Chrome to wp-admin — it redirects to a 404 error page. I don’t have the issue through Microsoft Edge.
    2. I cannot change my permalinks.

    • This topic was modified 6 years, 4 months ago by lcklem.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Rene Hermenau

    (@renehermi)

    > With that being said, I have 5 references left in the table that I need to remove the staging from the URL

    Please be more specific. What references are those?

    If your live site is using the wpstg_ tables now you have the still the old original wp_ tables in the database. I assume your cheap hoster is complaining these ones. To get rid of them you can delete them completely by using phpmyadmin.

    As I do not know how you moved the staging site to live manually I can not guarantee that my assumption is correct.

    Thread Starter lcklem

    (@lcklem)

    Hi Rene,

    Thank you for getting back to me. I moved the site manually by copying all of the files from the staging site to the live production site and then I changed the site and home URL’s in the database, wordpress and the wp-config file. I have most recently used Velvet Blue to go through the URL’s, etc and change the name, but it did not change any of the references below.

    All of the staging site tables had the word staging at the beginning of the tables. Those have been removed from the database. The staging folder has also been removed from the server.

    It will not let me include a snapshot or image of the wpstg references in the wp-options table, so I will do my best to show the information.

    272384 wpstg_settings a:4:{s:10:”queryLimit”;s:4:”1000″;s:9:”fileLimit”;… yes
    272404 wpstg_existing_clones a:1:{i:0;s:7:”staging”;} yes
    279388 wpstg_version 2.3.0 yes
    279389 wpstg_installDate 2016-05-02 02:47:04 yes
    279390 wpstg_RatingDiv yes yes
    279391 wpstg_firsttime true yes
    279392 wpstg_is_staging_site false yes
    279393 wpstg_hide_beta yes yes
    286189 wpstg_version_upgraded_from 2.2.4 yes
    285720 wpstg_start_poll no yes
    300410 wpstg_existing_clones_beta a:1:{s:7:”staging”;a:6:s:13:”directoryName”;s:7:”… yes
    300411 wpstg_poll no yes
    300412 wpstg_beta no yes
    300413 wpstg_rating No yes

    This is copied from the database table, but not drilled down to each entry. I have run a search through all of the database tables and these are the only pieces left that have the word staging or wpstg in them. I hope this helps since I cannot attach a photo or file.

    Plugin Author Rene Hermenau

    (@renehermi)

    You get rid of that database entries by going into wp staging settings, then activate the option “uninstall on delete”.

    Then delete wp staging plugin and all these settings are gone.

    Deleting these options can be done manually as well, directly from the database. This will not affect the functionality of your site.

    Thread Starter lcklem

    (@lcklem)

    I have done so, thank you for your help. Was leary of it crashing my site, but getting rid of the entries didn’t.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Staging Remnants’ is closed to new replies.