Skip to Content
Menu
This question has been flagged
2 Replies
1820 Views

Hello,

Initially I installed also Inventory to Odoo 10.0. Created customers, products, vendors etc... and tested some time.

Then I decided that the inventory part is too complicated for my business and I uninstalled it.

After that when entering into some product for modification, it gives odoo server error:

Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 638, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 675, in dispatch result = self._call_function(**self.params) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 331, in _call_function return checked_call(self.db, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/service/model.py", line 119, in wrapper return f(dbname, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 324, in checked_call result = self.endpoint(*a, **kw) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 933, in __call__ return self.method(*args, **kw) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 504, in response_wrap response = f(*args, **kw) File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 878, in call_kw return self._call_kw(model, method, args, kwargs) File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 870, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/usr/lib/python2.7/dist-packages/odoo/api.py", line 681, in call_kw return call_kw_multi(method, model, args, kwargs) File "/usr/lib/python2.7/dist-packages/odoo/api.py", line 672, in call_kw_multi result = method(recs, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 3012, in read values[name] = field.convert_to_read(record[name], record, use_name_get) File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 5191, in __getitem__ return self._fields[key].__get__(self, type(self)) File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 869, in __get__ self.determine_value(record) File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 980, in determine_value self.compute_value(recs) File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 935, in compute_value self._compute_value(records) File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 926, in _compute_value getattr(records, self.compute)() File "/usr/lib/python2.7/dist-packages/odoo/addons/sale/models/product_template.py", line 27, in _sales_count product.sales_count = sum([p.sales_count for p in product.product_variant_ids]) File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 869, in __get__ self.determine_value(record) File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 980, in determine_value self.compute_value(recs) File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 935, in compute_value self._compute_value(records) File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 926, in _compute_value getattr(records, self.compute)() File "/usr/lib/python2.7/dist-packages/odoo/addons/sale/models/product_product.py", line 17, in _sales_count for group in self.env['sale.report'].read_group(domain, ['product_id', 'product_uom_qty'], ['product_id']): File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 1923, in read_group result = self._read_group_raw(domain, fields, groupby, offset=offset, limit=limit, orderby=orderby, lazy=lazy) File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 2013, in _read_group_raw self._cr.execute(query, where_clause_params) File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 141, in wrapper return f(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 218, in execute res = self._obj.execute(query, params)ProgrammingError: relation "sale_report" does not existLINE 3: FROM "sale_report" LEFT JOIN "product_product" a... ^


Is there any solution how to fix this?

Avatar
Discard
Author Best Answer

Hi. Thank you. It helped. Still I'm sometimes getting this kind of Odoo server error:

Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 638, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 675, in dispatch result = self._call_function(**self.params) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 331, in _call_function return checked_call(self.db, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/service/model.py", line 119, in wrapper return f(dbname, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 324, in checked_call result = self.endpoint(*a, **kw) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 933, in __call__ return self.method(*args, **kw) File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 504, in response_wrap response = f(*args, **kw) File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 820, in search_read return self.do_search_read(model, fields, offset, limit, domain, sort) File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 842, in do_search_read offset=offset or 0, limit=limit or False, order=sort or False) File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 4676, in search_read result = records.read(fields) File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 3012, in read values[name] = field.convert_to_read(record[name], record, use_name_get) File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 5191, in __getitem__ return self._fields[key].__get__(self, type(self)) File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 869, in __get__ self.determine_value(record) File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 980, in determine_value self.compute_value(recs) File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 935, in compute_value self._compute_value(records) File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 926, in _compute_value getattr(records, self.compute)() File "<string>", line 2, in _kanban_dashboard File "/usr/lib/python2.7/dist-packages/odoo/api.py", line 361, in loop result = [method(rec, *args, **kwargs) for rec in self] File "/usr/lib/python2.7/dist-packages/odoo/addons/account/models/account_journal_dashboard.py", line 15, in _kanban_dashboard self.kanban_dashboard = json.dumps(self.get_journal_dashboard_datas()) File "/usr/lib/python2.7/dist-packages/odoo/addons/account/models/account_journal_dashboard.py", line 208, in get_journal_dashboard_datas 'sum_waiting': formatLang(self.env, sum_waiting or 0.0, currency_obj=self.currency_id or self.company_id.currency_id), File "/usr/lib/python2.7/dist-packages/odoo/tools/misc.py", line 1150, in formatLang res = lang_obj.format('%.' + str(digits) + 'f', value, grouping=grouping, monetary=monetary) File "/usr/lib/python2.7/dist-packages/odoo/addons/base/res/res_lang.py", line 256, in format formatted = decimal_point.join(parts)UnicodeDecodeError: 'ascii' codec can't decode byte 0xc2 in position 1: ordinal not in range(128)

How could I fixt this? Clean database install is not a good idea, as quit much data is already inserted.

Regards, A.

Avatar
Discard
Best Answer

Try to update the sales module.

Avatar
Discard