Getting this error, when i run the bench migrate command on my Live server
i have a custom Job Application
here i got error, the form which i was customizing got updated also, with the error existing
but how to resolve this
@Rajat96318 well something is wrong with your datetime field . did you somehow changed the type from date to datetime ?
@bahaou , no their is no datetime field, i changed some field from data to date, and other changes, the problem is on UAT server their was no issue which i pushed 2 days back, but when today i pushed on live it throws this error
It looks like this is what happened:
- You had a field of type “Data” (free text), which among others, contained the value “1/4/2024”.
- You changed the field type to “Date”.
- Now the software complains that your database contains values that do not fit the column’s data type (“1/4/2024” is not a valid date value)
You need to either remove all invalid values or write a migration script that converts the invalid values to valid ones.
1 Like