<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;}
code
        {mso-style-priority:99;
        font-family:"Courier New";}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";}
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.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:"Courier New";
        mso-fareast-language:EN-GB;}
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;}
span.EmailStyle22
        {mso-style-type:personal;
        font-family:"Verdana","sans-serif";
        color:#1F497D;}
span.EmailStyle23
        {mso-style-type:personal;
        font-family:"Verdana","sans-serif";
        color:#1F497D;}
span.s2
        {mso-style-name:s2;}
span.o
        {mso-style-name:o;}
span.nx
        {mso-style-name:nx;}
span.EmailStyle27
        {mso-style-type:personal;
        font-family:"Verdana","sans-serif";
        color:#1F497D;}
span.EmailStyle28
        {mso-style-type:personal-reply;
        font-family:"Verdana","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-family:"Calibri","sans-serif";
        mso-fareast-language:EN-US;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
--></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:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Ah, this brings back memories – this was the cluster of bugs that I fixed in 3.2.1.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Anyway:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">no 1 – Timezone error - can be ignored. Error on reinstallation -– known, cleanup of the xml_metadata was not added till 3.2.4., you can do it manually though:<o:p></o:p></span></p>
<p class="MsoNormal" style="text-indent:36.0pt"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">delete from xml_metadata where corpus=&quot;put name of corpus you deleted here&quot;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">no 2 – fix manually as follows:<o:p></o:p></span></p>
<p class="MsoNormal" style="text-indent:36.0pt"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Add the following line at the top of
</span><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">indexforms-admin.inc.php :</span><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; require(&quot;../lib/xml.inc.php&quot;);<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In the file exe/metadata-admin.php, change the reference metadata-create.inc.php to &nbsp;refer to to</span>
<span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">metadata-admin.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Or just wait for me to finish 3.2.4…<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;"> cwb-bounces@sslmit.unibo.it [mailto:cwb-bounces@sslmit.unibo.it]
<b>On Behalf Of </b>(Ray) WU Liangping<br>
<b>Sent:</b> 27 October 2015 11:11<br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> Re: [CWB] CQPweb 3.2.4 related: query returns a blank page and corpus deletion partial<o:p></o:p></span></p>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">I reinstalled v3.2.1 (using the tarball) from scratch to reproduce the errors. The following are what I got:<br>
<br>
1. In the system installation step: <br>
<span style="background:teal">(when running autosetup.php)</span>PHP Warning:&nbsp; date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used
 any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Chongqing' for 'CST/8.0/no DST' instead in /usr/local/apache2/htdocs/lib/library.inc.php on line 225<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black"><br>
<span style="background:teal">(when reinstall a corpus after deleting it)</span>Error # 1062: Duplicate entry 'brown-text' for key 2.&nbsp; This indicates a deleting of a failed corpus is not clean enough so I just drop the database and re-created it every time
 I fail to install a corpus correctly in v3.2.1.<br>
<br>
2. In the corpus installation step:<br>
<span style="background:teal">(when installing the metadat)</span> After choosing &quot;No thanks, I'll run this myself (safer for very large corpora) &quot;, I got an empty page. The following are what I found in Apache's error_log file:<br>
[Tue Oct 27 18:58:09 2015] [error] [client 127.0.0.1] PHP Fatal error:&nbsp; Call to undefined function list_xml_with_content() in /usr/local/apache2/htdocs/lib/indexforms-admin.inc.php on line 893, referer:
<a href="http://127.0.1.1/adm/index.php?thisF=installCorpusDone&amp;newlyInstalledCorpus=brown&amp;uT=y">
http://127.0.1.1/adm/index.php?thisF=installCorpusDone&amp;newlyInstalledCorpus=brown&amp;uT=y</a><br>
[Tue Oct 27 18:58:49 2015] [error] [client 127.0.0.1] PHP Fatal error:&nbsp; Call to undefined function list_xml_with_content() in /usr/local/apache2/htdocs/lib/indexforms-admin.inc.php on line 893, referer:
<a href="http://127.0.1.1/brown/index.php?thisQ=corpusSettings&amp;uT=y">http://127.0.1.1/brown/index.php?thisQ=corpusSettings&amp;uT=y</a><br>
[Tue Oct 27 18:59:40 2015] [error] [client 127.0.0.1] PHP Warning:&nbsp; require(../lib/metadata-create.inc.php) [&lt;a href='function.require'&gt;function.require&lt;/a&gt;]: failed to open stream: No such file or directory in /usr/local/apache2/htdocs/exe/metadata-admin.php
 on line 3, referer: <a href="http://127.0.1.1/brown/index.php?thisQ=manageMetadata&amp;uT=y">
http://127.0.1.1/brown/index.php?thisQ=manageMetadata&amp;uT=y</a><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">[Tue Oct 27 18:59:40 2015] [error] [client 127.0.0.1] PHP Fatal error:&nbsp; require() [&lt;a href='function.require'&gt;function.require&lt;/a&gt;]: Failed opening required '../lib/metadata-create.inc.php'
 (include_path='.:/usr/local/lib/php') in /usr/local/apache2/htdocs/exe/metadata-admin.php on line 3, referer:
<a href="http://127.0.1.1/brown/index.php?thisQ=manageMetadata&amp;uT=y">http://127.0.1.1/brown/index.php?thisQ=manageMetadata&amp;uT=y</a><br>
<br>
I can find no metadata-create.inc.php in the lib directory, but just metadata-admin.inc.php instead.
<br>
<br>
Liangping<br>
&nbsp;<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black"><br>
At 2015-10-27 15:50:27, &quot;Hardie, Andrew&quot; &lt;<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>&gt; wrote:<br>
<br>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Sorry but I need more info on the precise error on “</span><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">still cannot handle the
 metadata so no frequency data can be generated</span><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">”!</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Andrew.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;;color:black">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;;color:black">
<a href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a> [mailto:<a href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a>]
<b>On Behalf Of </b>(Ray) WU Liangping<br>
<b>Sent:</b> 27 October 2015 07:25<br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> Re: [CWB] CQPweb 3.2.4 related: query returns a blank page and corpus deletion partial</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">&nbsp;<o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">hi Andrew,<br>
<br>
Thanks for the script and the v3.2.1 can leap one step forward but still cannot handle the metadata so no frequency data can be generated.<br>
I also checked the error log (not the access log) for v3.2.4 but nothing is there.<br>
<br>
Ok, maybe more work on me to sort out what's going wrong on my particular server.<br>
<br>
Best,<br>
Liangping</span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black"><br>
At 2015-10-27 15:18:43, &quot;Hardie, Andrew&quot; &lt;<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>&gt; wrote:</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">This is a known bug which I fixed in a later version but fortunately can be patched manually to get things rolling in 3.2.1 – run the following MySQL statement
 after installing the system but before installing corpora:</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;vertical-align:baseline"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#BA2121;border:none windowtext 1.0pt;padding:0cm">CREATE TABLE `xml_metadata` (</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;vertical-align:baseline"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#BA2121;border:none windowtext 1.0pt;padding:0cm">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; `id` int NOT NULL AUTO_INCREMENT,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;vertical-align:baseline"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#BA2121;border:none windowtext 1.0pt;padding:0cm">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; `corpus` varchar(20) NOT NULL,</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;vertical-align:baseline"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#BA2121;border:none windowtext 1.0pt;padding:0cm">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; `handle` varchar(64) NOT NULL,</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;vertical-align:baseline"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#BA2121;border:none windowtext 1.0pt;padding:0cm">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; `att_family` varchar(64) NOT NULL default '',</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;vertical-align:baseline"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#BA2121;border:none windowtext 1.0pt;padding:0cm">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; `description` varchar(255) default NULL,</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;vertical-align:baseline"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#BA2121;border:none windowtext 1.0pt;padding:0cm">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; `datatype`&nbsp; tinyint(2) NOT NULL default 0,</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;vertical-align:baseline"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#BA2121;border:none windowtext 1.0pt;padding:0cm">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; primary key(`id`),</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;background:#FFFF99;vertical-align:baseline">
<span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#BA2121;border:none windowtext 1.0pt;padding:0cm">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; unique key (`corpus`, `handle`)</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;vertical-align:baseline"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#BA2121;border:none windowtext 1.0pt;padding:0cm">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) CHARACTER SET utf8 COLLATE utf8_bin;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Andrew.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;;color:black">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;;color:black">
<a href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a> [mailto:<a href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a>]
<b>On Behalf Of </b>(Ray) WU Liangping<br>
<b>Sent:</b> 27 October 2015 07:13<br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> Re: [CWB] CQPweb 3.2.4 related: query returns a blank page and corpus deletion partial</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">&nbsp;<o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">hi Andrew,<br>
<br>
I tried the older tarballed v3.2.1 on the same server with the same configurations, but the corpus installation is not successful.<br>
<br>
1) After some error messages, the site is up and running;<br>
2) Corpus installation generates the error: Original query: insert into xml_metadata ( corpus, handle, att_family, description, datatype) values ('brown', 'text', 'text', 'Text', 0) /* from User: cqpweb | Function: install_new_corpus() | 2015-10-27 07:02:06
 */<br>
Error # 1146: Table 'cqpweb_data.xml_metadata' doesn't exist </span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black"><br>
However, the corpus can be deleted without any problem in v3.2.1, which is not possible in v3.2.4.<br>
<br>
Best,<br>
Liangping</span><span style="color:black"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black"><br>
At 2015-10-27 14:35:32, &quot;(Ray) WU Liangping&quot; &lt;<a href="mailto:liangpingwu@126.com">liangpingwu@126.com</a>&gt; wrote:</span><span style="color:black"><o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">hi Andrew,<br>
<br>
The Apache logs says no error about the empty page after a query, just some access info:<br>
&nbsp; 37987 127.0.0.1 - - [27/Oct/2015:14:20:38 &#43;0800] &quot;GET /brown/concordance.php?theData=%5Bword%3D%22the%22%25c%5D&amp;qmode=cqp&amp;uT=y HTTP/1.1&quot; 500 -<br>
<br>
The deletion gets the same info (no error, just access traces):<br>
127.0.0.1 - - [27/Oct/2015:14:24:16 &#43;0800] &quot;GET /adm/index.php?sureyouwantto=yes&amp;admFunction=deleteCorpus&amp;corpus=brown&amp;uT=y HTTP/1.1&quot; 500 -<br>
<br>
Even a re-deletion of the same corpus (it just hangs on there) generates no error in the Apache logs.<br>
<br>
But a re-run of Frequency lists do generate the following error: Error # 1146: Table 'cqpweb_data.freq_corpus_brown_word' doesn't exist.<br>
<br>
My server is happy with the old v3.0.7 version but not this one. Maybe I'd better wait for a few moments.<br>
<br>
I also want to try the more stable v3.2.3 version, but the command &quot; </span><code><span style="font-size:10.0pt;color:black">svn co
<a href="http://svn.code.sf.net/p/cwb/code/gui/cqpweb/branches/3.2.3">http://svn.code.sf.net/p/cwb/code/gui/cqpweb/branches/3.2.3</a> cqpweb</span></code><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black"> &quot; doesn't seem to work (no
 file error returned). <br>
<br>
I am trying the tarballed v3.2.1 now to see whether this is a version issue or some misconfiguration of my server.<br>
<br>
Best,<br>
Liangping</span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black"><br>
At 2015-10-27 14:05:59, &quot;Hardie, Andrew&quot; &lt;<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>&gt; wrote:</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Hi Liangpeng,</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Can you check your server log to see if there is a corresponding error message written when these errors occur?</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">These things aren’t happening on my own machine, so it’s difficult to diagnose without &nbsp;an error message.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">You may also have an uneven set of code files – I am still working on some stuff…</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">best</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Andrew.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;;color:black">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;;color:black">
<a href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a> [mailto:<a href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a>]
<b>On Behalf Of </b>(Ray) WU Liangping<br>
<b>Sent:</b> 27 October 2015 05:58<br>
<b>To:</b> <a href="mailto:cwb@sslmit.unibo.it">cwb@sslmit.unibo.it</a><br>
<b>Subject:</b> [CWB] CQPweb 3.2.4 related: query returns a blank page and corpus deletion partial</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">&nbsp;<o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">Hi all,<br>
<br>
I am trying the new CQPweb interface v3.2.4 from a fresh installation.&nbsp; I can install a corpus and see the frequency list for p-attributes of either word or pos.<br>
Currently I have two problems: <br>
1) Query (either standard or restricted) returns no results and CQPweb gives no indication of error but an empty page. As the word and pos attributes are successfully generated, so MySQL and CWB should be functioning somehow. However, when the query is issued,
 nothing happens and query history is also empty.<br>
2) I find in the CQPweb System Administrator's Manual a line reads that some handles cannot include any lowercase letters (p. 36) , so I doubt my setup procedure (I used lowercases for everything) and want a deletion for a new installation. Strangely, the corpus
 won't go away as usual (but Frequency lists are not functioning any more so the deletion is not immaterial but just partial).<br>
<br>
Any hints?<br>
Thanks.</span><span style="color:black"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">Best,<br>
WU Liangping</span><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:gray"><br>
</span><span style="font-size:10.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:black">&nbsp;</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>