pymysql.err.ProgrammingError

1

I get error in verison-15 with custom made doctype

Traceback (most recent call last):
  File "apps/frappe/frappe/website/serve.py", line 20, in get_response
    response = renderer_instance.render()
  File "apps/frappe/frappe/website/page_renderers/list_page.py", line 12, in render
    return super().render()
  File "apps/frappe/frappe/website/page_renderers/template_page.py", line 84, in render
    html = self.get_html()
  File "apps/frappe/frappe/website/utils.py", line 523, in cache_html_decorator
    html = func(*args, **kwargs)
  File "apps/frappe/frappe/website/page_renderers/template_page.py", line 95, in get_html
    self.update_context()
  File "apps/frappe/frappe/website/page_renderers/template_page.py", line 163, in update_context
    data = self.run_pymodule_method("get_context")
  File "apps/frappe/frappe/website/page_renderers/template_page.py", line 223, in run_pymodule_method
    return method(self.context)
  File "apps/frappe/frappe/www/list.py", line 25, in get_context
    context.update(get(**frappe.local.form_dict))
  File "apps/frappe/frappe/utils/typing_validations.py", line 31, in wrapper
    return func(*args, **kwargs)
  File "apps/frappe/frappe/www/list.py", line 32, in get
    raw_result = get_list_data(doctype, txt, limit_start, limit=limit + 1, **kwargs)
  File "apps/frappe/frappe/utils/typing_validations.py", line 31, in wrapper
    return func(*args, **kwargs)
  File "apps/frappe/frappe/www/list.py", line 117, in get_list_data
    raw_result = _get_list(**kwargs)
  File "apps/frappe/frappe/www/list.py", line 239, in get_list
    return frappe.get_list(
  File "apps/frappe/frappe/__init__.py", line 1982, in get_list
    return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
  File "apps/frappe/frappe/model/db_query.py", line 186, in execute
    self.columns = self.get_table_columns()
  File "apps/frappe/frappe/model/db_query.py", line 547, in get_table_columns
    return get_table_columns(self.doctype)
  File "apps/frappe/frappe/model/meta.py", line 73, in get_table_columns
    return frappe.db.get_table_columns(doctype)
  File "apps/frappe/frappe/database/database.py", line 1197, in get_table_columns
    raise self.TableMissingError("DocType", doctype)
pymysql.err.ProgrammingError: ('DocType', 'price')

any one have solution ?

2

Check Database Integrity: Ensure that the database schema is intact and consistent. You can run the following command to check the table definition in the database:

bench --site your_site_name mariadb

Once connected to the MariaDB shell, you can run the following SQL query to describe the ‘price’ table:

DESCRIBE `tabprice`;
3

Thank you for reply @Manav_Mandli

i get this error, any change in “tabprice”

bench --site site1.local mariadb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 43669
Server version: 10.6.16-MariaDB-0ubuntu0.22.04.1 Ubuntu 22.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [_xxxxxxxxxxxxxxx]> DESCRIBE `tabprice`;
ERROR 1146 (42S02): Table '_xxxxxxxxxxxxxxxx.tabprice' doesn't exist
4

you can create the table by running

bench --site site1.local migrate
5

i tried but not working

6

If you have a backup file .sql.gz, try restoring the backup from bench