New Sub-categories - not showing

[InduStone]

Hi,

I'm adding new subcategories to one of the category, but they are not showing in the category list (footer or left menu).

These new categories are visible in the DB, but the 'nleft' and 'nright' values are equal 0.

I also noticed that the parent category has limited range by nleft and nright and all values in this range have been already taken by existing subcategories, thus my new categories can't get category numbers. Is there a way to recalculate it? 

I'd really appreciate your answer.

 

[InduStone]

Hi,

Does sombody have experience with nleft and nright values?

Is it save modify this parameters?

I wonder why no one answered...

[NemoPS]

What's your ps version? It's not a good idea to edit those values manually. Try to run "Category::regenerateEntireNtree();" from any script, see if it regenerates it properly

[InduStone]

Thank you NemoPS. 

PS 1.6.1.18.

Will try to regenerate tree, however the categories/sub-categories numbers are visible in the url's, so shouldn't be changed... Am I right?

 

 

[NemoPS]

Those will not change, the tree on regenerates nleft and nright

[InduStone]

Hi,

Unfortunately it didn't help.

I've created new subcategory, added some products to it, but when I select it from the list of subcategories it shows:

"Category not found"

Any idea?

Moreover, when I checked the ps_category table in DB if found that this newly created table has values of nleft and nright equal to zero.

I'd appreciate your answer.

Looking forward to your reply.

Regards

B

 

[vicko2017]

I have the same problem. Still no solution for this ?

[InduStone]

Hi I've found several empty categories in the DB table. These categories were not visible from backoffice. I manually deleted them and that solved the issue.

B

[Sergio]

Hi,

 

I´m facing a problem in subcategories when i update from 1.6.1.9 to 1.6.1.24.

When i click to edit subcategories the backoffice comes back to home categories. I can see they all have 1 in the position, but i haven't change anything, just updated.

 

Can you please help solve it?

 

Attached are two images with the problem.

 

Thank you very much for any help

 

[NemoPS]

open controllers/front/CategoryController.php.
in the initContent method, add this at the beginning:

Category::regenerateEntireNtree();

Access a category in the front office, then remove the modification. See if it's fixed.

[Sergio]

On 1/23/2020 at 1:39 PM, NemoPS said:

open controllers/front/CategoryController.php.
in the initContent method, add this at the beginning:

Category::regenerateEntireNtree();

Access a category in the front office, then remove the modification. See if it's fixed.

Thank you for the information. I haven't tested your solution because i have built all the categories and sub-categories from scratch.

 

But i'll keep your solution to another time if it happens again, because it took me days to build it all over.

 

Thanks.

[burki]

On 1/23/2020 at 4:39 PM, NemoPS said:

open controllers/front/CategoryController.php.
in the initContent method, add this at the beginning:

Category::regenerateEntireNtree();

Access a category in the front office, then remove the modification. See if it's fixed.

Hi, I have tested that but it didn’t work, I using ps 1.7.6.3 please help me.