[go: up one dir, main page]

Click Menu Website: column sale_report.branch_id does not exist

Go To Menu -> Website -> Reporting -> Sales

Error: Flectra Server Error

Traceback (most recent call last):
  File "/opt/flectra/flectra/flectra/http.py", line 646, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/opt/flectra/flectra/flectra/http.py", line 307, in _handle_exception
    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
  File "/opt/flectra/flectra/flectra/tools/pycompat.py", line 87, in reraise
    raise value
  File "/opt/flectra/flectra/flectra/http.py", line 683, in dispatch
    result = self._call_function(**self.params)
  File "/opt/flectra/flectra/flectra/http.py", line 339, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/opt/flectra/flectra/flectra/service/model.py", line 97, in wrapper
    return f(dbname, *args, **kwargs)
  File "/opt/flectra/flectra/flectra/http.py", line 332, in checked_call
    result = self.endpoint(*a, **kw)
  File "/opt/flectra/flectra/flectra/http.py", line 927, in __call__
    return self.method(*args, **kw)
  File "/opt/flectra/flectra/flectra/http.py", line 512, in response_wrap
    response = f(*args, **kw)
  File "/opt/flectra/flectra/addons/website_sale/controllers/backend.py", line 52, in fetch_dashboard_data
    groupby='product_id', orderby='product_uom_qty desc', limit=5)
  File "/opt/flectra/flectra/flectra/models.py", line 1828, in read_group
    result = self._read_group_raw(domain, fields, groupby, offset=offset, limit=limit, orderby=orderby, lazy=lazy)
  File "/opt/flectra/flectra/flectra/models.py", line 1918, in _read_group_raw
    self._cr.execute(query, where_clause_params)
  File "/opt/flectra/flectra/flectra/sql_db.py", line 155, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/flectra/flectra/flectra/sql_db.py", line 232, in execute
    res = self._obj.execute(query, params)
psycopg2.ProgrammingError: column sale_report.branch_id does not exist
LINE 4: ...ND  ("sale_report"."date" <= '2018-1-28')) AND ((("sale_repo... ^
Edited by Parthiv Patel