Instance migration issue from v14 to v15

I have migrated an instance from v14 to v15 with all the commands which need to be run in migration but when I run the command

bench --site sitename migrate.

It gives me an error:

Updating DocTypes for frappe : [========================================] 100%
Updating DocTypes for erpnext : [======== ] 20%Failed to alter schema using query: ALTER TABLE tabSales Invoice ADD COLUMN update_outstanding_for_self int(1) not null default 1, ADD COLUMN subscription varchar(140)

After I run this command

bench --site sitename migrate --skip-failing

the issue persist, any help or suggestion please

Versions:
frappe 15.36.0 version-15
erpnext 15.28.0 version-15

@NCP @revant_one @rmehta

Any help in this regard, what am I doing wrong in this migration process

Hi,

If we may know the operating environment and the commands used to perform the upgrade it may be helpful.

Ubuntu 22.04

After restoring backup, I ran this command

bench --site sitename migrate --skip-failing

Generally, to upgrade to 15 make sure the pre-requisits are up to date, make a backup and run the command:

bench switch-to-branch --upgrade version-15 frappe erpnext

Restoring the update shouldn’t be needed.

A new server already have an apps updated version

Try: bench update --patch or bench update --reset. if they haven’t been tried already.

Thanks, I will let you know the result

@Zaryabqureshi Please first create the site in version-14 and restore your backup in version-14 site then please follow this documentation then your query is resolved.

documentation link : How to Upgrade ERPNext from Version 14 to Version 15 - Code with Karani

Brother, I have a separate server of version15, I don’t want to do updation in my current version14 server.

That is the reason I’m migrating to v15 server as per the client request.

@Zaryabqureshi so first you can change the version15 to version14 then upgrade as per my above instructions it will be worked directly you can not upgrade the version you can followup these step then worked

1 Like

As per your suggestion, now I’m getting this error.

(1118, ‘Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs’)