i have restore a database then run this command
bench --site dev-erp.example.org migrate --skip-failing
after run this command I got an error!
Migrating dev-erp.example.org
Updating DocTypes for frappe : [========================================] 100%
Updating DocTypes for erpnext : [== ] 7%
There was an issue while migrating the DocType: Sales Invoice
File “/home/frappe/frappe-bench/env/lib/python3.9/site-packages/pymysql/cursors.py”, line 310, in _query
conn.query(q)
File “/home/frappe/frappe-bench/env/lib/python3.9/site-packages/pymysql/connections.py”, line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/home/frappe/frappe-bench/env/lib/python3.9/site-packages/pymysql/connections.py”, line 775, in _read_query_result
result.read()
File “/home/frappe/frappe-bench/env/lib/python3.9/site-packages/pymysql/connections.py”, line 1156, in read
first_packet = self.connection._read_packet()
File “/home/frappe/frappe-bench/env/lib/python3.9/site-packages/pymysql/connections.py”, line 725, in _read_packet
packet.raise_for_error()
File “/home/frappe/frappe-bench/env/lib/python3.9/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “/home/frappe/frappe-bench/env/lib/python3.9/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.DataError: (1406, “Data too long for column ‘po_no’ at row 32022”)
I Have applied this
ALTER TABLE tabSales Invoice Modify column po_no longtext;
mysqlcheck -u root -p --auto-repair --check --all-databases