Migrating to a staging environment

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: disabling, environment, migration, production, staging

Author

Posts
January 13, 2016 at 1:44 am #68063

Curtis F
Free User

Post count: 1

Hi,

I have an issue and I was wondering if someone was able to help me out with this.

We are currently setting up a new staging environment for our website but when we port it over it seems that everything has been disabled in the new environment. Everything still works in production but the ‘geodir_post_custom_fields’ method is returning an empty result set.

Looking at the database it looks like items in the wp_dhiq_geodir_custom_fields table are being updated somehow. These are are the columns that I have noticed that are being changed:

is_active, is_default, is_admin,is_required, required_msg, show_on_listing, show_on_detail

Everything is being set to false. Is GeoDirectory detecting a change in the environment and disabling everything?

I have attached two images indicating the discrepancy. The one marked as ‘prod-db’ is the production environment.

Any help would be greatly appreciated.

Thanks!
Curtis

January 13, 2016 at 6:10 am #68077

Guust
Moderator

Post count: 29970

I think you need to change all URL references in the database, see http://codex.wordpress.org/Moving_WordPress

January 13, 2016 at 5:08 pm #68203

Paolo
Site Admin

Post count: 31206

and possibly using a tool like this: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

that doesn’t break your serialized options.

Let us know how you went,

Thanks

January 29, 2016 at 5:02 am #113424

Curtis F
Free User

Post count: 1

Hello,

Thanks for all your replies, sorry it took so long getting back to all of you.

I’ve looked through all the staging code and it looks like all these items already happen. So, from what I can tell something in GeoDir is checking that the url isn’t the same anymore and is disabling everything. Is there anyway to prevent this, or does anyone know why this is actually happening?

Thanks.

January 29, 2016 at 5:27 pm #113741

Paolo
Site Admin

Post count: 31206

Hi,

there is no such function in GD. If you move the database correctly there is absolutely no reason why that could happen.

Thanks

January 29, 2016 at 5:37 pm #113765

justmark
Full Member

Post count: 375

I use something called ServerPress for development and it works seamlessly with a live production environment. You should give that a shot. Easier than XAMP and the basic version is free.
Author

Posts