ERPNext v12 to v13 migration issue

[jabir.elat]

Hello team,
I am trying to update ERPNext v12 to v13.
I am getting error while running…bench update —patch.
First of all have made backup of all sites from previous bench.
Then i freshly installed frappe and erpnext v12 and restored the backed up data.
Then tried to update to v13 I followed this link I want to update my erpnext from Version 12 to erpnext Version 13 - #4 by palashjhabak
I am stuck at bench update --patch…Getting the errors as attached in the screenshots below.

[Tech_Hack_IT]

ref,

How To Update Erpnext 12 to 13.0 Beta Version

[deatram]

I am facing almost the same error.
mine is

pymysql.err.InternalError: (1054, “Unknown column ‘email_id’ in ‘field list’”)

pymysql.err.InternalError: (1054, "Unknown column 'email_id' in 'field list'") during update

Hello All I am upgrading from version 12 to version 13 beta My current version is ERPNext: v12.18.0 (version-12) Frappe Framework: v12.15.0 (version-12) When I upgrade I get the following error pymysql.err.InternalError: (1054, “Unknown column ‘email_id’ in ‘field list’”) Here is the traceback Executing erpnext.patches.v13_0.update_member_email_address in site1.local (1bd3e0294da19198) Traceback (most recent call last): File “/usr/local/lib/python3.7/runpy.py”, line 193, in _run_modul…

Still haven’t found a solution.
Any progress?

[jabir.elat]

Okay, Let me check

[trentmu]

bench --site all migrate

might help

[deatram]

I have run that now.
It returns same error

[rasos]

Same error here. Stuck in upgrading to v13.

Reported in github v13 upgrade: unknown column 'email_id' in 'field list' · Issue #25726 · frappe/erpnext · GitHub - includes a temporary workaround.

[Fadil_Siddique]

Following steps worked for me, most of the errors are because of missing certain fields and modules in different versions of erpnext 12. use bench migrate --skip-failing after switching branch from v12 to v13.

Upgrade The System

sudo apt update
sudo apt upgrade

Update node-npm-yarn

curl -fsSL https://deb.nodesource.com/setup_10.x| sudo -E bash -
sudo apt-get install -y nodejs
sudo npm install -g npm
sudo npm install -g yarn

Upgrade Frappe Bench

sudo -H pip3 install --upgrade frappe-bench

Update

bench setup requirements
bench update

Switch Branch and Upgrade

bench switch-to-branch version-13 frappe erpnext --upgrade
bench migrate --skip-failing
Bench update --reset
bench update --patch

Update and build bench

bench update
bench build

[chandrubiradar]

@Fadil_Siddique Thanks it worked for me with no issues.
Thanks alot.

[Tech_Hack_IT]

Cannot proceed with update: You have local changes in app "frappe Erpnext" that are not committed.

[Rajesh2]

Getting below error for bench update command
/home/bitnami/apps/erpnext/htdocs/frappe-bench# bench update
WARN: bench is installed in editable mode!

This is not the recommended mode of installation for production. Instead, install the package from PyPI with: `pip install frappe-bench`

Backing up sites...
Backup failed for Site erpnext. Database or site_config.json may be corrupted

[chandrubiradar]

Did you followed the same steps to update?

[Abdullah_A_Ansari]

I have v12 on a VM. I have a new V13 on a separate vm. How do i migrate the data from v12 to v13 ?