<div dir="ltr"><div><div><div>Dear Nicola,<br><br></div>I am glad to hear it worked. I have updated our documentation accordingly.<br><br></div>Sincerely<br></div>Antanas<br></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Mon, 27 Jan 2025 at 10:01, Nicola Döbelin <<a href="mailto:support@profex-xrd.org">support@profex-xrd.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u>
<div>
Dear Antanas,<br>
<br>
The modified script works perfectly. Thanks a lot for your help!<br>
<br>
Best regards,<br>
Nicola<br>
<br>
<br>
<div>On 1/24/25 21:23, Antanas Vaitkus
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">Dear Nicola,<br>
<br>
</div>
<div>The issue seems to arise due to inline comments output by
MariaDB,<br>
(e.g. "`time` time /* mariadb-5.3 */ DEFAULT NULL,") since
sqlt MySQL<br>
</div>
<div>parser does not know how to handle them.<br>
<br>
I have updated the script you sent to circumvent the issue.
Please give<br>
</div>
<div>it a try and let us know if this fully solves your issue.
The script does<br>
</div>
<div>work correctly on my machine.<br>
</div>
<div><br>
</div>
<div>If this solution works for you, I will update the
documentation accordingly.<br>
</div>
<div><br>
</div>
<div>Sincerely,<br>
</div>
<div>Antanas<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Fri, 24 Jan 2025 at
15:22, Nicola Döbelin <<a href="mailto:support@profex-xrd.org" target="_blank">support@profex-xrd.org</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello,<br>
<br>
I am the programmer of the Rietveld refinement software
Profex. In the <br>
past few years, I used to convert the COD to sqlite3 to
bundle it with <br>
Profex. For the conversion I used the attached bash script,
which I <br>
created based on the information given on the COD wiki:<br>
<br>
<a href="https://wiki.crystallography.net/creatingSQLdatabase/" rel="noreferrer" target="_blank">https://wiki.crystallography.net/creatingSQLdatabase/</a><br>
<br>
However, this year the script no longer works and generates
the <br>
following error message:<br>
<br>
#-- begin output --<br>
<br>
updating svn<br>
Updating '.':<br>
At revision 297460.<br>
converting mysql to sqlite<br>
<br>
ERROR (line 13): Invalid statement: Was expecting
comment, or use, or<br>
set, or drop, or create, or alter,
or insert, or<br>
delimiter, or empty statement<br>
Error: translate: Error with parser
'SQL::Translator::Parser::MySQL': <br>
no results at /usr/bin/sqlt line 353.<br>
replacing escape sequences<br>
importing data<br>
CREATE TABLE data(...) failed: duplicate column name: 90<br>
creating cod-250124.db<br>
compressing<br>
adding: cod-250124.db3 (stored 0%)<br>
<br>
#-- end output --<br>
<br>
The resulting *.db3 file is empty. I always update the
sqlite3 COD <br>
version in January, so the break must have occurred some
time between <br>
Jan 2024 and Jan 2025. I also tried to run the script on an
older Ubuntu <br>
20.04 system on which it used to work in the past, but to no
avail. <br>
Since I am not familiar with MySQL and have very limited
experience with <br>
sqlite, I would like to ask for help to create an updated
sqlite version <br>
of the COD that I can bundle with Profex.<br>
<br>
Any help will be appreciated.<br>
Kind regards,<br>
Nicola<br>
<br>
-- <br>
Nicola Döbelin<br>
Web: <a href="https://www.profex-xrd.org" rel="noreferrer" target="_blank">https://www.profex-xrd.org</a><br>
E-Mail: <a href="mailto:support@profex-xrd.org" target="_blank">support@profex-xrd.org</a><br>
<br>
-- <br>
This message has been scanned for viruses and<br>
dangerous content by MailScanner, and is<br>
believed to be clean.<br>
<br>
_______________________________________________<br>
Cod-bugs mailing list<br>
<a href="mailto:Cod-bugs@lists.crystallography.net" target="_blank">Cod-bugs@lists.crystallography.net</a><br>
<a href="http://lists.crystallography.net/cgi-bin/mailman/listinfo/cod-bugs" rel="noreferrer" target="_blank">http://lists.crystallography.net/cgi-bin/mailman/listinfo/cod-bugs</a><br>
</blockquote>
</div>
<div><br clear="all">
</div>
<br>
<span class="gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div>
<div>Antanas Vaitkus,<br>
</div>
Vilnius University,<br>
Life Sciences Center,<br>
Institute of Biotechnology,<br>
<span><span><span>room C521, </span></span></span>Saulėtekio
al. 7,<br>
LT-10257 Vilnius, Lithuania<br>
</div>
<div>
<div>
<div>
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr"><br>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
</div>
</blockquote></div><div><br clear="all"></div><br><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div>Antanas Vaitkus,<br></div>Vilnius University,<br>Life Sciences Center,<br>Institute of Biotechnology,<br><span><span><span>room C521, </span></span></span>Saulėtekio al. 7,<br>LT-10257 Vilnius, Lithuania<br></div><div><div><div><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><br><br></div></div></div></div></div></div></div></div></div></div></div>
<br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.