Customer migration from PS 1.7 to PS 8

[compsoul.dev]

I have two databases, one is from PS 1.7 the other is the latest database from PS 8. I have now moved the ps_customer column. I can see all the users in BO, I can log in, but when logging in I get this error:

 

Fatal error: Uncaught PrestaShopDatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC , categ...' at line 10<br /><br /><pre> SELECT c.*, cl.* FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 9 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND `id_lang` = 1 AND cg.`id_group` IN () GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC , category_shop.`position` ASC </pre> in public_html/classes/db/Db.php:769 Stack trace: #0 / in public_html/classes/Hook.php on line 998

Do I need to move any other columns?

[compsoul.dev]

Ok, I have resolved the error. After moving the ps_customer column, the users are not assigned to the customer group. Which results in an empty value being passed to SQL. There should be an if with an exception there.

Can someone kindly tell me if this is enough to move the customer database? Or do I still need to remember something. Everything seems to be working. It's just that I don't want to manually assign several thousand to a group. And in the database I'm getting a little bit of a chicken.

[bera_ramazan]

Hello, the necessary tables or columns are missing, so it may have given this error.

[compsoul.dev]

There was a customer group in the previous shop that is not present in the current shop. And all accounts have an empty customer group ticked. Thank you for your answer, do you perhaps know which columns are mandatory to transfer when migrating customers using the database?

[bera_ramazan]

3 hours ago, compsoul.dev said:

There was a customer group in the previous shop that is not present in the current shop. And all accounts have an empty customer group ticked. Thank you for your answer, do you perhaps know which columns are mandatory to transfer when migrating customers using the database?

ps_customer* and ps_adress*