Why I cant set duration field to zero instead it shows an error pymysql.err.DataError: (1366, "Incor

[erp_jawahar]

Hello Everyone,
when I type non-zero values in the duration field, it shows an empty value, but when I select the value from the dropdown, the value is shown and saved.
When I update non-zero values to zero values by selecting a value from the dropdown or type zero in that duration field it shows an error:
pymysql.err.DataError: (1366, “Incorrect decimal value: ‘’ for column _5f4f1ee02e32187a.tabdurationdata.durate_time at row 1”)
And also another error also occurs
pymysql.err.DataError: (1265, “Data truncated for column ‘durate_time’ at row 1”)

Anyone have solution for this?

[NCP]

Delete the field and again recreate the field.

If you add custom field from the customize form then trim table.

[erp_jawahar]

still facing the same issues

[NCP]

Last option:

Please check the reference:

Error pymysql 1265 Data truncated

Hi @umarless, I think, that for, remove the field (net_area) from the database. Please apply the command. bench --site [sitename] mariadb alter table `tabTasmeem Projects` drop column `{net_area}`; Please set your Doctype name in the tabYour DocType query and field name. Then exit from the MariaDB. Then apply another command like bench --site [sitename] clear-cache bench --site [sitename] migrate Then again create the new field and save it form. Maybe, the problem will solve. I hope th…

[erp_jawahar]

Not working in duration field