Jevgen Posted December 12, 2010 Share Posted December 12, 2010 Hello. I would like to ask. Why when i delete a customer from my back office, customer information is still in mysql database. Why it automatically do not erase from mysql database? or what i should do to set it up to automatically. Or something else.Jevgen Link to comment Share on other sites More sharing options...
shokinro Posted December 12, 2010 Share Posted December 12, 2010 I think when you delete a customer from back office, it only marked it as deleted. It is not deleted permanently from database. I think there are some reasons to do so. One reason I can think is, because it might be linked to other data, such as order, if you deleted permanently, it may cause error. Link to comment Share on other sites More sharing options...
PrestaShopDeveloper Posted December 12, 2010 Share Posted December 12, 2010 shokinro have answered why it's necessary just to be marked as deleted. If you want the users to be permanently deleted, one of the solutions is a custom Module, that will handle this case. You should know, that this way, all the customer related data will be removed as well, like orders, discounts & addresses. Link to comment Share on other sites More sharing options...
Jevgen Posted December 13, 2010 Author Share Posted December 13, 2010 all is clear. is this module free or for money ? Link to comment Share on other sites More sharing options...
PrestaShopDeveloper Posted December 13, 2010 Share Posted December 13, 2010 I do not know about a free module about this. Also, you can always remove the records directly from the DB, with phpMyAdmin for example, but you must know what' you're doing. Link to comment Share on other sites More sharing options...
Jevgen Posted December 13, 2010 Author Share Posted December 13, 2010 I need you help as soon as possible. I started delete unnecessary records in DB, and now in admin panel (back office) cannot see any categories of products. I wrote "catego.." and started clear, but after that i cannot see anything. See photos. Please, i need help. I do not want reinstall. I dont remember where i deleted records, somewhere in this 6 positions. HEEEEELP ME !Home category is missing. Sitemap does not showing "Home" category. Link to comment Share on other sites More sharing options...
PrestaShopDeveloper Posted December 13, 2010 Share Posted December 13, 2010 If by "this 6 positions" you mean the 6 tables from the screenshot above, then you've deleted wrong records. These 6 tables are related to the categories, these are not the customer related tables. As I said above, "you must know what you’re doing" before working with phpMyAdmin. The first table "ps_category" is the table with the categories, so you've probably removed all the categories. If you do not have backup, you can't restore the categories. Link to comment Share on other sites More sharing options...
Jevgen Posted December 13, 2010 Author Share Posted December 13, 2010 Can I manually add "home" category ?I do not need to restore it. I need restore "home". Open sitemap There is "home" and after that go other created categories.I NEED RESTORE THIS ONE ! See photo Link to comment Share on other sites More sharing options...
PrestaShopDeveloper Posted December 13, 2010 Share Posted December 13, 2010 Can you tell me what records do you have in the 6 tables above? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now