Odoo Help


4 答案

Techno-Functional Associate with 7+ years of experience in Odoo (formerly known as OpenERP).

deep 印度
2018/1/19 上午5:33

Found the solution, bit tedious work actually, but this solved my issue.

For anyone seeking the solution for the same, please refer the below link.

Bug when restore with the backup database not include filestore


Was able to fix this problem with a workaround: manually going into the database and removing the entries pointing to the missing files from filestore

DELETE FROM ir_attachment WHERE store_fname LIKE '%<the ending hash>%'

For Example:

2016-05-06 09:07:25,787 1 INFO database-name openerp.addons.base.ir.ir_attachment: _read_file reading /var/lib/odoo/filestore/<database name>/82/825be0a9492aa429844218238d35347d6a3c9220
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_attachment.py", line 105, in _file_read
    r = open(full_path,'rb').read().encode('base64')
IOError: [Errno 2] No such file or directory: u'/var/lib/odoo/filestore/<database name>/82/825be0a9492aa429844218238d35347d6a3c9220'

So the above error would be fixed by doing

DELETE FROM ir_attachment WHERE store_fname LIKE'%825be0a9492aa429844218238d35347d6a3c9220%';

After doing this for every problematic file, Odoo re-compiled all the assets and the backend started working again.

P.S. For more detailed explanation, please refer the answer suggested by aisopuro in the above link.

2 注释
EuroGold, Paulo Matos 安哥拉
2019/2/26 下午1:24

Great post. Thank you

deep 印度
2019/2/28 上午6:35


ajay 印度
2019/4/30 上午7:20

Getting  same issue after  i changed my production server,in above case you are deleted the attachments from database. is there any way to recover or regenerate deleted attachment files from filestore folder


Keep Informed
1 关注者(s)
About This Community

This platform 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.

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now