<div dir="ltr">Hi, Andrew,<div><br></div><div>thanks for your reply. I tried that,</div><div><br></div><div><div>/var/www/html/cqpweb/bin$ php upgrade-database.php </div><div>CQPweb database is now at or above the most-recently-changed version (3.2.27). Upgrade complete!</div></div><div><br></div><div>However, the problem persists.</div><div><br></div><div>I'm copy-pasting below the PHP traceback in case helps for a change of data type from ID link to free text:</div><div><br></div><div><div>PHP debugging backtrace</div><div>array(5) {</div><div> [1]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(40) "/var/www/html/cqpweb/lib/library.inc.php"</div><div> ["line"]=></div><div> int(286)</div><div> ["function"]=></div><div> string(20) "exiterror_mysqlquery"</div><div> ["args"]=></div><div> array(3) {</div><div> [0]=></div><div> int(1146)</div><div> [1]=></div><div> string(45) "Table 'cqpweb_db.idlink_values' doesn't exist"</div><div> [2]=></div><div> string(167) "delete from idlink_values where corpus = 'empac_en' and att_handle = 'text_srt_url' </div><div><span style="white-space:pre">        </span>/* from User: jmartinez | Function: delete_xml_idlink() | 2018-Jul-07 05:41:30 */"</div><div> }</div><div> }</div><div> [2]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(36) "/var/www/html/cqpweb/lib/xml.inc.php"</div><div> ["line"]=></div><div> int(1119)</div><div> ["function"]=></div><div> string(14) "do_mysql_query"</div><div> ["args"]=></div><div> array(1) {</div><div> [0]=></div><div> &string(167) "delete from idlink_values where corpus = 'empac_en' and att_handle = 'text_srt_url' </div><div><span style="white-space:pre">        </span>/* from User: jmartinez | Function: delete_xml_idlink() | 2018-Jul-07 05:41:30 */"</div><div> }</div><div> }</div><div> [3]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(36) "/var/www/html/cqpweb/lib/xml.inc.php"</div><div> ["line"]=></div><div> int(296)</div><div> ["function"]=></div><div> string(17) "delete_xml_idlink"</div><div> ["args"]=></div><div> array(2) {</div><div> [0]=></div><div> string(8) "empac_en"</div><div> [1]=></div><div> string(12) "text_srt_url"</div><div> }</div><div> }</div><div> [4]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(47) "/var/www/html/cqpweb/lib/metadata-admin.inc.php"</div><div> ["line"]=></div><div> int(275)</div><div> ["function"]=></div><div> string(19) "change_xml_datatype"</div><div> ["args"]=></div><div> array(3) {</div><div> [0]=></div><div> string(8) "empac_en"</div><div> [1]=></div><div> string(12) "text_srt_url"</div><div> [2]=></div><div> int(2)</div><div> }</div><div> }</div><div> [5]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(43) "/var/www/html/cqpweb/exe/metadata-admin.php"</div><div> ["line"]=></div><div> int(3)</div><div> ["args"]=></div><div> array(1) {</div><div> [0]=></div><div> string(47) "/var/www/html/cqpweb/lib/metadata-admin.inc.php"</div><div> }</div><div> ["function"]=></div><div> string(7) "require"</div><div> }</div><div>}</div><div>CQPweb v3.2.31 © 2008-2018<span style="white-space:pre">        </span>Help! on CQPweb<span style="white-space:pre">        </span>You are logged in as user [jmartinez]</div></div><div><br></div><div><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div>--</div><div><div>José Manuel Martínez Martínez</div><div><a href="https://chozelinek.github.io" target="_blank">https://chozelinek.github.io</a></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Fri, Jul 6, 2018 at 12:07 PM, Hardie, Andrew <span dir="ltr"><<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-GB" link="blue" vlink="purple">
<div class="m_-3090533216896694494WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1f497d">I think this problem will go away if you run the upgrade-database script!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1f497d">best<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1f497d">Andrew.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a> [mailto:<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.<wbr>unibo.it</a>]
<b>On Behalf Of </b>José Manuel Martínez Martínez<br>
<b>Sent:</b> 06 July 2018 02:00<br>
<b>To:</b> Open source development of the Corpus WorkBench <<a href="mailto:cwb@sslmit.unibo.it" target="_blank">cwb@sslmit.unibo.it</a>><br>
<b>Subject:</b> [CWB] Error with idlink<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Hi there,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I've been trying to install an already indexed corpus. When I was in Manage corpus XML I changed the data type of an structural attribute from free text to ID link. I clicked on Change and I could see the following <span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black;background:#b0ffff">ID
link (linked table does not exist)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Then I decided to roll back to free text, but then I got the following message:</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">A MySQL query did not run successfully!</span><span style="font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif;color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Original query: delete from idlink_values where corpus = 'empac_en' and att_handle = 'text_srt_url' /* from User: jmartinez | Function: delete_xml_idlink() */</span><span style="font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif;color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Error # 1146: Table 'cqpweb_db.idlink_values' doesn't exist</span><span style="font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif;color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">I then tried to delete the corpus and start from scratch again, but this seems not to work either:</span><span style="font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif;color:black"><u></u> <u></u></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">A MySQL query did not run successfully!</span><span style="font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif;color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Original query: delete from idlink_values where corpus = 'empac_en' and att_handle = 'text_srt_url' /* from User: jmartinez | Function: delete_xml_idlink() | 2018-Jul-06
00:59:27 */</span><span style="font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif;color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Error # 1146: Table 'cqpweb_db.idlink_values' doesn't exist</span><span style="font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif;color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Any help with this will be much appreciated!</span><span style="font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif;color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black">Cheers,</span><span style="font-family:"Verdana",sans-serif;color:black"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif;color:black"><u></u> <u></u></span></p>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">--<u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal">José Manuel Martínez Martínez<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><a href="https://chozelinek.github.io" target="_blank">https://chozelinek.github.io</a><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
</div>
<br>______________________________<wbr>_________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it">CWB@sslmit.unibo.it</a><br>
<a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" rel="noreferrer" target="_blank">http://liste.sslmit.unibo.it/<wbr>mailman/listinfo/cwb</a><br>
<br></blockquote></div><br></div>