Categories that are in sql table are missing data in back office

[shri]

 

 

I have main Categories, Sub Categories and default categories for each product. I entered data via sql in to ps_category_lang table.

All the data seems fine when i look at the sql table. But when i log in to back office.
The data appears to be missing in default categories. Main and sub categories are correct.

 As you can see the default category 1000104001017 has name and link_rewrite.

In the back office you can see the same data with name and ID.

But when i edit the default category it is empty. No name and no url. 

has this happened to anyone? I have made sure that the categories are active.

Edited July 28, 2015 by shri (see edit history)

[musicmaster]

The tree of categories is maintained through the nleft and nright fields. Adding a category means that that whole tree must be regenerated.