Problems updating 12.01 from 11.04

Installing my Dolibarr
1

When I tried to update to 12.01 there was a database error

Request 61 sql=‘DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 21;’
Error DB_ERROR_CHILD_EXISTS: DELETE FROM llx_c_regions WHERE fk_pays = 1 AND code_region = 21;
Cannot delete or update a parent row: a foreign key constraint fails (dolibarr.llx_c_departements, CONSTRAINT fk_departements_fk_region FOREIGN KEY (fk_region) REFERENCES llx_c_regions (code_region))

Any idea?
This error only affects some code_region not all. All from france (I think).
Any idea to repare?
Thanks

1 Like
2

Same problem for me.
How do you resolved it ?

3

There’s a problem with some french regions. I delete this regions.
I’m not in france.

4

UP.

On one update, it did that, while on another test installation, same server, it worked flawlessly … I can’t quite understand. However, you can choose to ignore the errors. Then go on with the next update v12 to v13. Errors won’t show up anymore in that process and there seem to be no effect.