I am running VM instances on GCP because they are easy to install quickly. After importing all of the data I need on the system, I ran a backup on the instance before testing some erpnext features and functions. After some days of testing I realized I had made mistakes and wanted to start over so I created a fresh ERPnext instance with a new install on GCP using these steps:
NOTE: I did NOT login to the fresh system with the Administrator to do an initial startup. I just began the restore process immediately.
Once the fresh erpnext system was installed I restored the backup from the beginning of the last instance with all of the imported data already done. Please note that when following the Step by Step instructions linked above on GCP, erpnext is installed in the /home/frappe folder and no login credentials are available for the frappe user. So, in some places I have to use “sudo” to run commands because frappe is not installed in the default debian users home folder (/home/erp_jmi), it exists in the frappe home folder instead.
The instruction I had to use to run restore was:
sudo bench --force --site site1.local restore /home/erp_jmi/20170809_125913_database.sql
It asked for my sql admin password, which I typed in and a few minutes later I got back my prompt so it appeared that all went well with the restore. I also restored all the files that were once in the frappe-bench/sites/site1.local/public/files folder as well.
I then used the command “sudo bench restart” to restart the bench after the database and files restore. When that was finished, I opened a fresh browser and typed in the ip address of my erpnext server.
I was presented with the normal login screen. I used one of the users credentials from the restored database to log into the system. It indicated that the login was successful, but it could not take me to the desk environment. Instead it posted the following error and nothing else worked:
Does anyone have any idea how to correct this?
Thanks - BKM