Good day dear my readers!
Today, I was approached by one of my clients said Vasily HELP category is missing in the admin panel, which included doing something shuts down and it was gone, she put on the store sms opencart. I just came from the country terribly tired and desire was not quite what the deal, but customers need to fix the error ... The first thing in my head is spinning is to restore the database from backup and not steamed, write to the client that they say will establish backup your database on the day before, but she still asks to try to find all the desired category does not recover, made too many changes ... Well, what can you do pity was the client had to go to the database and look at what's the problem!
For category we respond table oc_category and oc_category_description , but in them I started to look for problems, including loud music to relax and started to think why this might be all the categories on the site, all included in the table and present in admin not. And then a few minutes later I turned my attention to the importance of parental categories ...
It turned out pretty simple, as a parent in our category was her own subcategory probably missed the client mouse and get this here ... Corrected recursion record and everything fell into place and category appeared successfully in the administrative panel. So do not rush to panic first temporarily, and most importantly, always be careful.