<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Isabel,</p>
<p>If you don't get an answer here, you may want to try the SQLite
forum: <a class="moz-txt-link-freetext" href="https://sqlite.org/forum/forum">https://sqlite.org/forum/forum</a> - If anyone knows, it'll be
someone there.</p>
<p>Maybe also of interest:
<a class="moz-txt-link-freetext" href="https://sqlite.org/howtocorrupt.html#cfgerr">https://sqlite.org/howtocorrupt.html#cfgerr</a></p>
<p>Cheers,</p>
<p>Jonathan<br>
</p>
<div class="moz-cite-prefix">On 2022-02-14 08:17, Isabel Kiefer
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAAXmMvD7t9uLTHeDPXEdZ15z7NwyYowE+iJHO+wVjOK=23m3jA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hi everyone,
<div><br>
</div>
<div>I've a problem with a corrupted geopackage. </div>
<div>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.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Does anyone know how to fix this? I tried
<a href="https://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database/18260642" target="_blank" dir="ltr" rel="noopener nofollow noreferrer" class="gmail-oiM5sf moz-txt-link-freetext" style="text-decoration-line:none;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;font-size:14px;margin:0px;padding:0px;vertical-align:baseline;font-family:Roboto,sans-serif;white-space:pre-wrap" moz-do-not-send="true">https://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database/18260642</a> but
without success.<br clear="all">
<div><br>
</div>
<div>Thanks in advance for your help!</div>
<div>Isabel</div>
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr"><font face="arial, sans-serif">Isabel Kiefer</font>
<div><font face="arial, sans-serif">OPENGIS.ch</font></div>
<div><font face="arial, sans-serif"><br>
</font></div>
<div><font size="1" face="arial, sans-serif"><a
href="mailto:isabel@opengis.ch" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">isabel@opengis.ch</a></font></div>
<div><br>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a>
</pre>
</blockquote>
</body>
</html>