Title: Help ! Data lost ! Last modified: August 22, 2016 --- # Help ! Data lost ! * Resolved [lincal](https://wordpress.org/support/users/lincal/) * (@lincal) * [11 years, 2 months ago](https://wordpress.org/support/topic/help-data-lost/) * Hi, I installed this plugin recently on my development site and move the entire site into production. * I remember I checked everything was OK but today, I am contacted because my prices are not visible anymore; I just checked, and my tables are empty ! On top of that, I cannot even create a new one, nothing appears on the preview. * My first question is : where is the information ? I do not see any dedicated table in the database, nor I cannot find any relevant files. * All my prices are now away and some potential customers visit my site every day! * [https://wordpress.org/plugins/dk-pricr-responsive-pricing-table/](https://wordpress.org/plugins/dk-pricr-responsive-pricing-table/) * EDIT : It’s a bit critical for me, so I investigated. I can create a new pricing table, I just needed to create a page with the shortcode for the preview The information is not in the former pricing tables but is actually in the database => the question is : how I can extract this information to create the pricing tables or “re-activate” the pricing tables ? * A ling to the page with the error massage : [http://tofographies.com/photographe-mariage-toulouse/tarifs/](http://tofographies.com/photographe-mariage-toulouse/tarifs/) * Thanks for your support. Viewing 13 replies - 1 through 13 (of 13 total) * Thread Starter [lincal](https://wordpress.org/support/users/lincal/) * (@lincal) * [11 years, 2 months ago](https://wordpress.org/support/topic/help-data-lost/#post-5817451) * Hello, I found a solution – I could not wait longer. * I found the information in tables (thanks to some keywords I used); I copied the text and entered the informations manually again. * I am still interested in a manner to find this information and save it specifically if possible. And I do not know what happened, I hope I will not have this again. * Thanks * Plugin Author [WP Darko](https://wordpress.org/support/users/spwebguy/) * (@spwebguy) * [11 years, 2 months ago](https://wordpress.org/support/topic/help-data-lost/#post-5817457) * Bonjour, * Avez-vous essayé d’utiliser l’outil d’Import/Export de WordPress? * Le plugin _Responsive Pricing Table_ créé un “custom type” lorsque vous l’installez. WordPress sauvegarde vos données dans la table des Posts. Le custom type est nommé “**rpt_pricing_table**“. * Je suis content de voir que vous avez trouvé une solution à votre problème. Désolé de ne pas avoir pu vous répondre plus tôt. Pour une réponse sous moins de 24 heures, n’hésitez pas à utiliser [nos forums](http://wpdarko.com/). * Let me know how it goes 😉 * [ageibert](https://wordpress.org/support/users/ageibert/) * (@ageibert) * [11 years, 2 months ago](https://wordpress.org/support/topic/help-data-lost/#post-5817581) * I figured it out and it’s a really bad thing: * The plugin in version 2.x had other database field names than they are now in version 3 * To help you and all other users who will face this problem, here’s a short guide to get back your data. * In your database e.g. with phpMyAdmin: * SELECT * FROM `wp_posts` WHERE post_type like “%pricing_table%” change “post_type” from “dk_pricing_table” to “rpt_pricing_table” * For each pricing table entry (id) do: SELECT * FROM `wp_postmeta` where post_id = [YOUR_ID] * change each “meta_key” value from “_dkp*” to “_rpt*” e.g: old: “_dkp_plan_group” new: “_rpt_plan_group” * and edit the “meta_value” in “_rpt_plan_group” which is a serialized array. Copy the full text in a text editor and search and replace “_dkp” to “_rpt” ( we are lucky that “_rpt” and “_dkp” are of the same length though we do not have to serialize the data again…) * change your shortcode on your wordpress pages, the new format is: [rpt name=” your_pricing_table_name”] (formerly: [dk_pricing name=”your_pricing_table_name“] * —- i’ve never seen a plugin author changing low level database field names and values from one version to the next. this should never happen! * Plugin Author [WP Darko](https://wordpress.org/support/users/spwebguy/) * (@spwebguy) * [11 years, 2 months ago](https://wordpress.org/support/topic/help-data-lost/#post-5817582) * Hi ageibert, * You are right. This should never happen. The Responsive Pricing Table plugin is our first plugin. We’ve made a mistake and had to change the post type name. * We made sure this would never happen again with any of our other plugins. I understand your frustration and we are sorry for the inconvenience caused. * Updating a plugin should not be taken lightly. Make sure you read the [changelog](https://wordpress.org/plugins/dk-pricr-responsive-pricing-table/changelog/) before updating ANY plugin. It is accessible from within your WordPress admin panel, it tells you what’s up with the new version. * Also, **always back up your data** before doing updates to avoid this kind of inconvenience. * Version 3.0 of our plugin clearly warned about data loss: * > WARNING: FOR THOSE WHO UPGRADE FROM AN EARLIER VERSION TO THIS VERSION, YOU > WILL NEED TO RE-CREATE YOUR PRICING TABLES! * Again, we are sorry for the inconvenience caused. * [ageibert](https://wordpress.org/support/users/ageibert/) * (@ageibert) * [11 years, 2 months ago](https://wordpress.org/support/topic/help-data-lost/#post-5817583) * Hi there and thanks for the info. I think it’s a a good thing, that i additionally created a “how to recover the lost pricing tables” earlier this thread 🙂 * best regards * Plugin Author [WP Darko](https://wordpress.org/support/users/spwebguy/) * (@spwebguy) * [11 years, 2 months ago](https://wordpress.org/support/topic/help-data-lost/#post-5817584) * Hi, * Yes it is, it will probably help others. Thank you for the fix. We’ve helped someone who came with the same issue a while ago (with the same solution). * Have a great day! * Thread Starter [lincal](https://wordpress.org/support/users/lincal/) * (@lincal) * [11 years, 1 month ago](https://wordpress.org/support/topic/help-data-lost/#post-5817626) * Dear both, * Really sorry for not answering earlier… thanks for the additional info. * I understand it was not possible to answer quicker at that time, but I needed to do something. * I am not sure I understood all technical point, but does it mean I will not be able to upgrade without building the tables again ? * [ageibert](https://wordpress.org/support/users/ageibert/) * (@ageibert) * [11 years, 1 month ago](https://wordpress.org/support/topic/help-data-lost/#post-5817627) * Hi lincal, yes, if you have version 2 and want to update zu version 3 you will“ loose” all the tables data. However, as i described above, the data is not really lost. You can recover it following the steps above. * best regards * Plugin Author [WP Darko](https://wordpress.org/support/users/spwebguy/) * (@spwebguy) * [11 years, 1 month ago](https://wordpress.org/support/topic/help-data-lost/#post-5817628) * Hi (both), * Ageibert is right. It is still in your database and if you follow these few steps above you will “convert” them for **version 3.0**. * This will not happen again, of course. * You said: “_I found the information in tables (thanks to some keywords I used); I copied the text and entered the informations manually again._“ * Are you still using a previous version? * Thread Starter [lincal](https://wordpress.org/support/users/lincal/) * (@lincal) * [11 years, 1 month ago](https://wordpress.org/support/topic/help-data-lost/#post-5817629) * Actually, it seems I have… version 4.0.1 (and you talk about version 2.x and 3.x) * Plugin Author [WP Darko](https://wordpress.org/support/users/spwebguy/) * (@spwebguy) * [11 years, 1 month ago](https://wordpress.org/support/topic/help-data-lost/#post-5817630) * Is everything working fine? * **4.0.1** is the last version, with the new admin panel. * Thread Starter [lincal](https://wordpress.org/support/users/lincal/) * (@lincal) * [11 years, 1 month ago](https://wordpress.org/support/topic/help-data-lost/#post-5817631) * Ok, so the problem probably went when I upgraded and it might be solved now 🙂 Yes, every think looks fine (the extension was desactivated recently, I did not notice how/when, but activate it again made evrething in order. * And I think I made the initial correction with version 3.x because I did not notice the new admin panel, and actually changes are significant! * Thanks again * Plugin Author [WP Darko](https://wordpress.org/support/users/spwebguy/) * (@spwebguy) * [11 years, 1 month ago](https://wordpress.org/support/topic/help-data-lost/#post-5817632) * **You’re welcome**, glad you got this working! * Have a good day. Don’t hesitate to come back if you need anything. Viewing 13 replies - 1 through 13 (of 13 total) The topic ‘Help ! Data lost !’ is closed to new replies. * ![](https://ps.w.org/dk-pricr-responsive-pricing-table/assets/icon-256x256.png? rev=1776325) * [Responsive Pricing Table](https://wordpress.org/plugins/dk-pricr-responsive-pricing-table/) * [Frequently Asked Questions](https://wordpress.org/plugins/dk-pricr-responsive-pricing-table/#faq) * [Support Threads](https://wordpress.org/support/plugin/dk-pricr-responsive-pricing-table/) * [Active Topics](https://wordpress.org/support/plugin/dk-pricr-responsive-pricing-table/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/dk-pricr-responsive-pricing-table/unresolved/) * [Reviews](https://wordpress.org/support/plugin/dk-pricr-responsive-pricing-table/reviews/) ## Tags * [Data lost...](https://wordpress.org/support/topic-tag/data-lost/) * 13 replies * 3 participants * Last reply from: [WP Darko](https://wordpress.org/support/users/spwebguy/) * Last activity: [11 years, 1 month ago](https://wordpress.org/support/topic/help-data-lost/#post-5817632) * Status: resolved