Appendix G: Database Problems
This chapter is currently only covering problems related to the flatfile database backend.
If one entry is suddenly gone or appears empty when you try to edit it, or rebuilding
the index tells you that "entry 00YXX is NOT ok", most likely some of the files in the
pivotx/db/standard-00Y00 folder are corrupt.
Usually these can be fixed by the database repair utilities, and if they can not be repaired, at least these utilities will be able to get all the information that is left, and make the broken entries accessible again.
To start download the database repair utilities. Then:
- Make a backup of your
pivotx/dbfolder. Nothing is going to break, but having a current backup is always a good thing..
- Unzip the file and upload the five files to your
pivotx/repair_db1.phpin your browser, and refresh the page until it gets to the 'Done' part.
- Do the same with
pivotx/repair_db_cleanup.phpin your browser. This will add a .bak extension to the files that couldn't be read.
- Remove the repair scripts from your
Note: If one of the script gets to 'Done' but it did not list all entries as 'OK', you do need to run the next script as well.
Do NOT remove the .bak files. We might be able to repair at least part of these files with a later version of the database repair utilities.