Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Troubleshooting › Variation dropdown missing following host move
- This topic has 5 replies, 3 voices, and was last updated 12 years, 9 months ago by dangermoose.
June 25, 2010 at 1:59 pm #1416
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.June 25, 2010 at 2:16 pm #22004
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’)…June 25, 2010 at 7:43 pm #22005
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:
whilst the development server (which works fine) shows the following:
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…June 26, 2010 at 12:57 am #22006wpCommerceModerator
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-pcJune 26, 2010 at 1:11 am #22007amin007Participant
@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.June 28, 2010 at 8:45 am #22008
We re-imported the database and alls well.
Must have been corrupted during the initial import!
- You must be logged in to reply to this topic.