<div dir="ltr">Hi there,<div><br></div><div>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="color:rgb(0,0,0);font-family:verdana;font-size:13.3333px;background-color:rgb(176,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">ID link (linked table does not exist)</span></div><div><font color="#000000" face="verdana"><span style="font-size:13.3333px"><br></span></font></div><div><font color="#000000" face="verdana"><span style="font-size:13.3333px">Then I decided to roll back to free text, but then I got the following message:</span></font></div><div><font color="#000000" face="verdana"><span style="font-size:13.3333px"><br></span></font></div><div><font color="#000000" face="verdana"><div><span style="font-size:13.3333px">A MySQL query did not run successfully!</span></div><div><span style="font-size:13.3333px"><br></span></div><div><span style="font-size:13.3333px">Original query: delete from idlink_values where corpus = 'empac_en' and att_handle = 'text_srt_url' /* from User: jmartinez | Function: delete_xml_idlink() */</span><br></div><div><br></div><div><span style="font-size:13.3333px">Error # 1146: Table 'cqpweb_db.idlink_values' doesn't exist</span></div><div><span style="font-size:13.3333px"><br></span></div><div><span style="font-size:13.3333px">I then tried to delete the corpus and start from scratch again, but this seems not to work either:</span></div><div><span style="font-size:13.3333px"><br></span></div><div><div><span style="font-size:13.3333px">A MySQL query did not run successfully!</span></div><div><br></div><div><span style="font-size:13.3333px">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></div><div><br></div><div><span style="font-size:13.3333px">Error # 1146: Table 'cqpweb_db.idlink_values' doesn't exist</span></div></div><div><span style="font-size:13.3333px"><br></span></div><div><span style="font-size:13.3333px">Any help with this will be much appreciated!</span></div><div><span style="font-size:13.3333px"><br></span></div><div><span style="font-size:13.3333px">Cheers,</span></div><div><span style="font-size:13.3333px"><br></span></div></font><div><div class="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>
</div></div>