Variation dropdown missing following host move

[dangermoose]

Hi there,

The plugin had been working well until we moved it to a new server earlier today. Now the variation dropdowns have disappeared and we are a bit confused.

Could it be php, ubuntu version variations? Php is 5.2 and ubuntu is a slightly older version (but only just)… At this stage I’m just checking in case you have seen this happen before. The add to cart button is still there btw. I’d rather not post the url on a forum but happy to email directly if possible.

Many thanks.

[dangermoose]

It looks like it cannot see the database following the move and hence cannot see the products we had created. Even attempted to add a new product which failed (although it said ‘product added’)…

[dangermoose]

Just to give an update we are still struggling to get it to work. As I mentioned, all we have done is copy the files and import the database to a new server. We have un-installed and re-installed the eStore plugin but nothing seems to work. Looking at the naming conventions using WP Database plugin, I have spotted that the new site shows a lower case convention:

wp_wp_estore_tbl

whilst the development server (which works fine) shows the following:

wp_wp_eStore_tbl

Do you think this is critical and if so how would we go about repairing this. My coder is away for the weekend but the site is live so would appreciate any assistance you could offer.

Many thanks…

[wpCommerce]

You can have a look on this post to see if this has happened in your case – https://support.tipsandtricks-hq.com/forums/topic/products-and-customers-lost-but-not-settings-after-moving-from-local-pc

[amin007]

@dangermoose, Yes it is critical for the table name to be the same otherwise it won’t be able to find it.

When you did a server move did you manually recreate those tables or did you export your full wordpress database from the old server then import it into your new server? Because if you did the full export and import then everything should work off the bat.

Delete all the eStore tables from the database as the names are wrong. Then deactivate and reactivate the plugin (this should automatically recreate the tables with proper name). Make sure that the database stuff is working find by adding a test product.

Then you can import your product data from the old server’s table to this new one. If you don’t have too many products you might find it easier to add these again since your coder is away.

[dangermoose]

Thanks,

We re-imported the database and alls well.

Must have been corrupted during the initial import!

[Author]

Posts