DR1000 How can I force a re-index

[Spelly]

For some reason my device no longer re-indexes after uploading new pdfs. I do not get the indexing message and I do not see the newly added files. If I delete an old file it still appears in the list, but if I try and open it I get an error 4. resetting has not helped. Does anyone have any ideas? Thx

I was able to fix things by renaming the global.db file. All appears to be fixed for the moment.

[Mackx]

I have heard before that the global.db file got corrupted and the only way it to remove/rename it. I have a question, do you remember if you did anything special just before the problem occured (if we know what the cause was others can try to avoid it)?
Things like: reset the device manually; removing battery; 'auto shutdown' because of empty battery; etc.

[Iñigo]

Originally Posted by Spelly

For some reason my device no longer re-indexes after uploading new pdfs. I do not get the indexing message and I do not see the newly added files. If I delete an old file it still appears in the list, but if I try and open it I get an error 4. resetting has not helped. Does anyone have any ideas? Thx

I was able to fix things by renaming the global.db file. All appears to be fixed for the moment.

Reindexing is handled by mdbindex program in the device.
If you have access to a shell in your DR you can type:

# mdbindex /media/mmcblk0p1

and look at the possible errors there.

Anyway, the simple solution is what Mackx has said, delete (or better, rename) global.db file at the root of the SD card. Note that it will take some time if you have lots of files.

[Mackx]

I have also seen corrupted metadata.db file (the local databases in every directory) that prevented scribbles/annotations from being added. SQLite2009Pro (free tool running under windows) can read most of the data, but also reports that the file is corrupted and does not allow any changes anymore. Is there an (open sourced) tool that can repair corrupted sqlite3 databases?

[Iñigo]

Originally Posted by Mackx

I have also seen corrupted metadata.db file (the local databases in every directory) that prevented scribbles/annotations from being added. SQLite2009Pro (free tool running under windows) can read most of the data, but also reports that the file is corrupted and does not allow any changes anymore. Is there an (open sourced) tool that can repair corrupted sqlite3 databases?

There is a multiplatform firefox extension I sometimes use named SQLite Manager with interesting functions like "Analyze Database" and "Check Integrity". Maybe they can help.