Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi there,
When selecting Financials a window is opened with the OpenERP Server Error: InternalError: index "ir_translation_src_hash_idx" contains unexpected zero page at block 84 HINT: Please REINDEX it.
Does anybody knows how this can be done? Is there a tool which I can do this?
You have some database corruption, but probably nothing to worry about. The error report is telling you what you should do . . . use REINDEX.
However, before anything you should use pg_dump to get a text backup copy of your entire database.
Then log in to postgres as admin with psql and run the command REINDEX INDEX ir_translation_src_hash_idx
Just Google it for more details : https://www.google.com/search?q=index+contains+unexpected+zero+page+at+block+HINT%3A+Please+REINDEX+it
If you still have problems after that, try pg_restore with the text backup to a new database and see if that one works. I'm confident it will.
Thanks, pgadminIII and a Reindex did the trick.
I'm glad I was able to help.
GUI method:
Run pgAdmin3, open database-Schemas-public-Tables-ir_translation-Indexes- right click: ir_translation_src_hash_idx - Maintenance.. REINDEX(by default) - OK!
Excelent information !!!!!
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký| Bài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
|---|---|---|---|---|
|
1
thg 12 24
|
4529 | ||
|
0
thg 11 24
|
1842 | ||
|
2
thg 7 24
|
3749 | ||
|
0
thg 4 24
|
2383 | ||
|
3
thg 3 24
|
3780 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
So how did you solve this?