<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family: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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 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";}
h3
{mso-style-priority:9;
mso-style-link:"Heading 3 Char";
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:13.5pt;
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;}
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";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
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.Heading3Char
{mso-style-name:"Heading 3 Char";
mso-style-priority:9;
mso-style-link:"Heading 3";
font-family:"Cambria","serif";
color:#4F81BD;
mso-fareast-language:EN-GB;
font-weight:bold;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
mso-fareast-language:EN-GB;}
p.errormessage, li.errormessage, div.errormessage
{mso-style-name:errormessage;
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.code
{mso-style-name:code;}
span.EmailStyle23
{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";}
span.EmailStyle28
{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">If you downgrade to 3.0.16 this will go away.<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">To repeat my earlier warning: 3.1.0 is currently unstable and no one but me should be using it till further notice!<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@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a> [<a href="mailto:cwb-bounces@sslmit.unibo.it">mailto:cwb-bounces@sslmit.unibo.it</a>]
<b>On Behalf Of </b>Andres Chandia<br>
<b>Sent:</b> 31 December 2013 13:45<br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> Re: [CWB] problem at managing corpus metadata<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Ok, it works, thanks a lot... I have some more issues though....<br>
<br>
1. I have introduced at the second line s-attributes this way: s:0+id+type, then at the restricted query for the s_id it only appears the data for S1 and S3, but not for S2 and S4, if you see the corpus text_1 owns S1 and S2, text_2 owns S3 and S4, so only
appears the first S of each text<br>
<br>
<br>
2. at the "Create metadata table from corpus XML annotations" step is the option "Do you want to automatically run frequency-list setup?" if I select "yes" everything goes well, but if I select "No thanks, I'll run this myself (safer for very large corpora)"
and I go to that step, on clicking the "The text metadata table has not yet been populated with begin/end offset positions. Use the button below to generate this data." button I get next error:<o:p></o:p></p>
<p class="errormessage">A mySQL query did not run successfully!<o:p></o:p></p>
<p class="errormessage">Error # 1146: Table 'cqp.text_metadata_for_' doesn't exist
<o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center"><span class="code">
<hr size="2" width="100%" align="center">
</span></div>
<h3>PHP debugging backtrace<o:p></o:p></h3>
<pre>array(6) { [0]=> array(4) { ["file"]=> string(40)<o:p></o:p></pre>
<pre>"/srv/web/llocs/cqp/lib/exiterror.inc.php" ["line"]=> int(260) <o:p></o:p></pre>
<pre> ["function"]=> string(17) "exiterror_endpage" <o:p></o:p></pre>
<pre>["args"]=> array(0) { } } [1]=> array(4) { <o:p></o:p></pre>
<pre>["file"]=> string(38) "/srv/web/llocs/cqp/lib/library.inc.php" <o:p></o:p></pre>
<pre>["line"]=> int(227) ["function"]=> string(20)<o:p></o:p></pre>
<pre>"exiterror_mysqlquery" ["args"]=> array(2) { [0]=> <o:p></o:p></pre>
<pre> &int(1146) [1]=> &string(44) "Table 'cqp.text_metadata_for_'<o:p></o:p></pre>
<pre>doesn't exist" } } [2]=> array(4) { ["file"]=> <o:p></o:p></pre>
<pre>string(40) "/srv/web/llocs/cqp/lib/admin-lib.inc.php" ["line"]=> <o:p></o:p></pre>
<pre> int(516) ["function"]=> string(14) "do_mysql_query" <o:p></o:p></pre>
<pre>["args"]=> array(1) { [0]=> &string(83) "update<o:p></o:p></pre>
<pre>text_metadata_for_ set cqp_begin = 0, cqp_end = 41 where text_id = '1'" } } <o:p></o:p></pre>
<pre>[3]=> array(2) { ["function"]=> string(29)<o:p></o:p></pre>
<pre>"populate_corpus_cqp_positions" ["args"]=> array(0) { } }<o:p></o:p></pre>
<pre> [4]=> array(4) { ["file"]=> string(38)<o:p></o:p></pre>
<pre>"/srv/web/llocs/cqp/lib/execute.inc.php" ["line"]=> int(154) <o:p></o:p></pre>
<pre> ["function"]=> string(20) "call_user_func_array" <o:p></o:p></pre>
<pre>["args"]=> array(2) { [0]=> &string(29)<o:p></o:p></pre>
<pre>"populate_corpus_cqp_positions" [1]=> &array(0) { } } <o:p></o:p></pre>
<pre>} [5]=> array(4) { ["file"]=> string(38)<o:p></o:p></pre>
<pre>"/srv/web/llocs/cqp/testing/execute.php" ["line"]=> int(1) <o:p></o:p></pre>
<pre>["args"]=> array(1) { [0]=> string(38)<o:p></o:p></pre>
<pre>"/srv/web/llocs/cqp/lib/execute.inc.php" } ["function"]=> <o:p></o:p></pre>
<pre>string(7) "require" } }<o:p></o:p></pre>
<pre> Thanks a lot<o:p></o:p></pre>
</div>
</body>
</html>