<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.apple-tab-span
{mso-style-name:apple-tab-span;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Verdana",sans-serif;
color:#1F497D;}
span.token
{mso-style-name:token;}
.MsoChpDefault
{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;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi Thilo,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">All except the first error are a result of you having SQL “strict mode” enabled. You should turn it off and try again.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Command is:
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D"> set session sql_mode = '';<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">To explain: back in 2008, strict mode defaulted to off, so that’s what CQPweb assumed. Then, they changed it to default to on. CQPweb
currently switches it off internally, but I’m working towards compliance with strict mode to make that unnecessary.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">To make the third one work, you also need to prepare by setting the time zone:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"> set time_zone = '+00:00';<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">As for the first…
<i>either</i> someone was using the system when you were trying to upgrade, <i>or</i> there are old leaked values in the table. Either way it can be fixed hence:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-indent:36.0pt"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">delete from `system_longvalues`;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">… before trying again.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">best<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> cwb-bounces@sslmit.unibo.it <cwb-bounces@sslmit.unibo.it>
<b>On Behalf Of </b>Thilo Wiertz<br>
<b>Sent:</b> 15 July 2019 08:55<br>
<b>To:</b> Open source development of the Corpus WorkBench <cwb@sslmit.unibo.it><br>
<b>Subject:</b> Re: [CWB] CQPweb upgrade to 3.2-latest upgrade-database fails<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi Andrew,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">thanks so much! Since the server and its corpora are actively used I went through the SQL statements. It worked, meaning that the server is up and queries on corpora work. Still I got a few error messages while doing the SQL:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">mysql> alter table `system_longvalues` modify column `id` int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">ERROR 1366 (HY000): Incorrect integer value: 'g2srcd97b0' for column 'id' at row 1<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">mysql> alter table `user_info` modify column `linefeed` enum ("au", "a", "d", "da") NOT NULL;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">ERROR 1067 (42000): Invalid default value for 'last_seen_time'<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">mysql> alter table `user_info` modify column `acct_create_time` timestamp NOT NULL default "1970-01-01 00:00:01";<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">ERROR 1067 (42000): Invalid default value for 'last_seen_time'<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">mysql> alter table `user_info` modify column `coll_statistic` tinyint(2) unsigned NOT NULL default 0;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_seen_time' at row 5<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">mysql> alter table `user_info` modify column `coll_freqtogether` smallint unsigned NOT NULL default 0 ;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_seen_time' at row 5<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">mysql> alter table `user_info` modify column `coll_freqtogether` smallint unsigned NOT NULL default 0 ;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_seen_time' at row 5<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal">I guess this suggests that not all column type conversions were successful. Is this going to cause trouble (in the future)?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Best,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Thilo<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:5.0pt;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
Am 15.07.2019 um 00:32 schrieb Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>>:<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D">Hi Thilo,</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D">The message “</span>Table 'cqpweb_db.idlink_values' doesn't exist<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D">” indicates that something was amiss
in your database setup already, as that table certainly<i>should</i><span class="apple-converted-space"> </span>have existed.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D">If you already have many corpora in your system, I suggest you create the table using the create statement on line 1015 of upgrade-database; then manually apply all statements from
line 367 to line 596 to complete the upgrade (and then finally run <b>update system_info set value = '3.2.37' where setting_name = 'db_version';</b><span class="apple-converted-space"> </span> )</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D">If you don’t have many (or any!) corpora installed, or if your corpora use external CWB indexes, it may take less time to go the more radical route: delete your corpora, nuke the
entire DB and then run autosetup to reinstall the system, then re-index your corpora from scratch.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D">best</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D">Andrew.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
</div>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<b><span lang="EN-US">From:</span></b><span class="apple-converted-space"><span lang="EN-US"> </span></span><a href="mailto:cwb-bounces@sslmit.unibo.it"><span lang="EN-US" style="color:purple">cwb-bounces@sslmit.unibo.it</span></a><span class="apple-converted-space"><span lang="EN-US"> </span></span><span lang="EN-US"><</span><a href="mailto:cwb-bounces@sslmit.unibo.it"><span lang="EN-US" style="color:purple">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US">><span class="apple-converted-space"> </span><b>On
Behalf Of<span class="apple-converted-space"> </span></b>Thilo Wiertz<br>
<b>Sent:</b><span class="apple-converted-space"> </span>12 July 2019 14:04<br>
<b>To:</b><span class="apple-converted-space"> </span>Open source development of the Corpus WorkBench <</span><a href="mailto:cwb@sslmit.unibo.it"><span lang="EN-US" style="color:purple">cwb@sslmit.unibo.it</span></a><span lang="EN-US">><br>
<b>Subject:</b><span class="apple-converted-space"> </span>[CWB] CQPweb upgrade to 3.2-latest upgrade-database fails</span><o:p></o:p></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
Dear Andrew, dear all,<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
I just tried to upgrade my server to 3.2-latest after swichting to the new 3.2 branch. The upgrade-database.php script breaks with the following error:<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<o:p></o:p></p>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
An SQL query did not run successfully!<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
Original query:<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
alter table `idlink_values` modify column `corpus` varchar(20) CHARSET ascii COLLATE ascii_bin NOT NULL<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<span class="apple-tab-span"> </span><span class="apple-converted-space"> </span>/* from User: ??? | Function: upgrade_3_2_36() | 2019-Jul-12 14:58 */<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
Error # 1146: Table 'cqpweb_db.idlink_values' doesn't exist<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
Thanks for your help!<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
Best,<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
Thilo<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<br>
<br>
<br>
<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:5.0pt;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
Am 04.07.2019 um 11:41 schrieb Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk"><span style="color:purple">a.hardie@lancaster.ac.uk</span></a>>:<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:72.0pt;margin-bottom:0cm;margin-left:72.0pt;margin-bottom:.0001pt">
<o:p></o:p></p>
</div>
<div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif">Hi all,</span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif"> </span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif">I have branched off the 3.2.39+ line of CQPweb. Those of you who are running servers that follow the SVN dev version will probably want to flip over to the branch until further notice, as<span class="apple-converted-space"> </span><b>the
trunk will be broken, starting today</b>.</span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif"> </span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif">(SVN Command for this below.)</span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif"> </span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif">The 3.2 branch will continue to receive bug fixes indefinitely, and minor function updates until the trunk diverges enough to make doing so a pain. When it reaches a steady state, hopefully in
no more than a month, I’ll export it as a new tarball and create a new CQPwebInABox image.</span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif"> </span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif">The trunk will go to version 3.2.999, just to keep everything numerical. Once I am reasonably happy that it is safe for people to switch live servers back to the trunk, I’ll announce it to the
list and the version number will become 3.3.0.</span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif"> </span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif">The major change will be to enable full coverage of UTF-8 – as more and more people want to index texts that may contain emojis, using the stunted mysql 3-byte legacy version of UTF-8 is increasingly
a showstopper.<span class="apple-converted-space"> </span></span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif"> </span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif">After 3.3.0 arrives, I hope to take some time away from CQPweb dev work to focus on improving the manual, recording more tutorial videos, and possibly even some work on Ziggurat.</span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif"> </span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif">best</span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif"> </span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif">Andrew.</span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif"> </span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif">===================</span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif"> </span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif">To switch from the trunk to the 3.2 branch, cd to the root of your checkout, and run:</span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif"> </span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt;text-indent:36.0pt">
<b><span style="font-size:10.0pt;font-family:"Courier New"">svn switch<span class="apple-converted-space"> </span></span></b><a href="https://svn.code.sf.net/p/cwb/code/gui/cqpweb/branches/3.2-latest"><b><span style="font-size:10.0pt;font-family:"Courier New";color:purple">https://svn.code.sf.net/p/cwb/code/gui/cqpweb/branches/3.2-latest</span></b></a><span class="apple-converted-space"><b><span style="font-size:10.0pt;font-family:"Courier New""> </span></b></span><b><span style="font-size:10.0pt;font-family:"Courier New"">.</span></b><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif"> </span><o:p></o:p></p>
</div>
</div>
<div>
<div style="margin-left:36.0pt;margin-right:36.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:0cm;margin-left:108.0pt;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:"Verdana",sans-serif">… note final dot.</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:108.0pt;margin-bottom:5.0pt;margin-left:108.0pt">
<span style="font-size:12.0pt;font-family:"Helvetica",sans-serif">_______________________________________________<br>
CWB mailing list<br>
</span><a href="mailto:CWB@sslmit.unibo.it"><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif;color:purple">CWB@sslmit.unibo.it</span></a><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif"><br>
</span><a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb"><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif;color:purple">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</span></a><o:p></o:p></p>
</div>
</blockquote>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt">
<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:5.0pt;margin-left:36.0pt">
<span style="font-size:12.0pt;font-family:"Helvetica",sans-serif">_______________________________________________<br>
CWB mailing list<br>
</span><a href="mailto:CWB@sslmit.unibo.it"><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif;color:purple">CWB@sslmit.unibo.it</span></a><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif"><br>
</span><a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb"><span style="font-size:12.0pt;font-family:"Helvetica",sans-serif;color:purple">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</span></a><o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>