<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=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@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;
        mso-fareast-language:EN-US;}
h2
        {mso-style-priority:9;
        mso-style-link:"Heading 2 Char";
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:18.0pt;
        font-family:"Calibri",sans-serif;
        font-weight:bold;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:#0563C1;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:#954F72;
        text-decoration:underline;}
code
        {mso-style-priority:99;
        font-family:"Courier New";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
        {mso-style-priority:34;
        margin-top:0cm;
        margin-right:0cm;
        margin-bottom:0cm;
        margin-left:36.0pt;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri",sans-serif;
        mso-fareast-language:EN-US;}
span.EmailStyle17
        {mso-style-type:personal-compose;
        font-family:"Verdana",sans-serif;
        color:windowtext;}
span.Heading2Char
        {mso-style-name:"Heading 2 Char";
        mso-style-priority:9;
        mso-style-link:"Heading 2";
        font-family:"Calibri",sans-serif;
        mso-fareast-language:EN-GB;
        font-weight:bold;}
span.arabic
        {mso-style-name:arabic;}
span.textbf
        {mso-style-name:textbf;}
span.texttt
        {mso-style-name:texttt;}
span.textit
        {mso-style-name:textit;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-family:"Calibri",sans-serif;
        mso-fareast-language:EN-US;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
/* List Definitions */
@list l0
        {mso-list-id:1349335653;
        mso-list-type:hybrid;
        mso-list-template-ids:-419543370 134807553 134807555 134807557 134807553 134807555 134807557 134807553 134807555 134807557;}
@list l0:level1
        {mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        font-family:Symbol;}
@list l0:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        font-family:"Courier New";}
@list l0:level3
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        font-family:Wingdings;}
@list l0:level4
        {mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        font-family:Symbol;}
@list l0:level5
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        font-family:"Courier New";}
@list l0:level6
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        font-family:Wingdings;}
@list l0:level7
        {mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        font-family:Symbol;}
@list l0:level8
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        font-family:"Courier New";}
@list l0:level9
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        font-family:Wingdings;}
ol
        {margin-bottom:0cm;}
ul
        {margin-bottom:0cm;}
--></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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">Hi everyone,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">The big CQPweb changeover to version 3.3 is now &#8220;complete&#8221;.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">By putting &#8220;complete&#8221; in quotes I mean that all the new and revised features and architectural changes are finished &#8211; but it&#8217;s anticipated that there are still lots of bugs
 that I&#8217;ve failed to spot. Also, the documentation has not yet been fully updated, though parts have (below is the current version of the new manual section discussing the upgrade, itself not wholly complete).
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">If you are an adventurous sort who does not mind working with the bugs (or, even better, reporting them here or on sourceforge.net) then you can now switch over from the 3.2
 branch to the trunk. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">Most users should probably stick to v3.2.42 for a while yet though, till v3.3.1 or v3.3.2 &#8230;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">Note that this new version requires:<o:p></o:p></span></p>
<ul style="margin-top:0cm" type="disc">
<li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo1"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">PHP 7.3&#43;<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo1"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">CWB 3.4.21 (i.e. the very latest and greatest)<o:p></o:p></span></li></ul>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">Over the next two to three weeks I intend to (a) upgrade the Lancaster server in the hope that having a big live server using v3.3 will shake out bugs as quickly as possible;
 (b) fix all now-obsolete passages in the manual. Later goals include (c) updating the now out-of-date YouTube tutorials, (d) get a CQPwebInABox virtual machine image ready and released.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">Thank you all for bearing with me.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">best<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">================================<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<h2><span class="arabic"><span style="font-family:&quot;Times New Roman&quot;,serif;color:black">15</span></span><span style="font-family:&quot;Times New Roman&quot;,serif;color:black">.<span class="arabic">11</span>&nbsp;Updating to version 3.3.0<o:p></o:p></span></h2>
<p style="font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: initial;word-spacing:0px">
<span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">Various major changes were made in the move from 3.2 to 3.3.<o:p></o:p></span></p>
<p style="font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: initial;word-spacing:0px">
<span class="textbf"><span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">Extra code files (CSS and JavaScript)</span></span><span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">: these were previously to
 be placed in the&nbsp;<span class="texttt">css</span>&nbsp;and&nbsp;<span class="texttt">jsc</span>&nbsp;folders within the main CQPweb directory. From v3.3.0 onwards, they should instead be placed in the&nbsp;<span class="texttt">extra</span>&nbsp;subdirectories (that is:&nbsp;<span class="texttt">css/extra</span>&nbsp;and&nbsp;<span class="texttt">jsc/extra</span>).
 See&nbsp;<a href="node93.html#sec:visualise:xml:extra-code">10.4.6</a><o:p></o:p></span></p>
<p style="font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: initial;word-spacing:0px">
<span class="textbf"><span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">Plugins</span></span><span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">: PHP files for plugins are no longer directly contained
 in&nbsp;<span class="texttt">lib/plugins</span>. Instead, that folder contains a folder tree called&nbsp;<span class="texttt">builtin</span>, which has one folder per type of plugin; e.g.&nbsp;<span class="texttt">lib/plugins/builtin/CorpusInstaller</span>.<o:p></o:p></span></p>
<p style="font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: initial;word-spacing:0px">
<span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">Plugins do still need to be in&nbsp;<span class="texttt">lib/plugins</span>&nbsp;to be used; the principle is that you should create a symlink to just those builtin plugins that you wish to
 use, as follows:<o:p></o:p></span></p>
<p style="font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: initial;word-spacing:0px">
<code><span style="font-size:10.0pt;color:black">cqpweb/lib/plugins &gt; ln -s builtin/CorpusInstaller/BasicVrtInstaller.php</span></code><span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black"><o:p></o:p></span></p>
<p style="font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: initial;word-spacing:0px">
<span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">This system was added because, as the number of builtin plugins increased, the plugins folder became harder to manage.<o:p></o:p></span></p>
<p style="font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: initial;word-spacing:0px">
<span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">A&nbsp;<span class="texttt">local</span>&nbsp;folder, with the same subdirectories as&nbsp;<span class="texttt">builtin</span>, is provided for convenience; it is for you to place your own plugins
 into. However, you can symlink (or copy) your plugins from anywhere. You do not&nbsp;<span class="textit">have</span>&nbsp;to use&nbsp;<span class="texttt">lib/plugins/local</span>.<o:p></o:p></span></p>
<p style="font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: initial;word-spacing:0px">
<span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">See&nbsp;<a href="node104.html#sec:plugins">12</a>.<o:p></o:p></span></p>
<p style="font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: initial;word-spacing:0px">
<span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">The database upgrade procedure for 3.3.0 involves major architectural changes. It may take a long time to run. So, it is recommended to run the process with your CQPweb server offline
 (see&nbsp;<a href="node20.html#sec:config-file:variables-optional:misc">2.3.10</a>&nbsp;on the&nbsp;</span><code><span style="font-size:10.0pt;color:black">$cqpweb_switched_off</span></code><span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">&nbsp;setting).<o:p></o:p></span></p>
<p style="font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-text-stroke-width: 0px;text-decoration-style: initial;text-decoration-color: initial;word-spacing:0px">
<span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">Because this is a major upgrade, it is possible to generate the SQL commands that will run during upgrade without running them, by adding the&nbsp;</span><code><span style="font-size:10.0pt;color:black">--rehearse</span></code><span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">&nbsp;flag
 to the call to the upgrade-database script. A second flag,&nbsp;</span><code><span style="font-size:10.0pt;color:black">--stepwise</span></code><span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">, allows you to run the upgrade a chunk
 at a time (you must keep running the script repeatedly until all chunks are complete). Note that&nbsp;</span><code><span style="font-size:10.0pt;color:black">--rehearse</span></code><span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">&nbsp;implies&nbsp;</span><code><span style="font-size:10.0pt;color:black">--stepwise</span></code><span style="font-size:13.5pt;font-family:&quot;Times New Roman&quot;,serif;color:black">,
 i.e. you can't rehearse the second phase until you have run the first stage for real (and so on).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif">================================<o:p></o:p></span></p>
</div>
</body>
</html>