<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 gmail_quote_container"><div dir="ltr" class="gmail_attr">On Fri, 24 Jan 2025 at 15:22, 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">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>
<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.