core
core copied to clipboard
Data Type change is confirmed but not saved
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.
- Confirmation should not confirm if no changes were done.
- Integer columns can not be used in the database. Therefore, no-number functions can be used.