DB migration - 1.0.8 to newest

[MichaelEZ]

Hi,

I´m trying to export and import products from TB 1.0.8 to 1.1.0 but problem is root category, Im unable to make it work. I tried to export categories via db, then upload it. I can see cat. in backend, but I ´m getting

• tb_category
• tb_category_group
• tb_category_lang
• tb_category_product
• tb_category_shop

Root category must be an integer valuein file classes/helper/HelperTreeCategories.php at line 350Source file: classes/helper/HelperTreeCategories.php331:        if (!isset($this->_node_item_template)) {332:            $this->setNodeItemTemplate(static::DEFAULT_NODE_ITEM_TEMPLATE);333:        }334:335:        return $this->_node_item_template;336:    }337:338:    /**339:     * @param int $value340:     *341:     * @return $this342:     * @throws PrestaShopException343:     *344:     * @since 1.0.0345:     * @version 1.0.0 Initial version346:     */347:    public function setRootCategory($value)348:    {349:        if (!Validate::isInt($value)) {350:            throw new PrestaShopException('Root category must be an integer value');351:        }352:353:        $this->_root_category = $value;354:355:        return $this;356:    }357:358:    /**359:     * @return mixed360:     *

Which means root dir is missing. But its not atleast i think

Same happens via store manager, or I can leave old root fold, and edit it - still not working.

1st img from 1.0.8 (exporting) and second is importing one.

 

Sure why nopt spend XX hours, then write this, when all i had to do is change parental ID od main categories 😄 

// i take that back 😄 its just became subfolder...

Edited September 2, 2019 by MichaelEZ

[Traumflug]

Uhm, what is the point of doing this? Updating v1.0.8 to v1.1.0 is pretty simple and straightforward.

[MichaelEZ]

Those are 2 shops, one is old and super slow and full of bugs, second new 1.1.0 clean with new design. It was presta 1.6 week ago, bought module to transfer data to new TB but wastn working. So when i updated presta to TB atleast its little bit faster, but now Im stuck at migrating data to new shop. When i copy table i got missing root dir. I thought store manager work out, but i just find out he changed categories ID.. 

 

When i upload tables its like this : 

pic1   [ AdminCategories&id_category=1&viewcategory              seems like #id1 but thats not root? ]

pic2   [ AdminCategories&id_category=2665          in category it shows "root" ]

pic3   [ AdminCategories default cat page - 24 cat are forbidden  ]

 

 

// Too many hick ups, problems, decided to upgrade on 1.1.0 and try to resolve slow queries problem, somehow 😄 

Edited September 5, 2019 by MichaelEZ