No links menu after reset id category

[nuevo]

hello,

 

im working in a prestashop version 1.6.0.8, im reading about diferent post to reset the category to start in 1 etc, i think that we can have all info about here, this are the steps and the problem that i need help:

 

1- install prestashop.

2- go to myphpadmin and find db ps_category and ps_category_land because this two have the menu info.

3- clear all db doing this:

 

     Just execute this SQL command:

truncate table ps_category_lang;

truncate table ps_category;

 

4- one of you did step 3 i do this:

 

Just execute this SQL command:

 

I tried "ALTER TABLE ps_category AUTO_INCREMENT = 1"
and
"ALTER TABLE ps_category_lang AUTO_INCREMENT = 1"

 

5- go to backoffice and check that no category in menu, start to add a menu category, but the problem is that this menu, no have link in front office.

 

someone know how can i do this process more clear?. as soon as, i want to clear all menu category to start to add my categories in this order:

 

1-home

2-menu a

3-menu b

4-menu c

 

etc etc.

 

please help!!.

 

   

[vekia]

you need to define home category probably

INSERT INTO `ps_category` (`id_category`, `id_parent`, `id_shop_default`, `level_depth`, `nleft`, `nright`, `active`, `date_add`, `date_upd`, `position`, `is_root_category`) VALUES
(1, 0, 1, 0, 1, 12, 1, '2014-03-19 01:03:40', '2014-03-19 01:03:40', 0, 0),
(2, 1, 1, 1, 2, 11, 1, '2014-03-19 01:03:40', '2014-04-14 20:32:24', 1, 1);

[nuevo]

i try to edit sql with this, but doesnt work correct, when you add categories you cant choose Parent category and all of category that i add not have link in the menu.

 

any idea?.

[vekia]

so, after runing this sql you see 2 categories in ps_category table? or not?