<div style="line-height:1.7;color:#000000;font-size:14px;font-family:Arial"><div style="margin: 0;">Hi, Andrew,</div><div style="margin: 0;">I followed these steps:</div><div style="margin: 0;">1) generated corpus data and registry file using BNCencoder;</div><div style="margin: 0;">2) copy corpus data and registry including the metadata.tbl file to CQPweb directories;</div><div style="margin: 0;">3) changed the WR right of the CQPweb directory to user www-data again;</div><div style="margin: 0;">4) install a preindexed corpus on CQPweb; </div><div style="margin: 0;">5) install text metadata using the BNCencoder generated metadata.tbl residing in the upload directory</div><div style="margin: 0;"><br></div><div style="margin: 0;">Anything suspicious?</div><div style="margin: 0;">Best,</div><div style="margin: 0;">Y.</div><p style="margin: 0;"><br></p><div style="position:relative;zoom:1"><div style="clear:both"></div></div><div id="divNeteaseMailCard"></div><p style="margin: 0;"><br></p><pre><br>At 2024-03-07 16:38:14, cwb-request@sslmit.unibo.it wrote:
>Send CWB mailing list submissions to
>        cwb@sslmit.unibo.it
>
>To subscribe or unsubscribe via the World Wide Web, visit
>        http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>or, via email, send a message with subject or body 'help' to
>        cwb-request@sslmit.unibo.it
>
>You can reach the person managing the list at
>        cwb-owner@sslmit.unibo.it
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of CWB digest..."
>
>
>Today's Topics:
>
> 1. Re: classification metadata not shown (Hardie, Andrew)
> 2. CRITICAL ERROR: $mysql_webuser has not been set in the
> configuration file. (Simon Meier-Vieracker)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Wed, 6 Mar 2024 12:50:33 +0000
>From: "Hardie, Andrew" <a.hardie@lancaster.ac.uk>
>To: Open source development of the Corpus WorkBench
>        <cwb@sslmit.unibo.it>
>Subject: Re: [CWB] classification metadata not shown
>Message-ID:
>        <LO4P265MB34852345F29AC7A1D7632AAECB212@LO4P265MB3485.GBRP265.PROD.OUTLOOK.COM>
>        
>Content-Type: text/plain; charset="us-ascii"
>
>Yes, this shows that all the fields from "publication_date" onwards until "n_tokens" are empty values. What is in the database is being rendered correctly.
>
>So, there is no problem in the metadata display, but there is a problem in metadata setup - but to diagnose, I'll need ot know exactly how you installed the text metadata, step by step.
>
>best
>
>Andrew.
>
>
>From: cwb-bounces@sslmit.unibo.it <cwb-bounces@sslmit.unibo.it> On Behalf Of Yu Yuan
>Sent: Tuesday, March 5, 2024 6:44 AM
>To: cwb@sslmit.unibo.it
>Subject: Re: [CWB] classification metadata not shown
>
>Hi, Andrew,
>
>It looks nothing other than those free text data are inside. See attached.
>
>
>Best,
>Y.
>
>At 2024-03-05 00:22:13, cwb-request@sslmit.unibo.it<mailto:cwb-request@sslmit.unibo.it> wrote:
>
>>Send CWB mailing list submissions to
>
>> cwb@sslmit.unibo.it<mailto:cwb@sslmit.unibo.it>
>
>>
>
>>To subscribe or unsubscribe via the World Wide Web, visit
>
>> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>
>>or, via email, send a message with subject or body 'help' to
>
>> cwb-request@sslmit.unibo.it<mailto:cwb-request@sslmit.unibo.it>
>
>>
>
>>You can reach the person managing the list at
>
>> cwb-owner@sslmit.unibo.it<mailto:cwb-owner@sslmit.unibo.it>
>
>>
>
>>When replying, please edit your Subject line so it is more specific
>
>>than "Re: Contents of CWB digest..."
>
>>
>
>>
>
>>Today's Topics:
>
>>
>
>> 1. classification metadata not shown (Yu Yuan)
>
>>
>
>>
>
>>----------------------------------------------------------------------
>
>>
>
>>Message: 1
>
>>Date: Mon, 4 Mar 2024 22:49:29 +0800 (CST)
>
>>From: "Yu Yuan" <yuyuan97@163.com<mailto:yuyuan97@163.com>>
>
>>To: "cwb@sslmit.unibo.it<mailto:cwb@sslmit.unibo.it>" <cwb@sslmit.unibo.it<mailto:cwb@sslmit.unibo.it>>
>
>>Subject: [CWB] classification metadata not shown
>
>>Message-ID: <3e138a4d.132ff.18e09f0f107.Coremail.yuyuan97@163.com<mailto:3e138a4d.132ff.18e09f0f107.Coremail.yuyuan97@163.com>>
>
>>Content-Type: text/plain; charset="gbk"
>
>>
>
>>Hi, Andrew,
>
>>
>
>>
>
>>I noticed that the classification type metadata of my installation are not properly handled. For each text, the metadata of free texts can be shown once clicked, but not for the classification categories (See attached). As a consequence, the distribution and frequency breakdown don't work properly. Any idea what causes this? Thanks.
>
>>
>
>>
>
>>Best,
>
>>Y.
>
>>-------------- next part --------------
>
>>An HTML attachment was scrubbed...
>
>>URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20240304/d9bc4125/attachment.html>
>
>>-------------- next part --------------
>
>>A non-text attachment was scrubbed...
>
>>Name: Screenshot from 2024-03-04 22-48-31.png
>
>>Type: image/png
>
>>Size: 54814 bytes
>
>>Desc: not available
>
>>URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20240304/d9bc4125/attachment.png>
>
>>
>
>>------------------------------
>
>>
>
>>_______________________________________________
>
>>CWB mailing list
>
>>CWB@sslmit.unibo.it<mailto:CWB@sslmit.unibo.it>
>
>>http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>
>>
>
>>
>
>>End of CWB Digest, Vol 203, Issue 3
>
>>***********************************
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20240306/ab5bc6ec/attachment-0001.html>
>
>------------------------------
>
>Message: 2
>Date: Thu, 7 Mar 2024 08:20:25 +0000
>From: Simon Meier-Vieracker <simon.meier-vieracker@tu-dresden.de>
>To: "cwb@sslmit.unibo.it" <cwb@sslmit.unibo.it>
>Subject: [CWB] CRITICAL ERROR: $mysql_webuser has not been set in the
>        configuration file.
>Message-ID: <39A6F89E-4CC5-46FB-BA82-B14152F94202@tu-dresden.de>
>Content-Type: text/plain; charset="utf-8"
>
>Hi,
>
>I was able to install a corpus in CQPweb v3.2.43 and to build the corpus frequency list within the menu ?Manage frequency lists?.
>
>However, when I tried to run the offline-freqlists.php script before, I got the error message attached below.
>
>It has been some time since I have tried to install corpora and we rebuilt the directory structure on our server, so maybe some things got lost?
>
>Indeed, the config.inc.php looks like this:
>
>> /* -------------------------- *
>> * database connection config *
>> * -------------------------- */
>>
>> $mysql_webuser = $_SERVER['DATABASE_USERNAME'];
>> $mysql_webpass = $_SERVER['DATABASE_PASSWORD'];
>> $mysql_schema = $_SERVER['DATABASE_NAME'];
>> $mysql_server = $_SERVER['DATABASE_HOSTNAME'];
>>
>> // clear sensitive values from environment
>> unset(
>> $_SERVER['DATABASE_USERNAME'],
>> $_SERVER['DATABASE_PASSWORD'],
>> $_SERVER['DATABASE_NAME'],
>> $_SERVER['DATABASE_HOSTNAME']
>> );
>>
>>
>> /* ---------------------- *
>> * server directory paths *
>> * ---------------------- */
>>
>> $cqpweb_tempdir = '/var/local/cqpweb/tmp';
>> $cqpweb_uploaddir = '/var/local/cqpweb/upload';
>> $cwb_datadir = '/var/local/cqpweb/datafiles';
>> $cwb_registry = '/var/local/cqpweb/registry';
>
>Any ideas what might have gone wrong and what I should check?
>
>Best, Simon
>
>
>
>
>> PHP Warning: Undefined array key "DATABASE_USERNAME" in /var/www/tu-dresden_gsw_ali/cqpweb/lib/config.inc.php on line 21
>> PHP Warning: Undefined array key "DATABASE_PASSWORD" in /var/www/tu-dresden_gsw_ali/cqpweb/lib/config.inc.php on line 22
>> PHP Warning: Undefined array key "DATABASE_NAME" in /var/www/tu-dresden_gsw_ali/cqpweb/lib/config.inc.php on line 23
>> PHP Warning: Undefined array key "DATABASE_HOSTNAME" in /var/www/tu-dresden_gsw_ali/cqpweb/lib/config.inc.php on line 24
>> <tr><td class="concorderror">
>> <p class="errormessage">CRITICAL ERROR: $mysql_webuser has not been set in the configuration file.</p>
>> </td></tr>
>>                 
>>                 </table>
>>                 
>>                 
>>         <hr>
>>
>>         <table class="concordtable fullwidth">
>>                 <tr>
>>                         <td align="left" class="cqpweb_copynote" width="33%">
>>                                 CQPweb v3.2.43 &#169; 2008-2020
>>                         </td>
>>                         <td align="center" class="cqpweb_copynote" width="33%">
>>                                 <a class="cqpweb_copynote_link" href="help.php?ui=hello" target="cqpweb_help_browser">Help! on CQPweb</a>
>>                         </td>
>>                         <td align="right" class="cqpweb_copynote" width="33%">
>>                                 You are not logged in
>>                         </td>
>>                 </tr>
>>         </table>
>>
>>
>>         <div id="templateForToolTip" class="floatingToolTip">
>>                 <table class="floatingToolTipFrame">
>>                         <tr>
>>                                 <td class="floatingToolTipTarget">
>>                                         &nbsp;
>>                                 </td>
>>                         </tr>
>>                 </table>
>>         </div>
>>
>>         </body>
>>         
>> </html>
>> PHP Warning: Undefined property: stdClass::$Api in /var/www/tu-dresden_gsw_ali/cqpweb/lib/environment.php on line 1328
>> PHP Fatal error: Uncaught Error: Call to undefined method stdClass::disconnect_slave_program() in /var/www/tu-dresden_gsw_ali/cqpweb/lib/environment.php:1332
>> Stack trace:
>> #0 /var/www/tu-dresden_gsw_ali/cqpweb/lib/exiterror-lib.php(284): cqpweb_shutdown_environment()
>> #1 /var/www/tu-dresden_gsw_ali/cqpweb/lib/environment.php(406): exiterror()
>> #2 /var/www/tu-dresden_gsw_ali/cqpweb/lib/environment.php(1234): CQPwebEnvConfig->__construct()
>> #3 /var/www/tu-dresden_gsw_ali/cqpweb/bin/offline-freqlists.php(97): cqpweb_startup_environment()
>> #4 {main}
>> thrown in /var/www/tu-dresden_gsw_ali/cqpweb/lib/environment.php on line 1332
>-------------- next part --------------
>A non-text attachment was scrubbed...
>Name: smime.p7s
>Type: application/pkcs7-signature
>Size: 5659 bytes
>Desc: not available
>URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20240307/e0e1ca42/attachment.p7s>
>
>------------------------------
>
>_______________________________________________
>CWB mailing list
>CWB@sslmit.unibo.it
>http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>
>
>End of CWB Digest, Vol 203, Issue 5
>***********************************
</pre></div>