Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
โปรเจกต์
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

[SOLVED]Error while opening preferences

filestore postgresql preferences restoredb

2 ตอบกลับ

7556 มุมมอง

Jignesh Mehta

Hello,

I have restore a database. and after upgrade all the modules.

But when i open any user's preferences, below error is occurred.

Error :-

Odoo Server Error

Traceback (most recent call last):
 OSError:
 [Errno 2] No such file or directory: 
'/home/user/.local/share/Odoo/filestore/fusion_final_27_backup/97/97c150428621c8ab734730f2e949dc5fe29c14

Update :-

ProgrammingError: relation "ir_model_data_model_res_id_index" already exists

Solved :-

Delete all the attachment from database through pgadmin and upgrade all modules.

Thanks in advance.

Jérémy Kersten (jke)

It'is probably asset from web client,

You can also delete your attachment where name contains ".assets_"*.JS & *.css

There will be regenerated.

Jignesh Mehta

ผู้เขียน

Hello jke, can't understand what are you saying. Can you please elaborate? Thanks,

Jérémy Kersten (jke)

After some reflexion, if it is only in preference and not in all the web client, that proabably not a problem of assets.
Assets are frequently regenerated, so it's not impossible that between your db dump and your filestore dump, the file is no more present. In this case, you can in the databse remove the ir_attachment with name .assets_ (eg: web.asset_frontend.js' ) to force Odoo to geneate a new assets...

Jérémy Kersten (jke)

Like suggest @bipin said, did you restore your filestore ?

Bipin rathod

Hello Jignesh,

/home/user/.local/share/Odoo/filestore/fusion_final_27_backup/97/97c150428621c8ab734730f2e949dc5fe29c14

you can see that, the error comes from filestore, it means you have restored the DB but didn't put your filestore directory in your odoo directory, please copy your filestore and put it on odoo directory it will works.

Hope, this will help you.

Jignesh Mehta

ผู้เขียน

Hello Bipin, filestore folder is already in the odoo directory.

Bipin rathod

Is that, same odoo source ? because, if you are using the same source of odoo, filestore will be same, but if you changed the source, you need to copy your old filestore to new source.

Jignesh Mehta

ผู้เขียน

Hello Bipin, All the filestore copy and paste in odoo directory. But when go for upgrade all, the error will occurred which is in my updated question.

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
How to Recover database from Odoo 13.0>Postgresql>data database postgresql restoredb	0 เม.ย. 22	3805
How to Recreate Odoo Filestore from a .dump File? filestore restoredb psql Odoo18.0	1 พ.ค. 25	3539
Database Backup with fielstore data แก้ไขแล้ว database postgresql restoredb BACKUP	1 พ.ค. 25	4115
How to restore 4gb DB to odoo 14 in docker postgresql restoredb db v14	1 ส.ค. 21	7391
Odoo11: How to execute pg_dump WITH Filestore option แก้ไขแล้ว filestore postgresql backup dump	1 ก.พ. 19	16530

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!