I am using ERPNext on Oracle Virtualbox on Windows 7. After upgrading to V12 I am receiving Internal Server Error.
The upgrade went fine but when I Bench update --patch it gives me an error
“Uknown column 'total_taxes_and_charges in 'where clause”
and now I cannot access erpnext anymore. I have 4 months data with no backup.
I would suggest copying the files in the backups folder to another location. Your instance is probably salvageable, with a bit of work. I would start by upgrading the Ubuntu to 18 if it isnt already. I would also upgrade yarn and nodejs to latest. Then try , from the ~/frappe-bench folder: bench migrate-env python3.6 then bench setup requirements. If that all goes smoothly try bench migrate again.
I tried
sudo apt update
sudo apt upgrade
sudo reboot (waited for 5 minutes but nothing happened) so I powered off the VM and started it again.
When I typed sudo do-release-upgrade I got the following
Can’t say whays going on with it, it appears that it was not shut down gracefully and damage may have occurred. Can you allocate a bit more disk space to the VM and try booting again. If your database backup is intact it might be easier to set up a fresh instance and restore it once everything is up to date.
I think this is what I am gong to do.
Can I install a fresh instance while keeping this whole thing so I will have 2 VMs this way I make sure my data transfer correctly for discarding this one. Also how do I copy my backup to the new instance
If the backup is downloaded to a local drive it can be uploaded to the new instance , if it was not transferred out of the VM the VM will have to be repaired and booted in order to retrieve it.
Try allocating more disk space to the first VM and booting it. If it does not boot someone more familiar with Virtualbox will have to say how to repair the filesystem if it is corrupted
Hi @smino sorry I might have given you wrong information. The VM is booting. It is giving me the previous msg but it does boot and I have the backup. I also installed a second instance on the vm which is working fine.
Now I need to transfer the backed up site from the old instance to the new one. How can I do that