<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 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 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:12.0pt;
font-family:"Times New Roman","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
{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";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-GB;}
p.gmail-msonormal, li.gmail-msonormal, div.gmail-msonormal
{mso-style-name:gmail-msonormal;
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";}
span.gmail-
{mso-style-name:gmail-;}
span.gmail-apple-tab-span
{mso-style-name:gmail-apple-tab-span;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Verdana","sans-serif";
color:#1F497D;}
span.EmailStyle24
{mso-style-type:personal;
font-family:"Verdana","sans-serif";
color:#1F497D;}
span.EmailStyle25
{mso-style-type:personal-reply;
font-family:"Verdana","sans-serif";
color:#1F497D;}
.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">Hi Scott & anyone else interested,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">The bug here was the use of “text” as a sub-text XML element. “text” is special and has to be treated as such, otherwise things go wrong.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">What was going wrong in this case was that the query form was requesting a restriction on text, but as a sub-text XML element, not using the actual text-metadata
backend. The system tried to fulfil the request using the text-metadata backend, but couldn’t because it wasn’t set up. Result: big honking crash.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">I have just now committed to the repo a fix that stops the restriction block from showing text as a sub-text XML element. This means that what was previously
a non-obviously incorrect way of doing things will simply no longer work. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">The
<i>correct</i> way in this case is to generate a text-metadata table from the data stored in the “text_*” XML attributes, using the variant of the install-text-metadata table accessed via the “” button.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> cwb-bounces@liste.sslmit.unibo.it [mailto:cwb-bounces@liste.sslmit.unibo.it]
<b>On Behalf Of </b>Hardie, Andrew<br>
<b>Sent:</b> 28 July 2016 16:25<br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> Re: [CWB] WebInABox: Can't import existing corpora from host<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Hi Scott,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">This is a bug. It arises, as best as I can tell, from confusion between a text-level restriction, and a restriction on the <text> XML object (equivalent, but
distinct due to the fact that text metadata exists separately from the XML metadata from which it derives, which in turn is a consequence of the special status of “text” as an entitity in CQPweb). Can you send me (off list) screenshots of the search form with
the tickboxes you selected that led to this error? I will then investigate.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:cwb-bounces@liste.sslmit.unibo.it">cwb-bounces@liste.sslmit.unibo.it</a> [<a href="mailto:cwb-bounces@liste.sslmit.unibo.it">mailto:cwb-bounces@liste.sslmit.unibo.it</a>]
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 26 July 2016 17:53<br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Cc:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> Re: [CWB] WebInABox: Can't import existing corpora from host<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal">On Tue, Jul 26, 2016 at 12:18 PM, Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> wrote:<o:p></o:p></p>
</div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="gmail-msonormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">>>></span> But how do I restrict searches using the s-attributes (say, speaker sex)? When I do a query and then select "Distribution", for example, I'm
told that "This corpus has no text-classification metadata, so the distribution cannot be shown".<span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:Symbol;color:#1F497D">·</span><span style="font-size:7.0pt;color:#1F497D">
</span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Go to Restricted query</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:Symbol;color:#1F497D">·</span><span style="font-size:7.0pt;color:#1F497D">
</span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">You should see options to restrict your query to XML segments where the given attribute has a particular category handle for any s-att that you set to datatype “Classifcation”</span><o:p></o:p></p>
</div>
</div>
</blockquote>
<div>
<p class="MsoNormal">Thanks. That makes sense.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">When I run one of these queries, though, CQPweb throws an SQL error (pasted below).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<div>
<p><span style="font-size:10.0pt;font-family:Symbol;color:#1F497D">·</span><span style="font-size:7.0pt;color:#1F497D">
</span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">OR, go to “Create / edit subcorpora” and define subcorpora using the same control, then use those SCs as restriction criteria.</span><o:p></o:p></p>
</div>
</div>
</blockquote>
<div>
<p class="MsoNormal">This also throws an error (also pasted below).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<p class="gmail-msonormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> Note that non-text-based corpus restrictions and subcorpora aren’t currently supported in the Distribution display. I know this is a pain, and it’s high
on my feature list. (but quite a big job so can’t be done quickly!) </span><o:p></o:p></p>
</div>
</blockquote>
<div>
<p class="MsoNormal">I can only imagine! <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks again,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Scott<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>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">===== ERROR 1 =====</span><o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">CQPweb encountered an error and could not continue.</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">A MySQL query did not run successfully!</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">Original query: SELECT count(*), sum(words) FROM text_metadata_for_test_coscach WHERE /* from User: user | Function: do_append_mysql_comment() | 2016-Jul-26 16:42:47 */</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">Error # 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">PHP debugging backtrace</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">array(7) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [1]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(4) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["file"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(40) "/var/www/html/cqpweb/lib/library.inc.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["line"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(282)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["function"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(20) "exiterror_mysqlquery"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["args"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(3) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [0]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &int(1064)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [1]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &string(146) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [2]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &string(156) "SELECT count(*), sum(words) FROM text_metadata_for_test_coscach WHERE </span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span class="gmail-apple-tab-span"><span style="font-size:7.5pt;font-family:"Courier New"">
</span></span><span style="font-size:7.5pt;font-family:"Courier New"">/* from User: user | Function: do_append_mysql_comment() | 2016-Jul-26 16:42:47 */"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [2]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(4) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["file"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(42) "/var/www/html/cqpweb/lib/subcorpus.inc.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["line"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(1556)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["function"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(14) "do_mysql_query"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["args"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(1) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [0]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &string(71) "SELECT count(*), sum(words) FROM text_metadata_for_test_coscach WHERE "</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [3]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(7) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["file"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(42) "/var/www/html/cqpweb/lib/subcorpus.inc.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["line"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(1214)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["function"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(15) "initialise_size"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["class"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(11) "Restriction"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["object"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> object(Restriction)#14 (15) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["serialised":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(26) "$^text|location~concepcion"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["parsed_conditions":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(1) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["text"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(1) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [0]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(19) "location~concepcion"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["stored_text_metadata_where":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["stored_idlink_where":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["cpos_collection":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["corpus":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(12) "test_coscach"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["item_type":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(4) "text"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["n_items":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["n_tokens":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["freqtable_record":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["hasrun_initialise_text_metadata_where":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> bool(false)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["hasrun_initialise_idlink_where":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> bool(false)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["hasrun_initialise_cpos_collection":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> bool(false)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["hasrun_initialise_size":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> bool(false)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["needs_to_be_added_to_cache":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> bool(false)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["type"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(2) "->"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["args"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(0) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [4]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(6) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["file"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(42) "/var/www/html/cqpweb/lib/subcorpus.inc.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["line"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(670)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["function"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(12) "new_from_url"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["class"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(11) "Restriction"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["type"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(2) "::"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["args"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(2) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [0]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &string(85) "theData=gente&qmode=sq_nocase&pp=50&del=begin&t=text|location~concepcion&del=end&uT=y"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [1]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &bool(true)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [5]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(7) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["file"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(42) "/var/www/html/cqpweb/lib/subcorpus.inc.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["line"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(589)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["function"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(14) "parse_from_url"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["class"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(10) "QueryScope"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["object"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> object(QueryScope)#15 (4) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["type"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(0)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["restriction":"QueryScope":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["subcorpus":"QueryScope":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["serialised":"QueryScope":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(0) ""</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["type"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(2) "->"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["args"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(2) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [0]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &string(89) "theData=gente&qmode=sq_nocase&pp=50&del=begin&t=text%7Clocation%7Econcepcion&del=end&uT=y"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [1]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &bool(true)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [6]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(6) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["file"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(44) "/var/www/html/cqpweb/lib/concordance.inc.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["line"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(156)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["function"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(12) "new_from_url"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["class"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(10) "QueryScope"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["type"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(2) "::"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["args"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(2) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [0]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &string(89) "theData=gente&qmode=sq_nocase&pp=50&del=begin&t=text%7Clocation%7Econcepcion&del=end&uT=y"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [1]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &bool(true)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [7]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(4) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["file"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(40) "/var/www/html/cqpweb/exe/concordance.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["line"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(1)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["args"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(1) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [0]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(44) "/var/www/html/cqpweb/lib/concordance.inc.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["function"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(7) "require"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">}</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""><o:p> </o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">===== ERROR 2 =====</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">CQPweb encountered an error and could not continue.</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">A MySQL query did not run successfully!</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">Original query: SELECT count(*), sum(words) FROM text_metadata_for_test_coscach WHERE /* from User: user | Function: do_append_mysql_comment() | 2016-Jul-26 16:49:17 */</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">Error # 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> </span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">PHP debugging backtrace</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">array(5) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [1]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(4) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["file"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(40) "/var/www/html/cqpweb/lib/library.inc.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["line"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(282)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["function"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(20) "exiterror_mysqlquery"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["args"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(3) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [0]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &int(1064)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [1]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &string(146) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [2]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &string(156) "SELECT count(*), sum(words) FROM text_metadata_for_test_coscach WHERE </span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span class="gmail-apple-tab-span"><span style="font-size:7.5pt;font-family:"Courier New"">
</span></span><span style="font-size:7.5pt;font-family:"Courier New"">/* from User: user | Function: do_append_mysql_comment() | 2016-Jul-26 16:49:17 */"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [2]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(4) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["file"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(42) "/var/www/html/cqpweb/lib/subcorpus.inc.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["line"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(1556)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["function"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(14) "do_mysql_query"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["args"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(1) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [0]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &string(71) "SELECT count(*), sum(words) FROM text_metadata_for_test_coscach WHERE "</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [3]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(7) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["file"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(42) "/var/www/html/cqpweb/lib/subcorpus.inc.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["line"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(1214)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["function"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(15) "initialise_size"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["class"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(11) "Restriction"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["object"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> object(Restriction)#16 (15) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["serialised":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(26) "$^text|location~concepcion"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["parsed_conditions":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(1) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["text"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(1) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [0]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(19) "location~concepcion"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["stored_text_metadata_where":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["stored_idlink_where":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["cpos_collection":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["corpus":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(12) "test_coscach"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["item_type":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(4) "text"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["n_items":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["n_tokens":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["freqtable_record":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> NULL</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["hasrun_initialise_text_metadata_where":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> bool(false)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["hasrun_initialise_idlink_where":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> bool(false)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["hasrun_initialise_cpos_collection":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> bool(false)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["hasrun_initialise_size":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> bool(false)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["needs_to_be_added_to_cache":"Restriction":private]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> bool(false)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["type"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(2) "->"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["args"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(0) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [4]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(6) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["file"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(48) "/var/www/html/cqpweb/lib/subcorpus-admin.inc.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["line"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(128)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["function"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(12) "new_from_url"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["class"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(11) "Restriction"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["type"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(2) "::"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["args"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(1) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [0]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> &string(178) "subcorpusNewName=concepcion&action=Create+subcorpus+from+selected+categories&scriptMode=create_from_metadata&thisQ=subcorpus&del=begin&t=text%7Clocation%7Econcepcion&del=end&uT=y"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [5]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(4) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["file"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(44) "/var/www/html/cqpweb/exe/subcorpus-admin.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["line"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> int(1)</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["args"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> array(1) {</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> [0]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(48) "/var/www/html/cqpweb/lib/subcorpus-admin.inc.php"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> ["function"]=></span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> string(7) "require"</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New""> }</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Courier New"">}</span><span style="font-family:"Courier New""><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""><o:p> </o:p></span></p>
</div>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<div>
<p class="gmail-msonormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:cwb-bounces@liste.sslmit.unibo.it" target="_blank">cwb-bounces@liste.sslmit.unibo.it</a> [mailto:<a href="mailto:cwb-bounces@liste.sslmit.unibo.it" target="_blank">cwb-bounces@liste.sslmit.unibo.it</a>]
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 26 July 2016 17:12</span><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"><br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Cc:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> Re: [CWB] WebInABox: Can't import existing corpora from host<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="gmail-msonormal"> <o:p></o:p></p>
<div>
<div>
<div>
<p class="gmail-msonormal">On Tue, Jul 26, 2016 at 7:25 AM, Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> wrote:<o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"> <o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal">Hi Andrew,<o:p></o:p></p>
</div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt;border-top-width:initial;border-right-width:initial;border-bottom-width:initial;border-top-color:initial;border-right-color:initial;border-bottom-color:initial">
<div>
<div>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">I have had a dig, and found the bug (it was a regex glitch parsing the inserted registry file). Update the code to rev 880 and you should find that the system will obediently
detect your s-attributes. (You will still, naturally, need to go through the first step that IO mentioned, of making sure all data from earlier passes is properly scrubbed.)</span><o:p></o:p></p>
</div>
</div>
</blockquote>
<div>
<p class="gmail-msonormal">Eureka - with this new rev CQPweb now imports my XML metadata! Thanks so much for hunting this down and fixing it!<o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"> <o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal">I've now done the following:<o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"> <o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal">1. I went through the "Manage Corpus XML" page and set descriptions and data types, defining the attributes I want to be able to search on in queries, subqueries, sub-corpora, etc. to "classification" (e.g. speaker sex and location).<o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"> <o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal">2. I went through the "Manage Annotation" page and linked the "Annotation setup for CEQL queries" fields to the various annotation data in my corpus.<o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"> <o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal">3. On the "Manage frequency lists" page I (re)generated everything (I've attached the metadata table from mysql below).<o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"> <o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal">I can now perform queries, and my metadata is recognized. But how do I restrict searches using the s-attributes (say, speaker sex)? When I do a query and then select "Distribution", for example, I'm told that "This corpus has no text-classification
metadata, so the distribution cannot be shown".<o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"> <o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal">Thanks!<o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal">Scott<o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"> <o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"> <o:p></o:p></p>
</div>
<div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">mysql> select * from xml_metadata;</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">+----+--------------+-----------------+------------+-----------------------------------+----------+</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| id | corpus | handle | att_family | description | datatype |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">+----+--------------+-----------------+------------+-----------------------------------+----------+</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 1 | bncsampler | s | s | s | 0 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 2 | bncsampler | text | text | text | 0 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 3 | bncsampler | text_id | text | text_id | 3 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 4 | lcmc | s | s | s | 0 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 5 | lcmc | text | text | text | 0 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 6 | lcmc | text_id | text | text_id | 3 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 7 | test_coscach | s | s | Sentence | 0 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 8 | test_coscach | text | text | Text | 0 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 9 | test_coscach | text_id | text | Unique Text ID | 3 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 10 | test_coscach | text_corpus | text | Corpus name | 2 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 11 | test_coscach | text_tagger | text | Corpus tagger | 2 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 12 | test_coscach | text_language | text | Text language | 1 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 13 | test_coscach | text_channel | text | Spoken or written? | 2 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 14 | test_coscach | text_instrument | text | Elicitation instrument | 1 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 15 | test_coscach | text_lingualism | text | Speaker monolingual or bilingual? | 1 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:10.0pt;font-family:"Courier New"">| 16 | test_coscach | text_location | text | Speaker location | 1 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 17 | test_coscach | text_sex | text | Speaker sex | 1 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 18 | test_coscach | text_generation | text | Speaker generation | 1 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">| 19 | test_coscach | text_sel | text | Speaker SEL | 1 |</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">+----+--------------+-----------------+------------+-----------------------------------+----------+</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">19 rows in set (0.00 sec)</span><o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"> <o:p></o:p></p>
</div>
<div>
<p class="gmail-msonormal"><span style="font-size:7.5pt;font-family:"Courier New"">mysql> </span><o:p></o:p></p>
</div>
</div>
<div>
<p class="gmail-msonormal"> <o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt;border-top-width:initial;border-right-width:initial;border-bottom-width:initial;border-top-color:initial;border-right-color:initial;border-bottom-color:initial">
<div>
<p> <o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm;border-right-width:initial;border-bottom-width:initial;border-left-width:initial;border-right-color:initial;border-bottom-color:initial;border-left-color:initial">
<p><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Hardie, Andrew
<br>
<b>Sent:</b> 25 July 2016 23:48<br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> RE: [CWB] WebInABox: Can't import existing corpora from host</span><o:p></o:p></p>
</div>
</div>
<p> <o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">OK, 2 things:</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">First – the result of the MySQL query shows that none of the XML of your corpus has been detected.</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Second – the other error you report is clearly referring to your earlier index data. The check on text ID validity is done at point of extraction
<i>from</i> the index <i>to </i>CQPweb’s internal data structures. So, it is reading the index and getting bad values. This implies that your earelier index files still exist and are being read by CQPweb.</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">So, the overall picture would seem to be that you have data hanging around from previous incarnations of the corpus, and your reinstallation did not work properly. Your best
bet might be to make doubly sure everything is wiped from that corpus, then start over again. This will probably not fix all the problems but it
<i>should</i> make the issues that remain clearer.</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:cwb-bounces@liste.sslmit.unibo.it" target="_blank">cwb-bounces@liste.sslmit.unibo.it</a> [mailto:<a href="mailto:cwb-bounces@liste.sslmit.unibo.it" target="_blank">cwb-bounces@liste.sslmit.unibo.it</a>]
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 25 July 2016 17:15</span><o:p></o:p></p>
<div>
<div>
<p class="gmail-msonormal"><b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Cc:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> Re: [CWB] WebInABox: Can't import existing corpora from host<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p> <o:p></o:p></p>
<div>
<div>
<div>
<p>On Mon, Jul 25, 2016 at 5:48 AM, Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> wrote:<o:p></o:p></p>
</div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt;border-top-width:initial;border-right-width:initial;border-bottom-width:initial;border-top-color:initial;border-right-color:initial;border-bottom-color:initial">
<p> <o:p></o:p></p>
<div>
<div>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Try running</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> select * from xml_metadata;</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">in the MySQL command line client, and see what you get.</span><o:p></o:p></p>
</div>
</div>
</blockquote>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>This is what I get:<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">$ mysql -u root -p cqpweb</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">Enter password: </span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">Reading table information for completion of table and column names</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">[...]</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">mysql> select * from xml_metadata;</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">+----+------------+---------+------------+-------------+----------+</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">| id | corpus | handle | att_family | description | datatype |</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">+----+------------+---------+------------+-------------+----------+</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">| 1 | bncsampler | s | s | s | 0 |</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">| 2 | bncsampler | text | text | text | 0 |</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">| 3 | bncsampler | text_id | text | text_id | 3 |</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">| 4 | lcmc | s | s | s | 0 |</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">| 5 | lcmc | text | text | text | 0 |</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">| 6 | lcmc | text_id | text | text_id | 3 |</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">+----+------------+---------+------------+-------------+----------+</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">6 rows in set (0.00 sec)</span><o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">mysql> </span><o:p></o:p></p>
</div>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>I have noted something anomalous on another front which may be relevant. When I go to the "Manage Metadata" page of the corpus I'm trying to get set up, and hit the "Create minimalist metadata table" button, I get an error which has nothing to do with my
current corpus:<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">The data source you specified for the text metadata contains badly-formatted text ID codes, as follows: <strong> '<no annotation>'; 'CCN-F2-01_Ca_St.ortografica.txt'; 'CCN-F2-02_D_StB.ortografica.txt';
'CCN-F2-03_Ca_St.ortografica.txt'; 'CCN-F2-04_Cb_St.ortografica.txt';[...]</strong> (text ids can only contain unaccented letters, numbers, and underscore).</span><o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>None of these values are present in my current corpus, though they <i>were</i> in an earlier version, However, I removed them from the tagged texts after you explained that these values had to be handles. Here's what my metadata currently looks like:<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""><text id="CCN_F2_27_B" corpus="coscach" tagger="freeling_xml" language="spanish" channel="oral" instrument="interview" lingualism="monolingual" location="concepcion" sex="f" generation="G2" sel="B"></span><o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>So values like <span style="font-size:10.0pt;font-family:"Courier New"">'CCN-F2-01_Ca_St.ortografica.txt'</span> are not in my corpus any more (and I recompiled it from these files, of course), but they seem to be cached somewhere by CQPweb, and they are
not getting updated by newer corpora I try to import. (Note that I've used different names, e.g. test_corpus, test_corpus_two, in order to try to get around this, but it hasn't worked).<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>Cheers,<br>
Scott<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt;border-top-width:initial;border-right-width:initial;border-bottom-width:initial;border-top-color:initial;border-right-color:initial;border-bottom-color:initial">
<div>
<div>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:cwb-bounces@liste.sslmit.unibo.it" target="_blank">cwb-bounces@liste.sslmit.unibo.it</a> [mailto:<a href="mailto:cwb-bounces@liste.sslmit.unibo.it" target="_blank">cwb-bounces@liste.sslmit.unibo.it</a>]
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 24 July 2016 17:17<br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Cc:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> Re: [CWB] WebInABox: Can't import existing corpora from host</span><o:p></o:p></p>
<div>
<div>
<p> <o:p></o:p></p>
<div>
<div>
<div>
<p>On Sun, Jul 24, 2016 at 11:29 AM, Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> wrote:<o:p></o:p></p>
</div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt;border-top-width:initial;border-right-width:initial;border-bottom-width:initial;border-top-color:initial;border-right-color:initial;border-bottom-color:initial">
<p> <o:p></o:p></p>
<div>
<div>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">First point – your text ID codes won’t work, they need to be
<b>handles</b>, i.e. just ASCII letters, numbers, and underscore – no hyphens/full stops.</span><o:p></o:p></p>
</div>
</div>
</blockquote>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>Now corrected!<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt;border-top-width:initial;border-right-width:initial;border-bottom-width:initial;border-top-color:initial;border-right-color:initial;border-bottom-color:initial">
<div>
<div>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Second point – the various s-attributes text_corpus , text_tagger etc. need (a) to exist in the registry – did your correction fix this? (b) CQPweb needs to have logged their
existence – if it’s saying “No XML annotations found” that suggests it hasn’t, which could be a consequence of (a), or could be a bug.</span><o:p></o:p></p>
</div>
</div>
</blockquote>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>Unless I'm mistaken about what attributes are what, they are indeed in the registry. I've pasted it at the end of this e-mail, along with a single tagged source text sentence.<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt;border-top-width:initial;border-right-width:initial;border-bottom-width:initial;border-top-color:initial;border-right-color:initial;border-bottom-color:initial">
<div>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">There was in fact a bug with s-attributes in the registry failing to be detected which I fixed a few months back: I cannot recall if that was before or after the version of the
code in the VM image. If you want to rule this out, connect the VM’s networking, upgrade CQPweb to the latest version from SVN (don’t forget to do the database upgrade!), and try again: if that fixes it, it was the old bug.</span><o:p></o:p></p>
</div>
</blockquote>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>I've been using revision 879 (3.2.20) the whole time, so it shouldn't be the old bug. <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt;border-top-width:initial;border-right-width:initial;border-bottom-width:initial;border-top-color:initial;border-right-color:initial;border-bottom-color:initial">
<div>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Once CQPweb is aware of your XML attributes you should be able to use them to derive text metadata. </span><o:p></o:p></p>
</div>
</blockquote>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>Thanks for your patience!<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>Cheers,<o:p></o:p></p>
</div>
<div>
<p>Scott<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""><text id="CCN_F2_25_Ca" corpus="test_two" tagger="freeling_xml" language="spanish" channel="oral" instrument="interview" lingualism="monolingual" location="concepcion" sex="f" generation="G2" sel="Ca"></span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""><s></span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">¿ ¿ Fia Fia punctuation questionmark</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">todavía todavía RG RG adverb general</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">está estar VAIP3S0 VAI verb auxiliary</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">grabando grabar VMG0000 VMG verb main</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">? ? Fit Fit punctuation questionmark</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""></s></span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""></text></span><o:p></o:p></p>
</div>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">##</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">## registry entry for corpus TEST_TWO</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">##</span><o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""># long descriptive name for the corpus</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">NAME ""</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""># corpus ID (must be lowercase in registry!)</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">ID test_two</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""># path to binary data files</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">HOME /var/cqpweb/index/test_two</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""># optional info file (displayed by "info;" command in CQP)</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">INFO /var/cqpweb/index/test_two/.info</span><o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""># corpus properties provide additional information about the corpus:</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">##:: charset = "utf8" # character encoding of corpus data</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">##:: language = "es" # insert ISO code for language (de, en, fr, ...)</span><o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">##</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">## p-attributes (token annotations)</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">##</span><o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">ATTRIBUTE word</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">ATTRIBUTE lemma</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">ATTRIBUTE tag</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">ATTRIBUTE ctag</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">ATTRIBUTE pos</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">ATTRIBUTE type</span><o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">##</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">## s-attributes (structural markup)</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">##</span><o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""># <s> ... </s></span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""># (no recursive embedding allowed)</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE s</span><o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""># <text id=".." corpus=".." tagger=".." file=".." language=".." channel=".." instrument=".." lingualism=".." location=".." sex=".." generation=".." sel=".."> ... </text></span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""># (no recursive embedding allowed)</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE text</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE text_id # [annotations]</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE text_corpus # [annotations]</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE text_tagger # [annotations]</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE text_file # [annotations]</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE text_language # [annotations]</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE text_channel # [annotations]</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE text_instrument # [annotations]</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE text_lingualism # [annotations]</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:10.0pt;font-family:"Courier New"">STRUCTURE text_location # [annotations]</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE text_sex # [annotations]</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE text_generation # [annotations]</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New"">STRUCTURE text_sel # [annotations]</span><o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p><span style="font-size:7.5pt;font-family:"Courier New""># Yours sincerely, the Encode tool.</span><o:p></o:p></p>
</div>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt;border-top-width:initial;border-right-width:initial;border-bottom-width:initial;border-top-color:initial;border-right-color:initial;border-bottom-color:initial">
<div>
<div>
<p><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:cwb-bounces@liste.sslmit.unibo.it" target="_blank">cwb-bounces@liste.sslmit.unibo.it</a> [mailto:<a href="mailto:cwb-bounces@liste.sslmit.unibo.it" target="_blank">cwb-bounces@liste.sslmit.unibo.it</a>]
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 24 July 2016 15:52<br>
<b>To:</b> CWBdev Mailing List</span><o:p></o:p></p>
<div>
<div>
<p><br>
<b>Subject:</b> [CWB] WebInABox: Can't import existing corpora from host<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p> <o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<p>On Sun, Jul 24, 2016 at 10:19 AM, Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> wrote:<o:p></o:p></p>
</div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt;border-top-width:initial;border-right-width:initial;border-bottom-width:initial;border-top-color:initial;border-right-color:initial;border-bottom-color:initial">
<p> <o:p></o:p></p>
<div>
<div>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">CQPweb requires all corpora to have at least one <text> element, and every text element has to have an id i.e. everything within the corpus has to be contained within a sequence
of one or more</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><text id=”somethinghere”></span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">…</span><o:p></o:p></p>
<p><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"></text></span><o:p></o:p></p>
</div>
</div>
</blockquote>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>Thanks, Andrew. It turns out the problem was that I had been using the name "id" instead of "text" for the element. Now that I've changed that, I was able to successfully create the corpus in CQPweb.<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>My source files have quite a bit of metadata, which I've encoded as follows:<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p><span style="font-family:"Courier New""><<span style="color:red">text</span> <span style="color:#38761D">
id</span>="CCN-F2-02_D_StB.ortografica.txt" <span style="color:#38761D">corpus</span>="test"
<span style="color:#38761D">tagger</span>="freeling-xml" <span style="color:#38761D">
language</span>="spanish" <span style="color:#38761D">location</span>="concepcion"
<span style="color:#38761D">sex</span>="f"></span><o:p></o:p></p>
</div>
<div>
<p><span style="font-family:"Courier New"">...</span><o:p></o:p></p>
</div>
<div>
<p><span style="font-family:"Courier New""></text></span><o:p></o:p></p>
</div>
<p><br>
I'm now at the CQPweb "Design and insert a text-metadata table for the corpus" page, but it tells me that "No XML annotations found for this corpus". Is there something wrong with how I did the encoding above? I can use all of these XML elements in cqp searches
directly, but here they aren't recognized.<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>(I've checked chapter 6 of the manual, to no avail).<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@liste.sslmit.unibo.it">CWB@liste.sslmit.unibo.it</a><br>
<a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>