No result defined for action and result input and data import from Excel

In the last five months or so, I have been working on a project since the design and system completion. I have encountered many problems and I have never recorded them yet ~ Recently, my work has been almost done. During the transition from my work to my thesis, I finally took some free time today and sorted it out...

No result defined for action and result input.

Generally, after an action is executed normally, it will be converted to return string. However, if an error occurs during the operation of this action, it will be converted to input by default. There are two common cases (I encountered:

1. File Upload Error

The size of the uploaded file exceeds the limit.

2. The field type does not match the filled form content

This problem occurs today because the type does not match: the background database defines the int type, but when it is entered, it is written as 19.5, resulting in an error.

 

I used to import data in Excel. I have done this before. It is basically good to fill in strings in the database. however, it is not good if the database is of the int type... you need to convert. my method is to convert the data in Excel to the float type, and save the int part to the database.