Exception": "pymysql.err.DataError: (1265, \"Data truncated for column 'varnished' at row 1\")

While saving the changes made to doctype this error comes
can anybody please help me out with this error

It occurs when you have field-type Data and you changed it to Float
the only way to resolve this error is to actually login to mysql select the database and then remove the column or if you have any database administration tool

ALTER TABLE `tabTable Name` DROP COLUMN varnished;
1 Like