Skip to Content
This question has been flagged
1 Reply
5234 Views
Avatar
Maximilien PETITGENET

Hello,

after upgrading my Debian from 8 to 10 with no problem, my Odoo 8.0 is now stating this each time I try to access a quotation (no error with the admin account)

AccessError
Sorry, you are not allowed to access this document. Vous pouvez contacter votre administrateur système si vous pensez qu'il s'agit d'une erreur.
(Modèle de document: product.pricelist)
I can see the total amount of the quote, but not the articles.

Weird thing : I can access articles and pricelists... (but not quotes !) And I can’t create a quote, same error message.


I have tried to set every "product.pricelist" access rights to read/write for all accounts, doesn’t change a thing.

Yesterday, no problem with any account.

Could you please help ?

Avatar
Discard
Bernardo

Hello! were you able to solve your problem? I'm getting the same error but cannot find a solution

Avatar
Éloi Rivard
Best Answer

I just encountered this issue with Odoo 9 after upgrading from Ubuntu 18.04 to 20.10.

To debug this, I manually executed the failing SQL request.

I discovered a very strange bug, the product.pricelist value in ir_model.model had an unvisible character (maybe some \n or \r?), that was preventing this line to work: ' WHERE m.model = %s '

The solution was to edit the ir_model.model field and manually rewrite the string product.pricelist (with tools like adminer or the postgresql command line). I suppose postgresql was tolerating this strange characters before the upgrade, but maybe the default configuration has changed after the upgrade and those characters broke the odoo requests. The corrupted data cloud be in the database for eons, but just broke at this upgrade.

Avatar
Discard
Yoshi Tashiro

Just came across this issue in a database (Odoo 12, PostgreSQL 9.6) and I was clueless until I saw this answer. Thank you! Very weird indeed. It just happened out of the blue.