frappe / insights

Open source analytics / business intelligence tool (BI)
https://frappe.io/insights
GNU Affero General Public License v3.0
406 stars 199 forks source link

updating insights. #167

Closed sammish closed 11 months ago

sammish commented 11 months ago

Hello Team,

I am facing the following issue while updating insights.

File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 1911, in get_list return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs) doctype = 'Insights Query Variable' args = () kwargs = {'fields': ['name', 'parent', 'variable_value'], 'ignore_permissions': True, 'limit_page_length': 0} frappe = <module 'frappe' from '/home/frappe/frappe-bench/apps/frappe/frappe/init.py'> File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 190, in execute self.columns = self.get_table_columns() self = <frappe.model.db_query.DatabaseQuery object at 0x7f900d43e080> fields = ['name', 'parent', 'variable_value'] filters = None or_filters = None docstatus = None group_by = None order_by = 'KEEP_DEFAULT_ORDERING' limit_start = False limit_page_length = 0 as_list = False with_childnames = False debug = False ignore_permissions = True user = None with_comment_count = False join = 'left join' distinct = False start = None page_length = None limit = None ignore_ifnull = False save_user_settings = False save_user_settings_fields = False update = None add_total_row = None user_settings = None reference_doctype = None run = True strict = True ignore_ddl = False parent_doctype = None pluck = None File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 533, in get_table_columns return get_table_columns(self.doctype) self = <frappe.model.db_query.DatabaseQuery object at 0x7f900d43e080> File "/home/frappe/frappe-bench/apps/frappe/frappe/model/meta.py", line 75, in get_table_columns return frappe.db.get_table_columns(doctype) doctype = 'Insights Query Variable' File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 1178, in get_table_columns raise self.TableMissingError("DocType", doctype) self = <frappe.database.mariadb.database.MariaDBDatabase object at 0x7f900e07ef50> doctype = 'Insights Query Variable' columns = [] pymysql.err.ProgrammingError: ('DocType', 'Insights Query Variable')

nextchamp-saqib commented 11 months ago

I have pushed a fix. Update to latest develop and check

sammish commented 11 months ago

Noted Thanks