Offline map tile database corrupted
since some days my most important offline map tile database becomes corrupted, when I try to calculate the number of updatable map tiles of a particular zoom level. The sqlitedb file then has a very small size (some kB, normally its size is ~4 GB). Fortunately beside it there is a backup version of the original one. So I simply can close Locus Map, delete the corrupted one, rename the backup file to the original name and start Locus Map again. So I thought, there must be a hidden error in the database, copied the sqlitedb file to my PC and localisied it with SQLite Administrator. The image of one single entry in the tiles table is corrupted. Sadly, SQLite Administrator is not very verbose, when reporting the error:
20.08.2022 13:50:30: SQL Error: SQL logic error or missing database < select image from tiles<br>where z = 2 and x = 17176 and y = 10814;>The other values x, y, z and s of this entry can be selected properly. And the image of any other entry can be selected too (is reported as "‰PNG" by SQLite Administrator). So my question is, can I fix or delete this corrupted entry in any way? Trying to delete it using the same where clause ends up with the same error:
20.08.2022 13:51:21: SQL Error: SQL logic error or missing database < delete from tiles where z = 2 and x = 17176 and y = 10814;>What can I do to repair my map tile database?