This object is in archive! 

Routes database is getting an error message

Molnár Ákos shared this problem 7 years ago
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!

Replies (11)

photo
1

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

photo
1

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

photo
1

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)

photo
1

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?

photo
1

Hi,

The "new.db" Data Base File is 0 KB

photo
1

Good day Molnár,

may you please share you database file with us? We will look at it. Thank you.


Menion

photo
1

Hi,

I hope someone can help me.

photo
1

Hi,

Sorry! :)

photo
2

Hello,

fine, try attached database file. It should work. Just extract zip file and copy tracks.db into Locus/data/database directory.

photo
1

This works! Thanks a thousand! :)

photo
2

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!

You can't vote. Please authorize!