http://www.tipsandtricks-hq.com/forum/topic/products-and-customers-lost-but-not-settings-after-moving-from-local-pc Support Forum for Tips and Tricks HQ Products en-US Thu, 09 Feb 2012 06:12:32 +0000 http://bbpress.org/?v=1.0.2 q http://www.tipsandtricks-hq.com/forum/search.php http://www.tipsandtricks-hq.com/forum/topic/products-and-customers-lost-but-not-settings-after-moving-from-local-pc#post-5356 Fri, 25 Jun 2010 01:37:44 +0000 amin007 5356@http://www.tipsandtricks-hq.com/forum/ <p>I thought anyone working with database tables should have this simple knowledge:</p> <p>For example, you have 3 tables in your WordPress database: </p> <p>Table1 - holds record of Apples<br /> Table2 - holds record of Oranges<br /> Table3 - holds record of Mangoes</p> <p>Now, when you move this WordPress database you only move table1 and table2 to your new server. Are you going to have access to the data stored in table3? No! because you didn't transfer it. Thats exactly what is happening in this case.</p> <p>WordPress has 11 core database tables that it creates at installation time. The tables are:<br /> <pre><code>wp_commentmeta wp_comments wp_links wp_options wp_postmeta wp_posts wp_terms wp_term_relationships wp_term_taxonomy wp_usermeta wp_users</code></pre> <p>WordPress lets the plugin developers store their plugin's settings data inside the table called "wp_options". Now, how will a plugin store other data for example product data? WordPress says create a table inside the WordPress database and store it. So the eStore creates a table inside the wpdb with the following name:<br /> <pre><code>wp_wp_eStore_tbl</code></pre> <p>This is where all the product data is stored.</p> <p>When you transfer your server you are suppose to transfer every table inside your WordPress database (this includes the 11 core WordPress tables and any other tables created by other plugins). </p> <p>What you are doing is only transferring the 11 core WordPress tables and leaving the other tables created by the plugin behind and asking me why the data is not on the new server! The settings data is there because it was stored in the "wp_options" table which you didn't forget to transfer.</p> <p>Let me know if it makes sense. </p> http://www.tipsandtricks-hq.com/forum/topic/products-and-customers-lost-but-not-settings-after-moving-from-local-pc#post-5350 Thu, 24 Jun 2010 13:52:09 +0000 rogersmj 5350@http://www.tipsandtricks-hq.com/forum/ <p>OK, but how about an actual answer as to why this happens? We frequently have to move sites because we don't develop in a production environment, and we've found both eStore and eMember seem to forget all of our categories, products, etc whenever we import the MySQL database to another server. This seriously hampers our development cycle and we won't be buying any more licenses until this is fixed. </p> http://www.tipsandtricks-hq.com/forum/topic/products-and-customers-lost-but-not-settings-after-moving-from-local-pc#post-5279 Tue, 22 Jun 2010 01:58:41 +0000 wpCommerce 5279@http://www.tipsandtricks-hq.com/forum/ <p>Settings data are stored in the main WordPress database but products and customer records are not. The products and customer records are stored in a table that is created by eStore which sits inside your wordpress database. So after moving your database the settings were still there because you only moved the core database tables and not all the tables. </p> http://www.tipsandtricks-hq.com/forum/topic/products-and-customers-lost-but-not-settings-after-moving-from-local-pc#post-5275 Mon, 21 Jun 2010 20:20:28 +0000 anotherbreed 5275@http://www.tipsandtricks-hq.com/forum/ <p>Yeah I understand, but I don't get how it can recall settings data even if I deleted all eStore database tables! Or why it didn't read (and save new) products data already present in the database displaying me no products in the Wordpress admin panel.</p> <p>Maybe is there an other place where it saves those informations?</p> <p>P.S.: I already solved my problem by adding everything again, but I'm interested in this discussion. </p> http://www.tipsandtricks-hq.com/forum/topic/products-and-customers-lost-but-not-settings-after-moving-from-local-pc#post-5264 Mon, 21 Jun 2010 00:47:50 +0000 amin007 5264@http://www.tipsandtricks-hq.com/forum/ <p>All the data is stored in the database and do not get deleted when you deactivate the plugin. This is to protect your data. Imagine what would happen if you mistakenly deactivated the plugin with thousands of products already configured!! This also make the plugin upgrade smooth as you don't have to redo the settings or anything.</p> <p>If you want to delete these data for good simply go to Your PHPMyAdmin and delete the database tables created by this plugin manually. </p> http://www.tipsandtricks-hq.com/forum/topic/products-and-customers-lost-but-not-settings-after-moving-from-local-pc#post-5262 Mon, 21 Jun 2010 00:18:24 +0000 wpCommerce 5262@http://www.tipsandtricks-hq.com/forum/ <p>Even if you deactivate, delete and reinstall the plugin your settings will be still same like before. </p> http://www.tipsandtricks-hq.com/forum/topic/products-and-customers-lost-but-not-settings-after-moving-from-local-pc#post-5260 Sun, 20 Jun 2010 21:06:45 +0000 anotherbreed 5260@http://www.tipsandtricks-hq.com/forum/ <p>I have fixed for now by deactivating, deleting the plugin and all the database tables of eStore. I reinstalled it, and now can add AND save products successfully.<br /> The strange thing: Settings data is still there...!</p> <p>I will work only online. </p> http://www.tipsandtricks-hq.com/forum/topic/products-and-customers-lost-but-not-settings-after-moving-from-local-pc#post-5258 Sun, 20 Jun 2010 16:52:09 +0000 anotherbreed 5258@http://www.tipsandtricks-hq.com/forum/ <p>Hi,</p> <p>I just moved my local PC wordpress site online by copying files and database. Everything is working fine but eStore seems to have lost all the products and customers stats, but settings are still there. I also did a quick deactivate and reactivate.<br /> I checked the database tables and they do contain my original product and customers data. Somehow eStore is just not finding them. </p> <p>Funnily enough I entered a new product with variations, hit save and received a msg indicating the product was saved successfully. I then went to the Manage Products panel to find nothing there. </p> <p>Any ideas? </p>