<div dir="ltr"><div dir="ltr"><div>Deleting that code gives me various syntax errors, likely because after deletion a section now begins out of nowhere with 'alter table `query_history` drop key `user`'.<br></div><div><br></div><div>Should the deletions not continue past <span style="font-family:"Courier New"">‘alter table `query_history` drop key `corpus`’</span>?, </div><div><br></div><div>Best,</div><div>Scott</div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jun 7, 2019 at 7:01 AM Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</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">
<div lang="EN-GB">
<div class="gmail-m_2495368818503797056WordSection1">
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Delete the line<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New"">‘alter table `query_history` drop key `corpus`’,</span><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">and everything before it right back to the bit that asks “</span><span style="font-family:"Courier New"">Do you wish to continue running
the uipgrade now?</span><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">”<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">from upgrade-database.php<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Then run again.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">This happened because your original DB setup was between 3.2.36 and 3.2.37<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">best<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Andrew.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> <a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a> <<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a>>
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 07 June 2019 11:36<br>
<b>To:</b> Open source development of the Corpus WorkBench <<a href="mailto:CWB@liste.sslmit.unibo.it" target="_blank">CWB@liste.sslmit.unibo.it</a>><br>
<b>Subject:</b> [CWB] [CQPweb r1236] SQL error when updating DB<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Sorry for the flood of messages, folks! When I update to r1236 and try to update the DB, I get the following error:<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New";color:black">Current DB version is 3.2.36 ; target version is 3.2.37 . About to upgrade....
</span><span style="font-family:"Courier New""><br>
=========================================================================== <br>
Please note, some of the operations in this upgrade are time-consuming <br>
(especially if your installation has a long history). <br>
It is recommended that you run this upgrade in a quiet period, and <br>
(ideally) with CQPweb in "switched-off" mode if it is accessible to <br>
users other than you. <br>
=========================================================================== <br>
Do you wish to continue running the uipgrade now? <br>
Enter [Y]es or [N]:y <br>
<b>An SQL query did not run successfully! </b><br>
Original query: <br>
alter table `query_history` drop key `corpus` <br>
/* from User: ??? | Function: upgrade_3_2_36() | 2019-Jun-07 07:35 */ <br>
<b>Error # 1091: Can't DROP 'corpus'; check that column/key exists</b></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u><br></p></div></div></div></div></blockquote></div></div>