pymysql.err.DataError:(1265, "Data truncated for column 'active' at row 2")

[Syed_Anas]

can anyone explain what this error is about? and how to resolve this

[vijaywm]

You could be passing a wrong data type value for the active field… if it is happening in migrate, the existing data in active column may have some incompatible value…
check datatype of active column
Make sure you are passing correct value
Check existing values in db

[NCP]

Adding @vijaywm answer, if you are saving changes to doctype then an error appear or create a field and then face issue then follow the below 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…

[Syed_Anas]

Yeah, I have checked db it was a datatype error.
Thanks for the response.