[solved] Problem with categories: impossible to access, impossible to edit -> BUG?

[TourisT]

Hi,

 

I created a set of categories like:

 

- root

- Home

- A

- 1

- 2

- 3

- B

- 4

- 5

- 6

- C (id 24)

- D (id 25)

 

I then deleted directly in the database cat id 24 and 25 (and 26 as I noticed one was kind of "half created")

 

Then I created

- E (id 26)

- 7 (id 27)

 

So we have now:

 

 

- root

- Home

- A

- 1

- 2

- 3

- B

- 4

- 5

- 6

 

- E (id 26)

- 7 (id 27)

 

But in the BO, on the main page of categories, cat id 26 shows up on top of the others, I cannot edit it nor enter it. SO I cannot even know the existence of cat id 27 from BO (but can see it in the DB)

 

I'm happy to send you an export of my ps_category_* tables in PM

 

Important Note (aka: what makes me think it's a bug)

-> if I click on "add new root category" it has no effect (understand it reloads the categories main page)

-> if I click on "add new category" it has no effect (understand it reloads the categories main page)

 

Thanks,

Edited July 22, 2012 by TourisT (see edit history)

[TourisT]

I tried to re-create category records using direct sql code:

INSERT INTO `ps2_category_lang` (`id_category`, `id_shop`, `id_lang`, `name`, `description`, `link_rewrite`, `meta_title`, `meta_keywords`, `meta_description`) VALUES

(24, 1, 1, 'Test1', '', '', '', '', ''),

(24, 1, 2, 'Test1', '', '', '', '', ''),

(24, 1, 3, 'Test1', '', '', '', '', ''),

(24, 1, 4, 'Test1', '', '', '', '', ''),

(24, 1, 5, 'Test1', '', '', '', '', ''),

(24, 2, 1, 'Test1', '', '', '', '', ''),

(24, 2, 2, 'Test1', '', '', '', '', ''),

(24, 2, 3, 'Test1', '', '', '', '', ''),

(24, 2, 4, 'Test1', '', '', '', '', ''),

(24, 2, 5, 'Test1', '', '', '', '', ''),

(24, 3, 1, 'Test1', '', '', '', '', ''),

(24, 3, 2, 'Test1', '', '', '', '', ''),

(24, 3, 3, 'Test1', '', '', '', '', ''),

(24, 3, 4, 'Test1', '', '', '', '', ''),

(24, 3, 5, 'Test1', '', '', '', '', ''),

(24, 4, 1, 'Test1', '', '', '', '', ''),

(24, 4, 2, 'Test1', '', '', '', '', ''),

(24, 4, 3, 'Test1', '', '', '', '', ''),

(24, 4, 4, 'Test1', '', '', '', '', ''),

(24, 4, 5, 'Test1', '', '', '', '', ''),

(24, 5, 1, 'Test1', '', '', '', '', ''),

(24, 5, 2, 'Test1', '', '', '', '', ''),

(24, 5, 3, 'Test1', '', '', '', '', ''),

(24, 5, 4, 'Test1', '', '', '', '', ''),

(24, 5, 5, 'Test1', '', '', '', '', ''),

(24, 6, 1, 'Test1', '', '', '', '', ''),

(24, 6, 2, 'Test1', '', '', '', '', ''),

(24, 6, 3, 'Test1', '', '', '', '', ''),

(24, 6, 4, 'Test1', '', '', '', '', ''),

(24, 6, 5, 'Test1', '', '', '', '', ''),

(25, 1, 1, 'Test2', '', '', '', '', ''),

(25, 1, 2, 'Test2', '', '', '', '', ''),

(25, 1, 3, 'Test2', '', '', '', '', ''),

(25, 1, 4, 'Test2', '', '', '', '', ''),

(25, 1, 5, 'Test2', '', '', '', '', ''),

(25, 2, 1, 'Test2', '', '', '', '', ''),

(25, 2, 2, 'Test2', '', '', '', '', ''),

(25, 2, 3, 'Test2', '', '', '', '', ''),

(25, 2, 4, 'Test2', '', '', '', '', ''),

(25, 2, 5, 'Test2', '', '', '', '', ''),

(25, 3, 1, 'Test2', '', '', '', '', ''),

(25, 3, 2, 'Test2', '', '', '', '', ''),

(25, 3, 3, 'Test2', '', '', '', '', ''),

(25, 3, 4, 'Test2', '', '', '', '', ''),

(25, 3, 5, 'Test2', '', '', '', '', ''),

(25, 4, 1, 'Test2', '', '', '', '', ''),

(25, 4, 2, 'Test2', '', '', '', '', ''),

(25, 4, 3, 'Test2', '', '', '', '', ''),

(25, 4, 4, 'Test2', '', '', '', '', ''),

(25, 4, 5, 'Test2', '', '', '', '', ''),

(25, 5, 1, 'Test2', '', '', '', '', ''),

(25, 5, 2, 'Test2', '', '', '', '', ''),

(25, 5, 3, 'Test2', '', '', '', '', ''),

(25, 5, 4, 'Test2', '', '', '', '', ''),

(25, 5, 5, 'Test2', '', '', '', '', ''),

(25, 6, 1, 'Test2', '', '', '', '', ''),

(25, 6, 2, 'Test2', '', '', '', '', ''),

(25, 6, 3, 'Test2', '', '', '', '', ''),

(25, 6, 4, 'Test2', '', '', '', '', ''),

(25, 6, 5, 'Test2', '', '', '', '', '');

 

INSERT INTO `ps2_category_group` (`id_category`, `id_group`) VALUES

(24, 1),

(24, 2),

(24, 3),

(25, 1),

(25, 2),

(25, 3);

 

INSERT INTO `ps2_category` (`id_category`, `id_parent`, `level_depth`, `nleft`, `nright`, `active`, `date_add`, `date_upd`, `position`, `is_root_category`) VALUES

(24, 2, 2, 46, 47, 1, '2012-07-21 01:42:02', '2012-07-21 01:42:02', 0, 0),

(25, 24, 3, 46, 47, 1, '2012-07-21 01:43:02', '2012-07-21 01:43:02', 0, 0);

 

Same behavior... Same problems...

[TourisT]

I thought it may come from the category tree being biased on a nleft / nright level due to my manual modifications.

 

I tried to install this module to rebuild category tree:

http://www.prestashop.com/forums/topic/93231-ps-v14-category-table-what-is-nleft-et-nright-for/

 

It's fully compatible with 1.5.0.13 but seems not to correct the bug. I fear the bug is not on a database side...

 

Anybody could help me with that?

[TourisT]

It seems to be indeed a bug in 1.5.0.13:

 

If you use different root categories in a single multistore group, it will make the categories view behave abnormally:

- impossible to edit some of the existing categories

- impossible to add a new one

-> management is impossible

 

In order to fi this, make sure all the stores from a single group store are using the same root category OR subroot categories from a same root...

 

Hope this will be corrected in the final release. At least by implementing a system preventing the user to use different root categories in the same group. I believe that a root selector should be implemented on the group level.

 

Setting thread as solved

[Martin C]

Did you post it on the forge?

[TourisT]

  On 7/23/2012 at 6:10 AM, Martin Crielaard said:

Did you post it on the forge?

 

Sorry I don't know what 'the forge' is. So I didn't