DC Tables stores invalid data records

Question

DC Tables stores invalid data records

Closed this issue 7 years ago · 4 comments

The DC table saves data even if an error occurs in the edit mask. This leads to invalid data records.

Think about a user is editing an event where a duplicated alias exist.

Title is saved
Exception is thrown then saving the alias
Date is not updated

If an error occurs no data should be saved. This behaviour leads to invalid data records if the user stop working on the data record.

Answer 1 · 2018-03-12T00:42:55.000Z

This is a known limitation of the DC Table. It even creates empty records if you start adding a record. I don't think we can change it without a completely new DC.

Answer 2 · 2018-03-12T07:56:46.000Z

We cannot.

Answer 3 · 2018-03-12T08:24:23.000Z

Couldn't transactions solve the issue since Contao 4.5 uses innodb?

Answer 4 · 2018-03-12T09:07:31.000Z

A transaction would not solve the problem of page reload data updates.