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
I am stuck at bench update --patch…Getting the errors as attached in the screenshots below.
I am facing almost the same error.
pymysql.err.InternalError: (1054, “Unknown column ‘email_id’ in ‘field list’”)
Still haven’t found a solution.
Okay, Let me check
bench --site all migrate
I have run that now.
It returns same error
Same error here. Stuck in upgrading to v13.
Reported in github https://github.com/frappe/erpnext/issues/25726 - includes a temporary workaround.
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
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
bench setup requirements
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