This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
manual:advanced:map_tools:corrupted_sqlite [2016/04/19 20:54] – menion | manual:advanced:map_tools:corrupted_sqlite [2017/07/25 12:29] – [Quick solution for MS Win users] mstupka | ||
---|---|---|---|
Line 3: | Line 3: | ||
---- | ---- | ||
- | SQLite databases on Android devices are very stable by definition. However, we have experienced that databases can be corrupted. This may be due to wrong closing the database or killing Locus app. The result is that Locus Map is not able open the database file or the file deletes itself - **this concerns both map files and points/ | + | SQLite databases on Android devices are very stable by definition. However, we have experienced that databases can be corrupted. This may be due to wrong closing the database or killing Locus app. The result is that Locus Map is not able to open the database file or the file deletes itself - **this concerns both map files and points/ |
===== How to ===== | ===== How to ===== | ||
+ | ==== Quick solution for MS Win users ==== | ||
+ | This procedure concerns corrupted //' | ||
+ | - Download **[[http:// | ||
+ | - Copy tracks.db to the unpacked directory | ||
+ | - Rename tracks.db to tracks_old.db | ||
+ | - Run **fix_tracks.bat** | ||
+ | ==== General solution ==== | ||
- | Following steps require working with the command line. | + | Following steps require working with the DOS command line (cmd). |
* Copy corrupted map file (or other sqlite database) from your device to PC | * Copy corrupted map file (or other sqlite database) from your device to PC | ||
- | * Download sqlite-shell from [[http:// | + | * Download sqlite-tools from [[http:// |
* Unpack it and place corrupted database file into the same directory as sqlite3.exe | * Unpack it and place corrupted database file into the same directory as sqlite3.exe | ||
- | * Start cmd and navigate to the directory with the corrupted file | + | * Start "cmd" |
* Run | * Run | ||
- | < | + | < |
</ | </ | ||
* Run | * Run | ||
- | < | + | < |
</ | </ | ||
* If you repeat above integrity check on a new.db file, you should get " | * If you repeat above integrity check on a new.db file, you should get " | ||
- | * Try to import | + | * Rename new.db file to the original name of your file and copy it to its original place (i.e. copy fixed tracks.db or waypoints.db to Locus/data/database |
- | <WRAP important round> However, this is not always | + | For example: |
+ | {{ : | ||
+ | |||
+ | <WRAP important round> However, this procedure | ||