Re: SQLite3 database corrupted

--===============4029556075247501889==
Content-Type: multipart/alternative; boundary="000000000000293a0405f9bc4d5c"

--000000000000293a0405f9bc4d5c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

I have a project with some tests against the SQLite behavior. I needed to
dust it off a bit, but I was able to get it working at the major versions
between now and the last time I touched it (without seeing this issue
myself).

I did notice some regressed behavior, mostly around some 2021 QCString
refactoring and have a commit fixing it. I'm curious if this happens to
work for you if you build from it:
https://github.com/abathur/doxygen/commit/6106b5119ba84a692dd7cdf1e91535cbd=
83ec070


The line you're quoting for the parse error looks like data for the "meta"
table. Here's an example of what that looks like in a db from one of my
tests:

sqlite> select * from meta;
doxygen_version =3D 1.9.7
 schema_version =3D 0.2.1
   generated_at =3D Wed Jan 2 1980 00:00:00
   generated_on =3D Wed Jan 2 1980
   project_name =3D ManualTest
 project_number =3D 1.1.22
  project_brief =3D A quick idea about the purpose of the project

and the statement binding the value for `schema_version` is one of the ones
I fixed.

On Tue, Apr 18, 2023 at 12:30=E2=80=AFPM Chad Cornwell <cornwell.chad@gmail=
.com>
wrote:

> I compiled from source on centos 7 using the scl dev toolset 7 (if this
> matters) for doxygen 1.9.7 with the -Duse_sqlite3 flag on.
>
> I was able to successfully run doxygen on my code directory and did not
> see any error flags pop up relating to sqlite3 (or any at all) however wh=
en
> I try to open up the database using sqlite3 it responds to .tables with '
> Errror: file is not a database'
>
> Additionally when I try to .read doxygen_sqlite3.db it gives the followin=
g
> error:
> Parse error near line 1: unrecognized token "18a592b71f"
>  18a592b71fc2*)0.2.1TueApr 18 2023 17:54:53Tue Apr 18 2023My Project
> 05acdd2d7
>    ^--- error here
>
> It seems as if the data is populated into the .db file but it is getting
> corrupted somehow along the way, any ideas on how to fix this? Thank you =
so
> much for your help!
> _______________________________________________
> Doxygen-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/doxygen-users
>

--000000000000293a0405f9bc4d5c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I have a project with some tests against the SQLite behavi=
or. I needed to dust it off a bit, but I was able to get it working at the =
major versions between now and the last time I touched it (without seeing t=
his issue myself).<div><br></div><div>I did notice some regressed behavior,=
 mostly around some 2021 QCString refactoring and have a commit fixing it. =
I&#39;m curious if this happens to work for you if you build from it:=C2=A0=
<a href=3D"https://github.com/abathur/doxygen/commit/6106b5119ba84a692dd7cd=
f1e91535cbd83ec070">https://github.com/abathur/doxygen/commit/6106b5119ba84=
a692dd7cdf1e91535cbd83ec070</a>=C2=A0</div><div><br></div><div>The line you=
&#39;re quoting for the parse error looks like data for the &quot;meta&quot=
; table. Here&#39;s an example of what that looks like in a db from one of =
my tests:</div><div><br></div><div><font face=3D"monospace">sqlite&gt; sele=
ct * from meta;<br>doxygen_version =3D 1.9.7<br>=C2=A0schema_version =3D 0.=
2.1<br>=C2=A0 =C2=A0generated_at =3D Wed Jan 2 1980 00:00:00<br>=C2=A0 =C2=
=A0generated_on =3D Wed Jan 2 1980<br>=C2=A0 =C2=A0project_name =3D ManualT=
est<br>=C2=A0project_number =3D 1.1.22<br>=C2=A0 project_brief =3D A quick =
idea about the purpose of the project</font><br></div><div><font face=3D"mo=
nospace"><br></font></div><div><font face=3D"arial, sans-serif">and the sta=
tement binding the value for `schema_version` is one of the ones I fixed.</=
font></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"g=
mail_attr">On Tue, Apr 18, 2023 at 12:30=E2=80=AFPM Chad Cornwell &lt;<a hr=
ef=3D"mailto:[email protected]">[email protected]</a>&gt; wrote=
:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.=
8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204=
,204,204);padding-left:1ex"><div dir=3D"ltr">I compiled from source on cent=
os 7 using the scl dev toolset 7 (if this matters) for doxygen 1.9.7 with t=
he -Duse_sqlite3 flag on.=C2=A0<div><br></div><div>I was able to successful=
ly run doxygen on my code directory and did not see any error flags pop up =
relating to sqlite3 (or any at all) however when I try to open up the datab=
ase using sqlite3 it responds to .tables with &#39; Errror: file is not a d=
atabase&#39;</div><div><br></div><div>Additionally when I try to .read doxy=
gen_sqlite3.db it gives the following error:</div><div>Parse error=C2=A0nea=
r line 1: unrecognized token &quot;18a592b71f&quot;</div><div>=C2=A018a592b=
71fc2*)0.2.1TueApr 18 2023 17:54:53Tue=C2=A0Apr 18 2023My Project 05acdd2d7=
</div><div>=C2=A0 =C2=A0^--- error here</div><div><br></div><div>It seems a=
s if the data is populated=C2=A0into the .db file but it is getting corrupt=
ed somehow along the way, any ideas on how to fix this? Thank you so much f=
or your help!=C2=A0</div></div>
_______________________________________________<br>
Doxygen-users mailing list<br>
<a href=3D"mailto:[email protected]" target=3D"_blank">Do=
[email protected]</a><br>
<a href=3D"https://lists.sourceforge.net/lists/listinfo/doxygen-users" rel=
=3D"noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/listi=
nfo/doxygen-users</a><br>
</blockquote></div>

--000000000000293a0405f9bc4d5c--


--===============4029556075247501889==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============4029556075247501889==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Doxygen-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/doxygen-users

--===============4029556075247501889==--