This object is in archive!
Routes database is getting an error message
Solved
The problem with the points / routes database is getting an error message since the new version. I have many saved routes but I can not see them, only the points. I tried to restore it from backup, but I got the same error message. I've deleted the entire app (folders too) and reinstalled it, but it did not help.
Please help me get them back!
The same problem 
Hi,
it sometimes happens that the sqlite database in general (not only in Locus) gets corrupted for some unknown reason. You can try to repair it following these instructions: http://docs.locusmap.eu/doku.php?id=manual:advanced:map_tools:corrupted_sqlite
Hi,
it sometimes happens that the sqlite database in general (not only in Locus) gets corrupted for some unknown reason. You can try to repair it following these instructions: http://docs.locusmap.eu/doku.php?id=manual:advanced:map_tools:corrupted_sqlite
Hi,
Thank you, but it does not help. :(
C:\Users\Molnar\Documents\Locus mentés\1>Sqlite3.exe tracks.db "PRAGMA integrity_check"
*** in database main ***
On page 3524 at right child: Failed to read ptrmap key=3449
On page 1159 at right child: Failed to read ptrmap key=3486
On page 1159 at right child: Failed to read ptrmap key=3484
On page 1159 at right child: Failed to read ptrmap key=3485
On page 1159 at right child: Failed to read ptrmap key=3483
On page 1159 at right child: Failed to read ptrmap key=3482
On page 1159 at right child: Failed to read ptrmap key=3479
Page 3169: btreeInitPage() returns error code 11
On page 7 at right child: Child page depth differs
On page 7 at right child: Failed to read ptrmap key=3336
Page 3336: btreeInitPage() returns error code 11
Page 3211: btreeInitPage() returns error code 11
Page 4264: btreeInitPage() returns error code 11
Page 4261: btreeInitPage() returns error code 11
Page 4260: btreeInitPage() returns error code 11
On page 7 at right child: Child page depth differs
Page 4263: btreeInitPage() returns error code 11
Page 4259: btreeInitPage() returns error code 11
Page 4258: btreeInitPage() returns error code 11
Page 4257: btreeInitPage() returns error code 11
Page 3254: btreeInitPage() returns error code 11
On page 7 at right child: Child page depth differs
On page 3131 at right child: Failed to read ptrmap key=3431
On page 3131 at right child: Failed to read ptrmap key=3430
On page 3131 at right child: Failed to read ptrmap key=3429
On page 3131 at right child: Failed to read ptrmap key=3442
On page 3131 at right child: Failed to read ptrmap key=3428
On page 3131 at right child: Failed to read ptrmap key=3426
On page 3131 at right child: Failed to read ptrmap key=3425
On page 3131 at right child: Failed to read ptrmap key=3424
Page 3424: btreeInitPage() returns error code 11
On page 3131 at right child: Failed to read ptrmap key=3441
On page 3131 at right child: Failed to read ptrmap key=3423
Page 3423: btreeInitPage() returns error code 11
On page 3131 at right child: Failed to read ptrmap key=3422
Page 3422: btreeInitPage() returns error code 11
On page 3131 at right child: Failed to read ptrmap key=3420
Page 3420: btreeInitPage() returns error code 11
On page 3131 at right child: Failed to read ptrmap key=3419
Page 3419: btreeInitPage() returns error code 11
On page 7 at right child: Child page depth differs
On page 4023 at right child: Failed to read ptrmap key=3446
On page 4023 at right child: Failed to read ptrmap key=3481
On page 4023 at right child: Failed to read ptrmap key=3474
On page 4023 at right child: Failed to read ptrmap key=3468
On page 4023 at right child: Failed to read ptrmap key=3463
On page 4023 at right child: Failed to read ptrmap key=3455
On page 4023 at right child: Failed to read ptrmap key=3448
Page 3184: btreeInitPage() returns error code 11
Page 3177: btreeInitPage() returns error code 11
Page 3182: btreeInitPage() returns error code 11
Page 3190: btreeInitPage() returns error code 11
Page 3187: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3339
Page 3339: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3405
Page 3405: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3404
Page 3404: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3398
Page 3398: btreeInitPage() returns error code 11
Page 3233: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3375
Page 3375: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3379
Page 3379: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3362
Page 3362: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3355
Page 3355: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3346
Page 3346: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3340
Page 3340: btreeInitPage() returns error code 11
Page 3201: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3322
Page 3322: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3329
Page 3329: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3308
Page 3308: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3319
Page 3319: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3295
Page 3295: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3297
Page 3297: btreeInitPage() returns error code 11
Page 3229: btreeInitPage() returns error code 11
Page 3275: btreeInitPage() returns error code 11
Page 3281: btreeInitPage() returns error code 11
Page 3261: btreeInitPage() returns error code 11
Page 3260: btreeInitPage() returns error code 11
Page 3246: btreeInitPage() returns error code 11
Page 3239: btreeInitPage() returns error code 11
Page 3231: btreeInitPage() returns error code 11
Page 3228: btreeInitPage() returns error code 11
Page 3223: btreeInitPage() returns error code 11
Page 3209: btreeInitPage() returns error code 11
Page 3199: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3376
Hi,
Thank you, but it does not help. :(
C:\Users\Molnar\Documents\Locus mentés\1>Sqlite3.exe tracks.db "PRAGMA integrity_check"
*** in database main ***
On page 3524 at right child: Failed to read ptrmap key=3449
On page 1159 at right child: Failed to read ptrmap key=3486
On page 1159 at right child: Failed to read ptrmap key=3484
On page 1159 at right child: Failed to read ptrmap key=3485
On page 1159 at right child: Failed to read ptrmap key=3483
On page 1159 at right child: Failed to read ptrmap key=3482
On page 1159 at right child: Failed to read ptrmap key=3479
Page 3169: btreeInitPage() returns error code 11
On page 7 at right child: Child page depth differs
On page 7 at right child: Failed to read ptrmap key=3336
Page 3336: btreeInitPage() returns error code 11
Page 3211: btreeInitPage() returns error code 11
Page 4264: btreeInitPage() returns error code 11
Page 4261: btreeInitPage() returns error code 11
Page 4260: btreeInitPage() returns error code 11
On page 7 at right child: Child page depth differs
Page 4263: btreeInitPage() returns error code 11
Page 4259: btreeInitPage() returns error code 11
Page 4258: btreeInitPage() returns error code 11
Page 4257: btreeInitPage() returns error code 11
Page 3254: btreeInitPage() returns error code 11
On page 7 at right child: Child page depth differs
On page 3131 at right child: Failed to read ptrmap key=3431
On page 3131 at right child: Failed to read ptrmap key=3430
On page 3131 at right child: Failed to read ptrmap key=3429
On page 3131 at right child: Failed to read ptrmap key=3442
On page 3131 at right child: Failed to read ptrmap key=3428
On page 3131 at right child: Failed to read ptrmap key=3426
On page 3131 at right child: Failed to read ptrmap key=3425
On page 3131 at right child: Failed to read ptrmap key=3424
Page 3424: btreeInitPage() returns error code 11
On page 3131 at right child: Failed to read ptrmap key=3441
On page 3131 at right child: Failed to read ptrmap key=3423
Page 3423: btreeInitPage() returns error code 11
On page 3131 at right child: Failed to read ptrmap key=3422
Page 3422: btreeInitPage() returns error code 11
On page 3131 at right child: Failed to read ptrmap key=3420
Page 3420: btreeInitPage() returns error code 11
On page 3131 at right child: Failed to read ptrmap key=3419
Page 3419: btreeInitPage() returns error code 11
On page 7 at right child: Child page depth differs
On page 4023 at right child: Failed to read ptrmap key=3446
On page 4023 at right child: Failed to read ptrmap key=3481
On page 4023 at right child: Failed to read ptrmap key=3474
On page 4023 at right child: Failed to read ptrmap key=3468
On page 4023 at right child: Failed to read ptrmap key=3463
On page 4023 at right child: Failed to read ptrmap key=3455
On page 4023 at right child: Failed to read ptrmap key=3448
Page 3184: btreeInitPage() returns error code 11
Page 3177: btreeInitPage() returns error code 11
Page 3182: btreeInitPage() returns error code 11
Page 3190: btreeInitPage() returns error code 11
Page 3187: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3339
Page 3339: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3405
Page 3405: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3404
Page 3404: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3398
Page 3398: btreeInitPage() returns error code 11
Page 3233: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3375
Page 3375: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3379
Page 3379: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3362
Page 3362: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3355
Page 3355: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3346
Page 3346: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3340
Page 3340: btreeInitPage() returns error code 11
Page 3201: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3322
Page 3322: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3329
Page 3329: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3308
Page 3308: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3319
Page 3319: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3295
Page 3295: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3297
Page 3297: btreeInitPage() returns error code 11
Page 3229: btreeInitPage() returns error code 11
Page 3275: btreeInitPage() returns error code 11
Page 3281: btreeInitPage() returns error code 11
Page 3261: btreeInitPage() returns error code 11
Page 3260: btreeInitPage() returns error code 11
Page 3246: btreeInitPage() returns error code 11
Page 3239: btreeInitPage() returns error code 11
Page 3231: btreeInitPage() returns error code 11
Page 3228: btreeInitPage() returns error code 11
Page 3223: btreeInitPage() returns error code 11
Page 3209: btreeInitPage() returns error code 11
Page 3199: btreeInitPage() returns error code 11
On page 3583 at right child: Failed to read ptrmap key=3376
Hi,
you haven't completed the process - you just processed the dtb analysis. Now you have to launch the process of dtb renewal - "sqlite3 mydata.db ".dump" | sqlite3 new.db" (read the manual more thoroughly)
Hi,
you haven't completed the process - you just processed the dtb analysis. Now you have to launch the process of dtb renewal - "sqlite3 mydata.db ".dump" | sqlite3 new.db" (read the manual more thoroughly)
Hi,
C:\Users\Molnar\Dokumentumok\locus mentés\1>sqlite3 tracks.db ".dump" | sqlite3 new.db
Error: near line 20: no such column: Inf
Error: near line 70: no such column: Inf
What does that mean?
Hi,
C:\Users\Molnar\Dokumentumok\locus mentés\1>sqlite3 tracks.db ".dump" | sqlite3 new.db
Error: near line 20: no such column: Inf
Error: near line 70: no such column: Inf
What does that mean?
Hi,
The "new.db" Data Base File is 0 KB
Hi,
The "new.db" Data Base File is 0 KB
Good day Molnár,
may you please share you database file with us? We will look at it. Thank you.
Menion
Good day Molnár,
may you please share you database file with us? We will look at it. Thank you.
Menion
Hi,
I hope someone can help me.
Hi,
I hope someone can help me.
Hi,
Sorry! :)
Hi,
Sorry! :)
Hello,
fine, try attached database file. It should work. Just extract zip file and copy tracks.db into Locus/data/database directory.
Hello,
fine, try attached database file. It should work. Just extract zip file and copy tracks.db into Locus/data/database directory.
This works! Thanks a thousand! :)
This works! Thanks a thousand! :)
Not sure, where was a problem in your own "repair", because I've followed steps in our wiki manual as well.
Anyway I'm glad that tracks are saved!
Menion
Not sure, where was a problem in your own "repair", because I've followed steps in our wiki manual as well.
Anyway I'm glad that tracks are saved!
Menion
Replies have been locked on this page!