[PrestaShopException] Root category must be an integer value at line 212 in file classes/helper/Hel

[kerlin]

Hello ! I send already this problem in the french forum and I post it here to be ...

 

I used a module to import products from a XML file. As it added products and categories when I wish only update, I imported products and categories directly into the database with exported from an other website.

Problem : only ID of categories are displayed in the BO of PS, without name. In the database, all informations are there.

Other problem : impossible to open the products list, the message in subject is displayed.

 

Thus, I launched the prestashop module cleaning to erase all categories and products.
But it's always impossible to open the list product page.

 

Into the database, in ps_configuration table PS_ROOT_CATEGORY = 1

in ps_category : id 1 = root - id 2 = home.

 

Here is the error message :

[PrestaShopException]

Root category must be an integer value
at line 212 in file classes/helper/HelperTreeCategories.php

207.     }
208. 
209.     public function setRootCategory($value)
210.     {
211.         if (!Validate::isInt($value)) {
212.             throw new PrestaShopException('Root category must be an integer value');
213.         }
214. 
215.         $this->_root_category = $value;
216.         return $this;
217.     }

I don't understand. I try other importing into the database, but nothing works.

I've a big need of help !

 

Thanks a lot !

[kerlin]

Hi ! I found how to repair that : I imported complete table about categories, images and products, not only data (INSERT after erasing).
It seems that one field is not good. I don't know wich one, the tables became from the same version of Prestashop.

An idea ? Only ID of products and categories was displayed on the BO.