<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hallo Andrew,</p>
<p><br /></p>
<p>this is rather strange. I examined my production instance of cqpweb 3.20.31 and when my files are consistent (what I sincerely hope! at least, it worked for a full year for us) than the following is the case:</p>
<p>Upgrading the database from an older installation (as we did for the production instance) does not add the column sttr_1kw to the table corpus_info (verfied from looking at the database AND looking at the upgrade-database.php from that version)</p>
<p>BUT</p>
<p>Building the database from scratch (as I did in my test instance) already has the column sttr_1kw to the table corpus_info (verified from looking at the database AND looking into sql-definitions.inc.php at that version).</p>
<p>All other changes in the database are not affected by this difference.</p>
<p>Deleting the line causing the error resulted in a smooth upgrade on my test instance.</p>
<p>Greetings from Saarbrücken,</p>
<p><br /></p>
<p>Jörg Knappen</p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p id="reply-intro">Am 2020-01-09 21:42, schrieb Hardie, Andrew:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<div> </div>
</blockquote>
</blockquote>
<style type="text/css">@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
#replybody1 p.v1MsoNormal, #replybody1 li.v1MsoNormal, #replybody1 div.v1MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
#replybody1 a:link, #replybody1 span.v1MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
#replybody1 a:visited, #replybody1 span.v1MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
#replybody1 p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
#replybody1 p.v1msonormal0, #replybody1 li.v1msonormal0, #replybody1 div.v1msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
#replybody1 p.v1v1emailquote, #replybody1 li.v1v1emailquote, #replybody1 div.v1v1emailquote
{mso-style-name:v1emailquote;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
#replybody1 p.v1v1emailquote1, #replybody1 li.v1v1emailquote1, #replybody1 div.v1v1emailquote1
{mso-style-name:v1emailquote1;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:1.0pt;
border:none;
padding:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
#replybody1 span.v1EmailStyle22
{mso-style-type:personal-reply;
font-family:"Verdana",sans-serif;
color:#1F497D;}
#replybody1 .v1MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
#replybody1 div.v1WordSection1
{page:WordSection1;}</style>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<div id="replybody1">
<div lang="EN-GB">
<div class="v1WordSection1">
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #1f497d; mso-fareast-language: EN-US;">This error message indicates that you were already upgraded past the 3.2.31 point (partly or wholly). You can check this by looking at the commands inn upgrade-database.php lines 750 to 796, comparing them to your existing sql database, and seeing how many of them have already taken effect.</span></p>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #1f497d; mso-fareast-language: EN-US;"> </span></p>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #1f497d; mso-fareast-language: EN-US;">If you delete the lines for database changes that have already happened, the rest of script should run correctly.</span></p>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #1f497d; mso-fareast-language: EN-US;"> </span></p>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #1f497d; mso-fareast-language: EN-US;">BTW upgrade-database shouldn't normally require sudo.</span></p>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #1f497d; mso-fareast-language: EN-US;"> </span></p>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #1f497d; mso-fareast-language: EN-US;">best</span></p>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #1f497d; mso-fareast-language: EN-US;"> </span></p>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #1f497d; mso-fareast-language: EN-US;">Andrew</span></p>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #1f497d; mso-fareast-language: EN-US;"> </span></p>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #1f497d; mso-fareast-language: EN-US;"> </span></p>
<div>
<div style="border: none; border-top: solid #E1E1E1 1.0pt; padding: 3.0pt 0cm 0cm 0cm;">
<p class="v1MsoNormal"><strong><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;">From:</span></strong><span style="font-size: 11.0pt; font-family: 'Calibri',sans-serif;"> Jörg Knappen <j.knappen@mx.uni-saarland.de> <br /><strong>Sent:</strong> 09 January 2020 20:26<br /><strong>To:</strong> Open source development of the Corpus WorkBench <cwb@sslmit.unibo.it><br /><strong>Cc:</strong> Hardie, Andrew <a.hardie@lancaster.ac.uk><br /><strong>Subject:</strong> Re: [CWB] Error updating cqpweb</span></p>
</div>
</div>
<p class="v1MsoNormal"> </p>
<div>
<p><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;">OK, that was too risky. I restored the old version of cqpweb on my test server and tried an update within the 3.2-latest branch, leading to the following error:</span></p>
<p><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;">sudo php upgrade-database.php<br />Current DB version is 3.2.31 ; target version is 3.2.40 . About to upgrade....</span></p>
<p><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;">An SQL query did not run successfully!<br />Original query:</span></p>
<p><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;">alter table `corpus_info` add column `sttr_1kw` float DEFAULT 0.0 after `size_bytes_freq` <br />/* from User: ??? | Function: upgrade_3_2_31() | 2020-Jan-09 21:21 */<br />Error # 1060: Duplicate column name 'sttr_1kw'</span></p>
<p><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;"> </span></p>
<p><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;">Greetings from Saarbrücken,</span></p>
<p><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;"> </span></p>
<p><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;">Jörg Knappen</span></p>
<p><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;"> </span></p>
<p><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;"> </span></p>
<p id="v1reply-intro"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;">Am 2020-01-07 22:00, schrieb Hardie, Andrew:</span></p>
<blockquote style="border: none; border-left: solid #1010FF 1.5pt; padding: 0cm 0cm 0cm 5.0pt; margin-left: 0cm; margin-right: 0cm;">
<blockquote style="border: none; border-left: solid #1010FF 1.5pt; padding: 0cm 0cm 0cm 5.0pt; margin-left: 0cm; margin-right: 0cm;">
<div>
<div>
<p class="v1MsoNormal" style="background: white;"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #212121;">1406 was a commit to the trunk. The trunk is still thoroughly broken until v3.3.0 is finished! The 3.2 branch works.</span></p>
<p class="v1MsoNormal" style="background: white;"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #212121;"> </span></p>
<p class="v1MsoNormal" style="background: white;"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif; color: #212121;">Andrew.</span></p>
<div>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;"> </span></p>
</div>
<div>
<div>
<p class="v1MsoNormal"><span style="font-family: 'Arial',sans-serif; color: black;"> </span></p>
</div>
<div class="v1MsoNormal" style="text-align: center;" align="center"><hr align="center" size="2" width="98%" /></div>
<div id="v1v1divRplyFwdMsg">
<p class="v1MsoNormal"><strong><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;">From:</span></strong><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;"> <a href="mailto:cwb-bounces@sslmit.unibo.it" rel="noreferrer">cwb-bounces@sslmit.unibo.it</a> <<a href="mailto:cwb-bounces@sslmit.unibo.it" rel="noreferrer">cwb-bounces@sslmit.unibo.it</a>> on behalf of Jörg Knappen <<a href="mailto:j.knappen@mx.uni-saarland.de" rel="noreferrer">j.knappen@mx.uni-saarland.de</a>><br /><strong><span style="font-family: 'Verdana',sans-serif;">Sent:</span></strong> Tuesday, 7 January 2020, 5:03 pm<br /><strong><span style="font-family: 'Verdana',sans-serif;">To:</span></strong> <a href="mailto:cwb@sslmit.unibo.it" rel="noreferrer"> cwb@sslmit.unibo.it</a><br /><strong><span style="font-family: 'Verdana',sans-serif;">Subject:</span></strong> [CWB] Error updating cqpweb</span></p>
</div>
</div>
</div>
</div>
</blockquote>
</blockquote>
<blockquote style="border: none; border-left: solid #1010FF 1.5pt; padding: 0cm 0cm 0cm 5.0pt; margin-left: 0cm; margin-right: 0cm;">
<div id="v1replybody1">
<div>
<div id="v1v1id-b1cc88b3-957d-44c1-8072-c80aab87cfbc">
<div>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;"><br />I tried to update our cqpweb installation to the most recent developer<br />version (revision 1406) and got the following error:<br /><br />sudo php bin/upgrade-database.php<br />PHP Parse error: syntax error, unexpected ']', expecting '-' or<br />identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING)<br />in /data2/htdocs/cqpweb/bin/upgrade-database.php on line 321<br /><br /><br />Trying to run it without database upgrade produced a similar runtime<br />error from a different code location:<br /><br />[Tue Jan 07 17:47:08.603359 2020] [php7:emerg] [pid 2503] [client<br />xxx.yyy.zzz.aaa:49958] PHP Parse error: syntax error, unexpected ''<br />(T_ENCAPSED_AND_WHITESPACE), expecting '-' or identifier (T_STRING) or<br />variable (T_VARIABLE) or number (T_NUM_STRING) in<br />/data2/htdocs/cqpweb/lib/sql-lib.php on line 2128<br /><br />--Jörg Knappen<br /><br /><br />_______________________________________________<br />CWB mailing list<br /><a href="mailto:CWB@sslmit.unibo.it" rel="noreferrer">CWB@sslmit.unibo.it</a><br /><a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7Cfcb9b9b702f746ff143a08d795421ac3%7C9c9bcd11977a4e9ca9a0bc734090164a%7C1%7C0%7C637141983466164254&sdata=c5Ls5M6iPgEhEpvngfyaNwttmAi39VMWejT8QJRNNhk%3D&reserved=0" target="_blank" rel="noopener noreferrer">https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&amp;data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7C31f839722e0d424c711508d793938773%7C9c9bcd11977a4e9ca9a0bc734090164a%7C1%7C1%7C637140134170197160&amp;sdata=LHgMxQmA3xxLLPI0OUMik1mys8zcPZr646YFbflo8xE%3D&amp;reserved=0</a></span></p>
</div>
</div>
</div>
</div>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;"> </span></p>
<div>
<p class="v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Courier New';">_______________________________________________<br />CWB mailing list<br /><a href="mailto:CWB@sslmit.unibo.it" rel="noreferrer">CWB@sslmit.unibo.it</a><br /><a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7Cfcb9b9b702f746ff143a08d795421ac3%7C9c9bcd11977a4e9ca9a0bc734090164a%7C1%7C0%7C637141983466164254&sdata=c5Ls5M6iPgEhEpvngfyaNwttmAi39VMWejT8QJRNNhk%3D&reserved=0" target="_blank" rel="noopener noreferrer">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a></span></p>
</div>
</blockquote>
<p><span style="font-size: 10.0pt; font-family: 'Verdana',sans-serif;"> </span></p>
</div>
</div>
</div>
</div>
<br />
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">_______________________________________________<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" target="_blank" rel="noopener noreferrer">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a></div>
</blockquote>
<p><br /></p>
</body></html>