A language cannot be deleted if it is referenced by an order

[roadster31]

When trying to delete an language, the following error is displayed if this language is referenced in the order table.

Propel\Runtime\ActiveQuery\ModelCriteria::delete is unable to delete.

The exception cause is :

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (thelia2.order, CONSTRAINTfk_order_lang_idFOREIGN KEY (lang_id) REFERENCESlang(id))

We have to remove this constraint (which, BTW, doesn't exists in the customer table).

[lovenunu]

We already talked about this. I think that the solution is to create an order_lang table to always keep all the data of every order.

[roadster31]

:+1:

[lovenunu]

Ohhh, I already posted an issue for that Oo #644 Let's close one of the two issues :)

[bibich]

This issue is partially fixed by #1832 Language has now two flag active and visible to display it in back and front. So we're not obliged to delete it to hide it in the front.

[roadster31]

I dot not agree to close this issue. A Thelia admin should be able to completely delete a language. @lovenunu gave the proper solution to this problem.

[anoziere]

Should implement a table order_lang, like #964

[lopes-vincent]

Same issue as #1145, the order table should not have any foreign keys on a table that does not belong to the order.