Error while update v7.1 to v9

do u mean that there is a problem with data in item doctype ??

For example this patch https://github.com/frappe/erpnext/blob/develop/erpnext/patches/v8_7/make_subscription_from_recurring_data.py

modifies oodles of existing documents and reinserts them.

The ValidationError points to a problem with some of them, to be checked and fixed!?

I’m sorry but i’m confused . What should i do ??

Maybe explain your confusion?

sorry i was replying for that issue

My apologies Mahmoud_Ghoneem

I only realize now that likely you are in a hosted environment are not in control here.

For most of us here this is a learning :wink:

1 Like

Try update now @eitadmin

This fixed a patch that failed to check for null date fields

[fix] check for null date fields by saurabh6790 · Pull Request #11334 · frappe/erpnext · GitHub

please help to resolve this error while updating…

raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1048, “Column ‘is_custom’ cannot be null”)

eitadmin : Try this, it work for me.

bench mysql
ALTER TABLE tabDocPerm DROP COLUMN is_custom;
Exit sql