ProgrammingError: relation "account_invoice_report" does not exist
Created by: mehnihma
Hi, to report problem that I have
Impacted versions:
- Odoo 8.0-20150703
- Ubuntu server 14.04
Steps to reproduce:
- Installed module Invoice Date Time
- Invoice shows date and time now
- Click on sales error shows
- Cannot add new clients or see old ones
- Unistalling module and reinstalling sales module fixes problem
Current behavior:
- Invoice shows date and time but sales module does not work
Expected behavior:
- Sales module should work and date and time on invoice should be on invoice
Error:
Odoo Server Error Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 537, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 574, in dispatch result = self._call_function(**self.params) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 310, in _call_function return checked_call(self.db, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 113, in wrapper return f(dbname, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 307, in checked_call return self.endpoint(*a, **kw) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 803, in call return self.method(*args, **kw) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 403, in response_wrap response = f(*args, **kw) File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 884, in search_read return self.do_search_read(model, fields, offset, limit, domain, sort) File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 905, in do_search_read request.context) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 908, in proxy result = meth(cr, request.uid, *args, **kw) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5144, in search_read result = self.read(cr, uid, record_ids, fields, context=read_ctx) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3139, in read result = BaseModel.read(records, fields, load=load) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper return new_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3174, in read self._read_from_database(stored, inherited) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper return new_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3352, in _read_from_database res2 = self._columns[f].get(cr, self._model, ids, f, user, context=context, values=result) File "/usr/lib/python2.7/dist-packages/openerp/osv/fields.py", line 1466, in get result = self._fnct(obj, cr, uid, ids, name, self._arg, context) File "/usr/lib/python2.7/dist-packages/openerp/addons/sale/sales_team.py", line 39, in _get_invoices_data values = self.__get_bar_values(cr, uid, obj, created_domain, ['price_total', 'date'], 'price_total', 'date', context=context) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/addons/sales_team/sales_team.py", line 58, in __get_bar_values group_obj = obj.read_group(cr, uid, domain, read_fields, groupby_field, context=context) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 2140, in read_group cr.execute(query, where_clause_params) File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 158, in wrapper return f(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 234, in execute res = self._obj.execute(query, params) ProgrammingError: relation "account_invoice_report" does not exist LINE 3: FROM "account_invoice_report" ^
How to fix this?
Thanks