<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>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:</p>
<p>sudo php upgrade-database.php<br />Current DB version is 3.2.31 ; target version is 3.2.40 . About to upgrade....</p>
<p>An SQL query did not run successfully!<br />Original query:</p>
<p>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'</p>
<p><br /></p>
<p>Greetings from Saarbrücken,</p>
<p><br /></p>
<p>Jörg Knappen</p>
<p><br /></p>
<p><br /></p>
<p id="reply-intro">Am 2020-01-07 22:00, 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>
<div dir="auto" style="color: #212121; background-color: #ffffff; text-align: left;">1406 was a commit to the trunk. The trunk is still thoroughly broken until v3.3.0 is finished! The 3.2 branch works.</div>
<div dir="auto" style="color: #212121; background-color: #ffffff; text-align: left;"> </div>
<div dir="auto" style="color: #212121; background-color: #ffffff; text-align: left;">Andrew.</div>
<div id="v1ms-outlook-mobile-signature" dir="auto" style="text-align: left;">
<div> </div>
</div>
<div class="v1ms-outlook-mobile-reference-message">
<div style="font-family: sans-serif; font-size: 12pt; color: #000000;"> </div>
<hr style="display: inline-block; width: 98%;" />
<div id="v1divRplyFwdMsg"><strong>From:</strong> cwb-bounces@sslmit.unibo.it <cwb-bounces@sslmit.unibo.it> on behalf of Jörg Knappen <j.knappen@mx.uni-saarland.de><br /><strong>Sent:</strong> Tuesday, 7 January 2020, 5:03 pm<br /><strong>To:</strong> cwb@sslmit.unibo.it<br /><strong>Subject:</strong> [CWB] Error updating cqpweb</div>
</div>
</div>
</div>
</blockquote>
</blockquote>
<style type="text/css">#replybody1 .v1EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; }</style>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<div id="replybody1">
<div>
<div id="v1id-b1cc88b3-957d-44c1-8072-c80aab87cfbc" class="v1ms-outlook-mobile-reference-message">
<div class="v1PlainText"><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 />CWB@sslmit.unibo.it<br /><a href="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" 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></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>