Hi, Without being able to see your database it is hard to give more advice that https://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database/18260642 gives. Did you try all of them? Because the problem has something to do with the spatial index I would have a try be dropping it and repeating the suggested tricks.
-Jukka Rahkonen- Lähettäjä: gdal-dev <[email protected]> Puolesta Isabel Kiefer Lähetetty: maanantai 14. helmikuuta 2022 10.17 Vastaanottaja: [email protected] Aihe: [gdal-dev] Corrupted geopackage Hi everyone, I've a problem with a corrupted geopackage. It should contain a table with 694 entries, but only 78 are visible when opening the file with DB Browser for SQLite or QGIS. The table gpkg_ogr_contents says 694 though. When opening the .gpkg with a Notepad or similar, I can see that there are more than 78 entries. The error message in DB Browser is "database disk image is malformed in "PRAGMA "main".TABLE_INFO("rtree_XXX");" So it seems that there is a problem with the index of the concerned table. Does anyone know how to fix this? I tried https://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database/18260642 but without success. Thanks in advance for your help! Isabel -- Isabel Kiefer OPENGIS.ch [email protected]<mailto:[email protected]>
_______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
