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?
Analysing, designing, coding and mentoring since 1975. Kilobytes to terabytes. Punch cards to punchy sites. My OpenERP video series: http://www.youtube.com/playlist?list=PLq7op4J183lX44ZlXPiHxUpRvmmRDtxye My Google Speadsheets --> OpenERP Data Pump project: http://martinhbramwell.github.io/GData_OpenERP_Data_Pump My email (with spaces removed) : mhb . warehouseman @ gmail . com
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.
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.
RegisterAccess to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.
Test it now
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
So how did you solve this?