eMember – Complete SQL import, but eMember not seeing restored Settings

[terrys]

Hi,

I develop my sites locally on my PC (using DesktopServer) and then move it to my web host.

I have tried to first copy my live site onto my PC. I performed a full database SQL export/import. Everything seems to have loaded OK except that eMember plugin does not find any of its settings. ie. I go to Settings panel and ‘General Settings’ does not have the settings as in the SQL database. Same for ‘Pages/Forms Settings’ tab (it’s all blank) whereas I can see the actual settings are in the wp_options table (such as location of registration page, my email templates, etc) in the database just by browsing wp_options using phpmyadmin.

When I click on ‘Members’ (in WP admin) the eMember members ARE all there. i.e. Everything else in the site seems to work OK so I’m stumped as to why the eMember settings aren’t being read by eMember in WP admin. BTW, I also have eStore installed and all of its setting are found …it’s just eMember’s settings that aren’t getting loaded.

Any suggestions please?

(I’m trying to sort this out because I want to push a local copy up to my live site and I’m worried something similar may happen when trying to go live.)

Thanks,

Terry.

[terrys]

Having had a closer look at the database, I’m noticing something peculiar. In the .sql file that I exported, my eMember settings are present (220, eMember_configs and 221, eMember_configs_v2). When I look in the actual table wp_options (after import) those values are replaced with the default eMember settings.

Is the eMember plugin being triggered somehow to reset its settings?

[admin]

Hi Terry, Is the emember plugin version the same on both the sites (the exporting one and the importing one)?

[terrys]

Yes, same version = 8.5.6, and I also made sure that the WordPress versions are same (3.6.1).

Now, something VERY bizarre is happening at the moment. I just looked on my live site and the settings there have now disappeared too. It’s tempting to think that I somehow overwrote my live site but I seriously doubt it. Oh well. At this stage I’m in firefighting mode. I may as well try to just push my new site up to live host and deal with it up there. I’ll post here if I figure out what went wrong.

Regards,

Terry

[admin]

Hi Terry, I would recommend you do the following on your live site:

https://support.tipsandtricks-hq.com/forums/topic/re-install-or-load-a-fresh-build-of-the-plugins

Then go through the settings and save them yourself. It is pretty quick and easy to configure eMember (specially when you can look at the settings of your old site and just go over them quickly). The whole thing should take you a few minutes. This will definitely be a lot less headache approach for you.

[terrys]

Well, after much pain, I figured out that two main things were my problem (in case anyone else is interested):

1) A simple global replace of test domain to the new live domain name will not work, unless both names are same char length because the domain length value is embedded throughout the database. Also, some items reference local file structure and not the web host’s – I’m speaking generally here, not necessarily eMember. You need to use something like the rename tool from https://interconnectit.com/products/search-and-replace-for-wordpress-databases/ which will overwrite the correct length values too.

After I used this, the eMember settings appeared!

2) Case sensitivity.

Even after all of the above, for some reason, my eStore products were not showing. I could see the tables using myphpadmin with the products in them! So, I uninstalled & reinstalled eStore plugin. Products still not visible – but now I see that a new set of tables have been created with mixed case. ie. somehow on my PC dev environment, I had table names with “estore” and “emember” – whereas on the web host they are “eStore” and “eMember”. Case sensitivity!

Anyway, finally everything is as it should be

Regards,

Terry.

[Author]

Posts