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.

1

Why do I get AccessError on Document type: email.template, Operation: read with administrator account?

By
Yenthe
on 10/31/14, 5:07 AM 1,015 views

Hi everybody

I've done some personal translations in Odoo and after I saved one something 'glitched' and sent me to the login page.
Ever since that happend I get the following error message:


The message only appears when I search on the translated field email.template,body_html under translated expressions.
Can anybody tell me why this happens or how I can fix this? I need to access that translation again.

Yenthe

0

Ludo - Neobis

--Ludo - Neobis--
2387
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--

Developer

Ludo - Neobis
On 11/5/14, 3:28 AM

If you have access to the database, that would be your best bet I suppose. The translations can be found under ir_translate, where you can search for the translated term. Just throw the translated record away and see what that does for you.

Do you mean to open the database through pgadmin or through Odoo? Because through Odoo it will not work anyways. Could you explain me in big lines how to find and throw away the record that is troubling me?

Yenthe
on 11/5/14, 4:14 AM

That is indeed what I meant. This is under the assumption that the said translation is indeed the root cause of the problem. Once connected to your database (for example usig pgadmin), do a select query on the ir_translate table. For example: "select * from ir_translate order by id desc limit 50" (limit in case you know the translation was part of the 50 last records you created). Find the presumable guilty record's id and run the following query; delete from ir_translate where id = $your_id_here;.

Ludo - Neobis
on 11/5/14, 4:24 AM

What would be the easiest way to do this if you do not have pgadmin on your Ubuntu but only have postgreSQL 9.3 on the instance then? If I know this I'll try it out and then I'll accept the answer as this *should* fix my problems. Could you also tell me the cause of why this triggers the AccessError?

Yenthe
on 11/5/14, 4:56 AM

You can always use "psql" on the command line. This is default (I believe) and comes with the postgres package on Ubuntu. You can enter the same SQL commands in psql as you would in pgadmin.

Ludo - Neobis
on 11/5/14, 7:16 AM

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/31/14, 5:07 AM
Seen: 1015 times
Last updated: 3/16/15, 8:10 AM