Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

"ProgrammingError: relation "sale_report" does not exist" while adding or editing products in odoo 10

By
Bilal Janjua
on 10/13/16, 2:03 PM 297 views

Hi guys, 

I am new to ODOO Platform and barely started on ODOO 10. 

I imported 1000 + products yesterday and was able to format them with any issues. I was playing with user rights and now i cannot edit or even add a new product.


This is the error message i get.

(Any Idea what have gone wrong) ?

Odoo Server Error

Traceback (most recent call last): File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\http.py", line 638, in _handle_exception File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\http.py", line 675, in dispatch File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\http.py", line 331, in _call_function File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\service\model.py", line 119, in wrapper File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\http.py", line 324, in checked_call File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\http.py", line 933, in __call__ File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\http.py", line 504, in response_wrap File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\addons\web\controllers\main.py", line 853, in call_kw File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\addons\web\controllers\main.py", line 845, in _call_kw File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\api.py", line 681, in call_kw File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\api.py", line 672, in call_kw_multi File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\models.py", line 2995, in read File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\models.py", line 5171, in __getitem__ File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\fields.py", line 860, in __get__ File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\fields.py", line 969, in determine_value File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\fields.py", line 924, in compute_value File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\fields.py", line 916, in _compute_value File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\addons\sale\models\product_template.py", line 27, in _sales_count File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\fields.py", line 860, in __get__ File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\fields.py", line 969, in determine_value File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\fields.py", line 924, in compute_value File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\fields.py", line 916, in _compute_value File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\addons\sale\models\product_product.py", line 17, in _sales_count File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\models.py", line 1911, in read_group File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\models.py", line 2001, in _read_group_raw File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\sql_db.py", line 141, in wrapper File "C:\Program Files (x86)\Odoo 10.0rc1c\server\odoo\sql_db.py", line 218, in execute

ProgrammingError: relation "sale_report" does not exist

LINE 3: FROM "sale_report" LEFT JOIN "product_product" a... ^

0
Eric alesh
On 10/28/16, 5:20 AM

Solved  by just click upgrade on the Sale Module  from setting>Apps>Installed> Sale Module and click Upgrade where you have the option of upgrade or unintsall

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 10/13/16, 2:03 PM
Seen: 297 times
Last updated: 10/28/16, 5:20 AM