[Solved] I cannot add or update a product in PS1.7.5.1

[Web75000]

Hello

I have been update my ps from 1.6 to 1.7 and now i cannot add a new product or update the old product. i get this error  "Can not update or save a product"

Is there someone who has any idea about this bug please ?

thanks for the help

Edited May 24, 2019 by Web75000 (see edit history)

[selectshop.at]

php version you are using ?

See here the server requirements you need. If you used PS 1.6. before than you need to upgrade also your server requirements:

https://www.prestashop.com/forums/topic/884856-best-server-settings-for-prestashop-17-tested-in-production/

If requirements php version, database version, bcrypt are upgraded as needed and you are still having the problem, than activate debug mode and read/correct the errors that are written:

https://www.prestashop.com/forums/topic/224525-how-to-turn-on-error-reporting-for-debug-information-blank-page-500-internal-server-error/

[Web75000]

I found the reason and the solution of the problem.

The Problem:

When i checked the response of the request i found this error "step1_categories_tree:This value is not valid.",  so i checked my Database, exactly  the table ps_category_shop,  than i did not find the root category(id_category=1).

sql query to check "Select * from ps_category_shop where id_category<3"

The solution:

INSERT INTO `ps_category_shop`(`id_category`, `id_shop`, `position`) VALUES (1,1,0)
INSERT INTO `ps_category_shop`(`id_category`, `id_shop`, `position`) VALUES (1,2,0)