PS 1.7: does not display subcategories

[ph34k]

Hello. I threw products yesterday, everything went so little. This afternoon I will log in to the admin and it does not show me subcategories. They are on, I did not change their settings, nothing. If I want to edit a subcategory, it will display, - The object cannot be loaded (not found)

Can you advise where betrayal can be and how to fix it? Or if someone could look into it for a reward

[Razi]

You have import categories?

this issue come when something is missing from database.

[ph34k]

2 minutes ago, Razi said:

You have import categories?

this issue come when something is missing from database.

I throw products and categories manually, I do not use import. I will try to create the subcategories again manually

[T74]

had similar issue 1.7 no multistore, after moving cat from parent to subcategory suddenly can't see subcategory on admin page anymore, filter got empty result.
sql shows ... WHERE 1 AND `id_parent` = >>>2<<< AND `name` LIKE ... restricts to parent id "2" cat only.

simple hack in AdminCategoriesController.php near line 145

$this->_select = 'sa.position position';
//$this->original_filter = $this->_filter .= ' AND `id_parent` = ' . (int) $id_parent . ' '; <----------comment this line out
 $this->_use_found_rows = false;