mysql_exceptions.ProgrammingError: (1146, "Table '1bd3e0294da19198.tabPatient' doesn't exist")

Hi,
Am getting this error after trying a bench migrate command
"iteers_admin@ubuntu:~/frappe-bench$ bench --site site1.local migrate
Migrating site1.local
Executing erpnext.patches.v9_2.remove_company_from_patient in site1.local (1bd3e0294da19198)
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 174, in _run_module_as_main
main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/iteers_admin/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 94, in
main()
File “/home/iteers_admin/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/iteers_admin/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/home/iteers_admin/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/home/iteers_admin/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/iteers_admin/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/iteers_admin/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/iteers_admin/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/home/iteers_admin/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/iteers_admin/frappe-bench/apps/frappe/frappe/commands/init.py”, line 24, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/iteers_admin/frappe-bench/apps/frappe/frappe/commands/site.py”, line 217, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/iteers_admin/frappe-bench/apps/frappe/frappe/migrate.py”, line 31, in migrate
frappe.modules.patch_handler.run_all()
File “/home/iteers_admin/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 29, in run_all
if not run_single(patchmodule = patch):
File “/home/iteers_admin/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 63, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/iteers_admin/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 83, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/home/iteers_admin/frappe-bench/apps/erpnext/erpnext/patches/v9_2/remove_company_from_patient.py”, line 4, in execute
if ‘company’ in frappe.db.get_table_columns(“Patient”):
File “/home/iteers_admin/frappe-bench/apps/frappe/frappe/database.py”, line 823, in get_table_columns
return self.get_db_table_columns(‘tab’ + doctype)
File “/home/iteers_admin/frappe-bench/apps/frappe/frappe/database.py”, line 819, in get_db_table_columns
return [r[0] for r in self.sql(“DESC %s" % table)]
File “/home/iteers_admin/frappe-bench/apps/frappe/frappe/database.py”, line 163, in sql
self._cursor.execute(query)
File “/home/iteers_admin/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 250, in execute
self.errorhandler(self, exc, value)
File “/home/iteers_admin/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 50, in defaulterrorhandler
raise errorvalue
_mysql_exceptions.ProgrammingError: (1146, “Table ‘1bd3e0294da19198.tabPatient’ doesn’t exist”)”
And the browser “Your system is being updated. Please refresh again after a few moments STATUS 503”
Kindly assist
Regards

Please pull the latest update and run bench migrate for the site

Hi Thanks for your reply.I have already done an update. using “bench update”

Does error still persist?

Yes…Its still persist… and on the browser…I get “Your system is being updated. Please refresh again after a few moments”

First run, bench --site site1.local reload-doc healthcare doctype patient
then run bench --site site1.local migrate

1 Like

My procedure:
I first downloaded a backup then cleaned my server.I did a fresh installation of erpnext.After installing erpnext, I dint get to the configuration screen from the browser. I went to the terminal, did restore of the back.Just before I could run the bench migrate command, I visited the site and i could see the interfac i expected although could ot log in due to an error in monthly setup,So i had to run the bench migrate which led to the update error.
I guess that was the right procedure.

Lemmi try this and give you the results.

Hi Saurabh,
Thanks very much
This have solved my problem
First run, bench --site site1.local reload-doc healthcare doctype patient
then run bench --site site1.local migrate
I have struggled with it for over 24hrs.
Regards

Hi Saurabh,
How do i get the desktop icons to appear on switching to the desk?I first have to navigate probably to customer list then click the desk icon for the icons to re appear.Everything else is working fine.

Regard