SOLVED: Can't add new products

Using my Dolibarr
1

Hello all,

I’ve imported about 580 products from an excel sheet, all actions / atributes are ok for these items. I want to add new products (new ones, copying existing ones, etc). This error is showed:

Cannot add or update a child row: a foreign key constraint fails (brainco3_doli624.llx1n_product_price, CONSTRAINT fk_product_price_user_author FOREIGN KEY (fk_product) REFERENCES llx_product_old (rowid))

Please note that before importing these 580 products, i had not tried to add products so I don’t know if this issue was caused because of this importation.

It happened when using 7.0.3 and still the same issue after updated to 8.0.0.

Thank you,
Pablo

2

Hello, maybe try one of the below options:
- Run the installer again
- Try a clean installation (if there is no loss to your business data/existing products)
- Upgrade to the latest stable version (currently 8.0.1)
- Check your folder permissions on your server

3

Same problem 8.0.1

Cannot add or update a child row: a foreign key constraint fails (brainco3_doli624.llx1n_product_price, CONSTRAINT fk_product_price_user_author FOREIGN KEY (fk_product) REFERENCES llx_product_old (rowid))

4

My fault, modified BD manually and made a backup of a table (see below), so constraint fails. Solved.