[solved] Is there a way to reload categories? Or do I re-Install?

[Opting]

I tried to use multishop, which caused a big problem with categories.

I now disabled multishop, using version 1.5.4.1 and removed categories with this code:

 

TRUNCATE TABLE `ps_category`;

TRUNCATE TABLE `ps_category_group`;

TRUNCATE TABLE `ps_category_lang`;

TRUNCATE TABLE `ps_category_product`;

TRUNCATE TABLE `ps_category_shop`;

 

This deleted all the previous categories, but I needed to come back to how

it was before, having "home" as the default category.

 

Now, there's no category at all, how do I get to have the "home" category

back on? As it is now, I cannot access category at all. The system fails

to connect. Or shall I just re-install?

 

Please Help !!!

[vekia]

if you go to the catalog> catogies you've got possibility to define new categories? or to click on "EDIT" button ?

 

if you haven't got backup of your category tree - it isnt possible to restore it.

If you want to import default categories - just use the deafault prestashop categories tables and export them, then you will be able to import them to your store.

[Opting]

if you go to the catalog> catogies you've got possibility to define new categories? or to click on "EDIT" button ?

 

if you haven't got backup of your category tree - it isnt possible to restore it.

If you want to import default categories - just use the deafault prestashop categories tables and export them, then you will be able to import them to your store.

 

Hi,

No I don't want the old categories. I want to import the default categories.

Can you please explain how I will carry out the export and import.

Thanks

[vekia]

the easiest thing:

1. install new prestashop
   
2. login to the database manager like phpmyadmin
   
3. export tables:
   TABLE `ps_category`;
   TABLE `ps_category_group`;
   TABLE `ps_category_lang`;
   TABLE `ps_category_product`;
   TABLE `ps_category_shop`;
   
4. Now import the exported .sql file to proper store database
   

[Opting]

Thanks, Vekia,

I just re-installed anyway, and it all returned back to normal.

I was hoping there was a way, so that I will not have to re-install.

[vekia]

backup backup and one more time backup

if somethig will dont work with your configuraiton - then you can always rollback changes with the backup

 

im going to mark this topic as solved

 

regards