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.
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 v13 upgrade: unknown column 'email_id' in 'field list' · Issue #25726 · frappe/erpnext · GitHub - 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
@Fadil_Siddique Thanks it worked for me with no issues.
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
Did you followed the same steps to update?
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 ?