migrate problem from 3.1.1 to 3.2.0

Installing my Dolibarr
1

Hi Eldy, after trying to upgrade from 3.1.1 to 3.2.0 I had this errors in my log and an unfinished upgrade script.

Error DB_ERROR_1452: ALTER TABLE llx_propal ADD CONSTRAINT fk_propal_fk_user_author FOREIGN KEY (fk_user_author) REFERENCES llx_user (rowid);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.#sql-2f5_3e2, CONSTRAINT fk_propal_fk_user_author FOREIGN KEY (fk_user_author) REFERENCES llx_user (rowid))

Error DB_ERROR_1452: ALTER TABLE llx_propal ADD CONSTRAINT fk_propal_fk_user_valid FOREIGN KEY (fk_user_valid) REFERENCES llx_user (rowid);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.#sql-2f5_3e2, CONSTRAINT fk_propal_fk_user_valid FOREIGN KEY (fk_user_valid) REFERENCES llx_user (rowid))

Error DB_ERROR_1452: ALTER TABLE llx_propal ADD CONSTRAINT fk_propal_fk_user_cloture FOREIGN KEY (fk_user_cloture) REFERENCES llx_user (rowid);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.#sql-2f5_3e2, CONSTRAINT fk_propal_fk_user_cloture FOREIGN KEY (fk_user_cloture) REFERENCES llx_user (rowid))

Error DB_ERROR_1452: ALTER TABLE llx_commande ADD CONSTRAINT fk_commande_fk_user_valid FOREIGN KEY (fk_user_valid) REFERENCES llx_user (rowid);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.#sql-2f5_3e2, CONSTRAINT fk_commande_fk_user_valid FOREIGN KEY (fk_user_valid) REFERENCES llx_user (rowid))

your help will be very appreciated.

I did try the /install/repair.php and restart the upgrade 3.1->3.2 more than once without positive results. Further assistance will be appreciate.
regards,

Gregorio

2

Try to run this

update llx_propal set fk_user_author = null where fk_user_author not in (select rowid from llx_user);
update llx_propal set fk_user_valid = null where fk_user_valid not in (select rowid from llx_user);
update llx_propal set fk_user_cloture = null where fk_user_cloture not in (select rowid from llx_user);
update llx_commande set fk_user_valid = null where fk_user_valid not in (select rowid from llx_user);

then run upgrade again

3

Hello,

I had same trooble and it work fine! Thx Eddy, you’re the boss!

N33

4

Eldy, as usual, worked as a charm. Thanks for your help!!!