Skip to Content
This question has been flagged
superuseradminodoo12
6 Replies
11179 डेटा देखने का तरीका
अवतार
Víctor

A client decided to delete the superadmin user from their Odoo 12 installation, so they're now receiving errors. They created a new user and linked the "Administrator" partner to that user.

For example, when installing the Leaves module they get errors like:

KeyError: ('ir.model.data', <function IrModelData.xmlid_lookup at 0x7f6c422089d8>, 'base.user_admin') 
ValueError: <class 'ValueError'>: "External ID not found in the system: base.user_admin" while evaluating
"[(4, ref('base.user_root')), (4, ref('base.user_admin'))]"
ValueError: External ID not found in the system: base.user_admin

I have tried creating a new user and changing its ID to 2 directly in the res_users table trying to replicate the deleted user, but it doesn't seem to have any effect.

Where does Odoo define which user is the super user if it's not hardcoded by id? Where should I look/what should I change? Any ideas?

अवतार
खारिज करें
अवतार
Víctor
लेखक Best Answer

I had to add a new entry in the ir.model.data table with name user_admin and referencing my new user id to fix it (base module, res.users model, res_id 2).


अवतार
खारिज करें
Bowler, Marlo Jooste

Good day @Victor.
I am trying to install an addon but running into the same failure as per above. I subsequently need to restore the superadmin user as per the comment here.

I am running Odoo 16.0-20241124 (Community Edition).

Pardon my ignorance, but could you please provide me with the detailed steps (sql query) that I need to run to update the table?

अवतार
Cristian Camilo Rojas Capera
Best Answer

I thank you for your help. We were able to solve that problem with your solution

अवतार
खारिज करें
अवतार
Dominik Lisiakiewicz
Best Answer

Hello, have the same issue. Can you provide some more information how to fix it? 

अवतार
खारिज करें
अवतार
Vu Ha
Best Answer

Thanks, Victor

I got the same problem on Odoo 13 and fixed that following your suggestion

अवतार
खारिज करें
अवतार
Hilar Andikkadavath
Best Answer

Okay, add your new user in the following groups. 

ref('base.user_root')), (4, ref('base.user_admin'), don't forget to grant all superaccess.
अवतार
खारिज करें
अवतार
Amit Dodiya
Best Answer

External id is required for this user as it is used at many places. You can try by updating external_id for that new user to base.user_admin.

अवतार
खारिज करें
Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
How can hide super user Solved
administration hide superuser admin
अवतार
अवतार
1
मई 23
12215
Survey User
odoo12
अवतार
1
अप्रैल 26
4743
Odoo Mail Sending Limit Solved
odoo12
अवतार
अवतार
अवतार
2
दिस॰ 23
19054
(Document type: Invoice, Operation: write) - (Records: [], User: 2)
odoo12
अवतार
0
अक्तू॰ 23
33
Error while importing data in Odoo12: An unknown issue occurred during import (possibly lost connection, data limit exceeded or memory limits exceeded)
odoo12
अवतार
अवतार
अवतार
अवतार
3
अक्तू॰ 23
790