OperationalError
pymysql.err.OperationalError: (1932, “Table ‘_1efb0bcd43037813.tabDocType’ doesn’t exist in engine”)
It looks like frappe is not installed correctly. What commands have you ran so far?
How did you install Frappe? Do you have any sites functioning?
Initially, it was working, but when I tried to install ERPNext on a new site, this error occurred. The error message indicated that the site was not properly installed, so I manually deleted it from the files. However, when I tried to run the previously working site, it also threw this error.
For the site that was originally working, run the following commands:
bench --site your.site.com mariadb
At the mariadb prompt run the following:
show tables;
also try:
cd <your_bench_directory>
ls -l apps
Do you find:
frappe
payments
erpnext
prashant@Prashant:~/frappe-bench$ ls -l apps
total 24
drwxr-xr-x 5 prashant prashant 4096 Apr 2 10:40 airplane_mode
drwxr-xr-x 4 prashant prashant 4096 Apr 2 11:03 airport_shop
drwxr-xr-x 5 prashant prashant 4096 Apr 2 12:22 airport_shop_management
drwxr-xr-x 6 prashant prashant 4096 Apr 3 14:03 erpnext
drwxr-xr-x 9 prashant prashant 4096 Mar 26 13:10 frappe
drwxr-xr-x 5 prashant prashant 4096 Mar 26 13:38 rental
+-------------------------------------+
| Tables_in__1efb0bcd43037813 |
+-------------------------------------+
| __Auth |
| __UserSettings |
| __global_search |
| flight_passenger_id_seq |
| tabAbout Us Team Member |
| tabAccess Log |
| tabActivity Log |
| tabAddress |
| tabAddress Template |
| tabAirline |
| tabAirplane |
| tabAirplane Flight |
| tabAirplane Ticket |
| tabAirplane Ticket Add-Ons |
| tabAirplane Ticket Add-on Item |
| tabAirplane Ticket Add-on Type |
| tabAirport |
| tabAmended Document Naming Settings |
| tabAssignment Rule |
| tabAssignment Rule Day |
| tabAssignment Rule User |
| tabAuto Email Report |
| tabAuto Repeat |
| tabAuto Repeat Day |
| tabBlock Module |
| tabBlog Category |
+-------------------------------------+