Restore database from V7 to V8 error tabSingles Doesn't exists

Install / Update
, ,
1

I backed up database from v7 and tried to restore it to v8 and this is the error I am having on frappe.log.

[ERROR] 2017-07-18 07:38:12,735 | /home/frappe/frappe-bench/apps/frappe/frappe/$
Site: erpnext.vm
Exception in Enqueue Events for Site erpnext.vm
Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py”, line $
if is_scheduler_disabled():
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py”, line $
return not frappe.utils.cint(frappe.db.get_single_value(“System Settings”, $
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 558, in$
tabSingles where doctype=%s and field=%s"“”, (doctype, fieldname))
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 142, in$
self._cursor.execute(query, values)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb$
self.errorhandler(self, exc, value)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb$
raise errorvalue
ProgrammingError: (1146, “Table ‘d56cb677eaab3383.tabSingles’ doesn’t exist”)

[ERROR] 2017-07-18 07:39:42,212 | /home/frappe/frappe-bench/apps/frappe/frappe/$
Site: erpnext.vm

2

What are you trying to do?

The general rule is that restore is restricted to the code ‘version date’ associated with database schema ‘version date’ from where the backup came. Otherwise to restore a backup to a version other than the original will result in all manner of data mapping errors

3

@clarkej I am trying to restore a database to version 8. I backed it up from version 7.

4

My apologies coldfire, my error I am mistaken - please ignore my general rule statement…

Once you restore the database, ‘bench migrate’ will I believe move your database schema and data to ‘synch’ with the latest version

5

@clarkej No problem. Don’t worry. I did bench migrate and it says Internal Server Error. :confused: