2.7.3 Pro db conversion issue
I just upgraded Locus Pro to 2.7.3.
When trying to start the program, I get the dialog:
An old database files (Locus/data/*.sqll) and a new, already converted database files (Locus/data/database/*.db) exist
This may be caused by an incomplete conversion... etc
[Delete new | Close | Delete old]
I chose Close, then checked what I have -- I had a Locus/data/databasefavorites.sqll file and Locus/data/database/tracks.db, Locus/data/database/waypoints.db. I backed them up and went back to the program.
Given I do have recorded tracks, while I can`t recall marking any favorit, I thought the latter are the more valuable so I this time I went with Delete old. Then Locus starts but I can`t find my recorded tracks.
I can get back to the dialog by restoring said files.
What can I do to arrive at a clean state and be able to find and open my existing tracks?
The same problem 
Hi,
I’m sorry but I have problem to clearly understand the steps you did.
1.You made backup of old files (Locus/data/databasefavorites.sqll, Locus/data/database/tracks.db, Locus/data/database/waypoints.db)
2.After that you run Locus and choose “Delete old”
3.Your old track disappear
Is this your problem? Or is there anything what I haven’t noticed?
Regards
Petr
Hi,
I’m sorry but I have problem to clearly understand the steps you did.
1.You made backup of old files (Locus/data/databasefavorites.sqll, Locus/data/database/tracks.db, Locus/data/database/waypoints.db)
2.After that you run Locus and choose “Delete old”
3.Your old track disappear
Is this your problem? Or is there anything what I haven’t noticed?
Regards
Petr
Hi Petr, you understand the issue correctly. (Besides, I`m wondering how I got dropped to that dialogue at all? I just acted as honest naive user, I wasn`t even aware of the db format change.)
Hi Petr, you understand the issue correctly. (Besides, I`m wondering how I got dropped to that dialogue at all? I just acted as honest naive user, I wasn`t even aware of the db format change.)
Hi
Please perform following actions:
1.Close Locus
2.Remove directory Locus/data/database
3.Use you backup of old DB files and copy these file into old location (Locus/data/databasefavorites.sqll, Locus/data/database/tracks.db, Locus/data/database/waypoints.db)
Please keep your backup (only for your safety)
4.Run Locus
5.After that Locus will show information window about update – choose yes for conversion into new format. This step convert old db files into new format which is vital for new Locus.
Please note – if you have already created some new tracks or points these data will be deleted.
Regards
Petr
Hi
Please perform following actions:
1.Close Locus
2.Remove directory Locus/data/database
3.Use you backup of old DB files and copy these file into old location (Locus/data/databasefavorites.sqll, Locus/data/database/tracks.db, Locus/data/database/waypoints.db)
Please keep your backup (only for your safety)
4.Run Locus
5.After that Locus will show information window about update – choose yes for conversion into new format. This step convert old db files into new format which is vital for new Locus.
Please note – if you have already created some new tracks or points these data will be deleted.
Regards
Petr
2.-3. of your instructions sums up to the removal of the following files from
Locus/data/database/:
waypoints.db-journal tracks.db-journal .count_dbWaypoints .visibleItems_dbWaypoints .visibleItems_gcWaypoints .count_dbTracks .visibleItems_dbTracks
given that Locus/data/databasefavorites.sqll, Locus/data/database/tracks.db, Locus/data/database/waypoints.db were already there.
Starting Locus with:
- having the three db files there yields the "delete old/close/delete new" error dialogue (removing the journal and dotfiles does not make a difference);
- databasefavorites.sqll removed, I get a smooth startup with no note about conversion and the tracks are gone.
2.-3. of your instructions sums up to the removal of the following files from
Locus/data/database/:
waypoints.db-journal tracks.db-journal .count_dbWaypoints .visibleItems_dbWaypoints .visibleItems_gcWaypoints .count_dbTracks .visibleItems_dbTracks
given that Locus/data/databasefavorites.sqll, Locus/data/database/tracks.db, Locus/data/database/waypoints.db were already there.
Starting Locus with:
- having the three db files there yields the "delete old/close/delete new" error dialogue (removing the journal and dotfiles does not make a difference);
- databasefavorites.sqll removed, I get a smooth startup with no note about conversion and the tracks are gone.
There two possible solutions in this case:
Solution A
Uninstall Locus (this step does not affect old DB files) and then install Locus again
After that Locus should offer conversion process to new DB version
Solution B
Email us old DB files (Locus/data/databasefavorites.sqll, Locus/data/database/tracks.db, Locus/data/database/waypoints.db) and we’ll covert your files to new version
There two possible solutions in this case:
Solution A
Uninstall Locus (this step does not affect old DB files) and then install Locus again
After that Locus should offer conversion process to new DB version
Solution B
Email us old DB files (Locus/data/databasefavorites.sqll, Locus/data/database/tracks.db, Locus/data/database/waypoints.db) and we’ll covert your files to new version
I just add one more information in case, that Solution A will not work for you
1. email us all *.sqll files in Locus/data directory. There have to be more then databasefavorites file
2. email is "locus@asamm.com" (just in case)
I just add one more information in case, that Solution A will not work for you
1. email us all *.sqll files in Locus/data directory. There have to be more then databasefavorites file
2. email is "locus@asamm.com" (just in case)
Replies have been locked on this page!