core icon indicating copy to clipboard operation
core copied to clipboard

Data Type change is confirmed but not saved

Open DiegoJArg opened this issue 7 years ago • 3 comments

Hi people,

I have one field "minutes lost" that I is meant to be ADD'd afterwards in excel, therefore in the database it must be an integer. But I found that it was set up as string in the column "Sort As" and in the "Data Type". I am not sure if this was my mistake, but changing it to "Number" didn't change the database structure while the message was "The changes to your fields have been saved".

Anyway, I have edited the structure by myself with phpmyadmin and changed to INT with no data being lost. Now after submitting in formtools a new line is added but no data is stored. Damn !!

Then I tried back to setting it up to VARCHAR(255). And the form is now operational again.

I find that this 2 bugs.

  1. Confirmation should not confirm if no changes were done.
  2. Integer columns can not be used in the database. Therefore, no-number functions can be used.

DiegoJArg avatar Jun 18 '18 19:06 DiegoJArg