rebuild / regenerate category tree

[Designinfo.in]

nleft and nright values for new categories are 0 . They are not getting updated.

the new categories that i create are not visible in the front office

in the screenshit you will be able to see the last 4 categories have 0 nleft and nright values

.htaccess file has not been changes

images for other categories not visible in top horizontal menu

rest all categories work fine

these new categories are set to be enabled obviously

i want to regenerate the category tree---prestashop is not doing it automatically for me

 

 

 

 

 

[NemoPS]

I'd try adding Category::regenerateEntireNtree();
Use it inside any module that hooks anywhere, as long as it runs

[Designinfo.in]

What do u mean add in any module....?

Sorry did not understand

Do you mean I should add it in the top Horizontal menu css files?

Please be a little more specific

[musicmaster]

Nemo means that the important thing is that you run it. Of course you cannot run php from a css file. You need to call the function from a php file.

[Designinfo.in]

how to call this function?

I dont know how to do it.

[musicmaster]

What Prestashop version are you using?

[NemoPS]

Just drop this in

Category::regenerateEntireNtree();

[Designinfo.in]

Just drop this in

 

Category::regenerateEntireNtree();

What do you mean ? In which file does this code have to added and in which lines?

Please advise. This has been an issue for me now.

[NemoPS]

Just grab any active module, any active hook, and paste it there. It just has to run.

[Kogkalidis]

I'd try adding Category::regenerateEntireNtree();

Use it inside any module that hooks anywhere, as long as it runs

 

Thanx NemoPS, you saved my life. Cheers   

[kulk21]

Category::regenerateEntireNtree();

 

do i drop this from backofice or from ftp server not sure what to do?

[kevinberben]

Hi all,

 

 

I use this : 

Db::getInstance()->execute('UPDATE `ps_category` SET `nleft`=0,`nright`=0 WHERE 1');
Category::regenerateEntireNtree();

 

Now each nleft and Nrights are on 0. But the catagory regeneration does not work.
I try to use the Regenerate Category Tree module. When I regenerate, it does not work too.

 

Maybe a problem in my pq_category table?
Can someone help me?

 

Thanks,

Kev

[NemoPS]

It might as well be, the only way to know is troubleshooting line by line

[Blue Bear]

Hi everyone,

 

I need to regenerate the category tree of my prestashop 1.7.5.1.0. I don't know where to apply any of this solutions :

Db::getInstance()->execute('UPDATE `ps_category` SET `nleft`=0,`nright`=0 WHERE 1'); Category::regenerateEntireNtree();

or

Category::regenerateEntireNtree();

Can someone could be more specific or share an example of modifiefd file in order for me to understand please ? And is it still working for prestashop 1.7.5.1.0 ?

I've tried to load the category tree module https://github.com/johnulist/category-tree-regenerator

and it's not working.

Best regards,

Clément

[musicmaster]

On 3/15/2021 at 11:03 AM, Blue Bear said:

Hi everyone,

 

I need to regenerate the category tree of my prestashop 1.7.5.1.0. I don't know where to apply any of this solutions :

Db::getInstance()->execute('UPDATE `ps_category` SET `nleft`=0,`nright`=0 WHERE 1'); Category::regenerateEntireNtree();

or

Category::regenerateEntireNtree();

Can someone could be more specific or share an example of modifiefd file in order for me to understand please ? And is it still working for prestashop 1.7.5.1.0 ?

I've tried to load the category tree module https://github.com/johnulist/category-tree-regenerator

and it's not working.

Best regards,

Clément

I have no idea why nleft and nright are set to zero first. Seems just foolish to me.

Note that when you regenerate it recreates the tree from the information it finds in id_parent, is_root, position and level. So when there is a problem with those values regeneration won't work.

Prestools has some kind of regeneration function too in its Integrity Checks.

[David MEYER]

On 3/18/2021 at 7:43 PM, musicmaster said:

I have no idea why nleft and nright are set to zero first. Seems just foolish to me.

Because if a category is orphaned, it will not be modified by regenerateEntireNtree() and will keep his nright and nleft which will be in conflict with good ones.

[PatriceJV]

The problem I had was that I needed to be logged to be able to run the function. Here is my file that I can fire even if I'm not logged in the admin

 

Echo "Whatever pleases you to print on the page when it is done";

//Indicate where to find you config file
require 'Your_Path_To_This_File/config/config.inc.php';

//Set all nleft and nright to zero prior to generate
Db::getInstance()->execute('UPDATE `ps_category` SET `nleft`=0,`nright`=0 WHERE 1');
//Then regenerate
Category::regenerateEntireNtree();