<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.EmailStyle18
{mso-style-type:personal;
font-family:"Verdana","sans-serif";
color:#1F497D;}
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.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Verdana","sans-serif";
color:#1F497D;}
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.s2
{mso-style-name:s2;}
span.o
{mso-style-name:o;}
span.nx
{mso-style-name:nx;}
.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:"Verdana","sans-serif";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:<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" style="line-height:13.5pt;vertical-align:baseline"><span style="font-size:10.0pt;font-family:"Courier New";color:#BA2121;border:none windowtext 1.0pt;padding:0cm">CREATE TABLE `xml_metadata` (</span><span style="font-size:10.0pt;font-family:"Courier New";color:#555555"><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:"Courier New";color:#BA2121;border:none windowtext 1.0pt;padding:0cm"> `id` int NOT NULL AUTO_INCREMENT,
</span><span style="font-size:10.0pt;font-family:"Courier New";color:#555555"><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:"Courier New";color:#BA2121;border:none windowtext 1.0pt;padding:0cm"> `corpus` varchar(20) NOT NULL,</span><span style="font-size:10.0pt;font-family:"Courier New";color:#555555"><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:"Courier New";color:#BA2121;border:none windowtext 1.0pt;padding:0cm"> `handle` varchar(64) NOT NULL,</span><span style="font-size:10.0pt;font-family:"Courier New";color:#555555"><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:"Courier New";color:#BA2121;border:none windowtext 1.0pt;padding:0cm"> `att_family` varchar(64) NOT NULL default '',</span><span style="font-size:10.0pt;font-family:"Courier New";color:#555555"><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:"Courier New";color:#BA2121;border:none windowtext 1.0pt;padding:0cm"> `description` varchar(255) default NULL,</span><span style="font-size:10.0pt;font-family:"Courier New";color:#555555"><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:"Courier New";color:#BA2121;border:none windowtext 1.0pt;padding:0cm"> `datatype` tinyint(2) NOT NULL default 0,</span><span style="font-size:10.0pt;font-family:"Courier New";color:#555555"><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:"Courier New";color:#BA2121;border:none windowtext 1.0pt;padding:0cm"> primary key(`id`),</span><span style="font-size:10.0pt;font-family:"Courier New";color:#555555"><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:"Courier New";color:#BA2121;border:none windowtext 1.0pt;padding:0cm"> unique key (`corpus`, `handle`)</span><span style="font-size:10.0pt;font-family:"Courier New";color:#555555"><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:"Courier New";color:#BA2121;border:none windowtext 1.0pt;padding:0cm"> ) CHARACTER SET utf8 COLLATE utf8_bin;</span><span style="font-size:10.0pt;font-family:"Courier New";color:#555555"><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"><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""> 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 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<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";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 <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";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<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black"><br>
At 2015-10-27 14:35:32, "(Ray) WU Liangping" <<a href="mailto:liangpingwu@126.com">liangpingwu@126.com</a>> wrote:<br>
<br>
<o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black">hi Andrew,<br>
<br>
The Apache logs says no error about the empty page after a query, just some access info:<br>
37987 127.0.0.1 - - [27/Oct/2015:14:20:38 +0800] "GET /brown/concordance.php?theData=%5Bword%3D%22the%22%25c%5D&qmode=cqp&uT=y HTTP/1.1" 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 +0800] "GET /adm/index.php?sureyouwantto=yes&admFunction=deleteCorpus&corpus=brown&uT=y HTTP/1.1" 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 " </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:"Arial","sans-serif";color:black"> " 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<br>
<br>
<br>
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black"> <o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black"><br>
At 2015-10-27 14:05:59, "Hardie, Andrew" <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>> wrote:<br>
<br>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";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:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";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:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">These things aren’t happening on my own machine, so it’s difficult to diagnose without 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:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";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:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";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:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";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:"Verdana","sans-serif";color:#1F497D"> </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:"Tahoma","sans-serif";color:black">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";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"> <o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black">Hi all,<br>
<br>
I am trying the new CQPweb interface v3.2.4 from a fresh installation. 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:"Arial","sans-serif";color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black">Best,<br>
WU Liangping</span><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:gray"><br>
</span><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>