giowck / symphytum

Symphytum Personal Database Software
https://git.io/fxdRt
Other
413 stars 63 forks source link

Deleting a field results in "invalid_column" #125

Closed joshirio closed 4 years ago

joshirio commented 4 years ago

Some users kept reporting an issue which was difficult to reproduce, for example #92.

After some investigation I found the cause and that this is a critical bug that could lead to data loss, so once fixed I'll prepare an update to get the fix out as soon as possible.

The bug appears when there are more than 10 fields and you delete for example field 1 (column id 1) all columns between 10 and 19 are deleted too because the pattern which should match only column_1 matches all other columns that contain a 1 in the id.

Please don't delete any fields until version 2.6 is out.