Proper way to move to another host

[Vincent]

Hi,

I am having an annoying problem that every time I copy the full WP database to another host (offline/localhost or another VPS) I have to change the settings of the plugin. None of my settings like currency, default template, URL slug, etc is being copied.

I also tried to export the database and import the SQL. But still same effect. What am I doing wrong? FYI, this problem does not occure in my other plugins like EDD.

[Barry]

Hi Vincent,

It’s not a problem that should happen and I have often performed the same operation with success.

If you look inside the export data, or within the options table once imported, do you see an entry where the option name is tribe_events_calendar_options? Can you copy and paste its value in here and confirm what you are expecting the default template setting, etc, to be so I can compare?

One possibility is that custom code, your theme or a plugin was overriding the values stored in the database via filters, so I’d like to explore that idea first of all and the above would help in such a scenario.

Thanks!

[Vincent]

This reply is private.

[Vincent]

By the way, I am using EDD Tickets

[Barry]

OK. So is that the way the option looks after importing it? It certainly looks as if those settings are being carried across, as expected.

Staying with the event slug issue for the moment – what are you actually experiencing? If you visit month view, for instance (on the target site) do the URLs utilize that slug as expected or not? If they do, is the problem that they lead to a 404 page?

[Vincent]

This reply is private.

[Barry]

Hi Vincent,

But hey, I just found out this option_value is from my online database. But online there is no problem with the settings. Only offline is an issue.

OK, so what I was interested in was the way the option data looked immediately after importing it. If what you shared was actually the original data from the source site, that doesn’t help too much.

Can you try importing to your local site/a new test site and let me know what that value is immediately after importing? What tools or commands are you using to perform the import/export work?

[Vincent]

This reply is private.

[Barry]

I’m unfamiliar with SQLyog, but it definitely sounds like something is going wrong there – the value of that field after copy clearly isn’t the same as the original.

Is it possible you are copying from the wrong database/wrong set of tables? If you’re positive that’s all in order, then it might be worth trying some other tool.

[Vincent]

This reply is private.

[Barry]

Hi Vincent,

That data isn’t actually JSON-formatted (instead it is serialized PHP), which is probably why the JSON viewer is throwing some errors.

s:15:"singleEventSlug";s:9:"evenement";

This section means your single event slug should be “evenement”. Taking this as a starting point, are your single event slugs something other than this, on the site where you imported the data?

Can you also confirm that the value you quoted is in place in the local/target database now that you have imported it? Are you using any forms of caching on the local/target site?

[Vincent]

This reply is private.

[Vincent]

Here is what I just found out:

I copied the option_value from online to offline. When I visit the tribe settings page ie. http://www.domain.com/wp-admin/edit.php?post_type=tribe_events&page=tribe-events-calendar

The option_value resets the value to:

a:3:{s:27:"recurring_events_are_hidden";s:6:"hidden";s:21:"previous_ecp_versions";a:1:{i:0;s:1:"0";}s:18:"latest_ecp_version";s:5:"3.9.3";}

[Barry]

I’m not sure what to suggest, Vincent. I can’t replicate this issue and have seen no other comparable reports: is there any further information you can provide? Which version(s) (of The Events Calendar and EDD Tickets) were you running on each site?

[Vincent]

This reply is private.

• This reply was modified 10 years, 9 months ago by Vincent. Reason: added question

[Author]

Posts