[CWB] Displaying of multiple P attributes

Fri Dec 11 19:38:31 CET 2020

Have you installed the text metadata? The error indicates that the text metadata table does not exist. So either you have omitted to create it (which you need to do before creating frequency lists), or there is a bug…

best

Andrew.

From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of mansur
Sent: 11 December 2020 13:18
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: Re: [CWB] Displaying of multiple P attributes

Thank you, Andrew! Now it works! But I cannot generate freqlists offline. Generating them online works fine!

# php offline-freqlists.php t_corpus_v1_1
...
About to run the function populating corpus CQP positions...

An SQL query did not run successfully!
Original query:
        update `_txmd_000001` inner join `__tmp_1aumyeg88zgkc0w8wsc008osg`
                                                                on   `_txmd_000001`.text_id    = `__tmp_1aumyeg88zgkc0w8wsc008osg`.text_id
                                                                set  `_txmd_000001`.cpos_begin = `__tmp_1aumyeg88zgkc0w8wsc008osg`.cpos_begin,
                                                                         `_txmd_000001`.cpos_end   = `__tmp_1aumyeg88zgkc0w8wsc008osg`.cpos_end
Error # 1146: Table 'cqpweb._txmd_000001' doesn't exist

PHP callstack backtrace
=======================
#1          exiterror-lib.php @ 482  : exiterror(Array[3]("An SQL query did not run succe..." , ...), NULL, NULL)
#2                sql-lib.php @ 803  : exiterror_sqlquery(1146, "Table 'cqpweb._txmd_000001' do...", "update `_txmd_000001` inner jo...")
#3             corpus-lib.php @ 1138 : do_sql_transaction_query("update `_txmd_000001` inner jo...")
#4      offline-freqlists.php @ 149  : populate_corpus_cqp_positions("t_corpus_v1_1")

Am Fr., 11. Dez. 2020 um 14:50 Uhr schrieb Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>>:
OK, those should both be fixed in trunk now. – Andrew.

From: Hardie, Andrew
Sent: 11 December 2020 12:32
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it<mailto:cwb at sslmit.unibo.it>>
Subject: RE: Re: [CWB] Displaying of multiple P attributes

Looks like a bug. I’ll investigate. – Andrew.

From: cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it> <cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it>> On Behalf Of mansur
Sent: 11 December 2020 12:14
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it<mailto:cwb at sslmit.unibo.it>>
Subject: Re: [CWB] Displaying of multiple P attributes

Hi!

Andrew, that is strange. Autosetup doesn't work in 3.3 from trunc:

# php autosetup.php

Now finalising setup for this installation of CQPweb....

Installing database structure; please wait.
<tr><td class="layout-contrast">
<p class="errormessage">An SQL query did not run successfully!</p>
<p class="errormessage">Original query:
        CREATE TABLE `text_metadata_values` (
                        `id`                         int unsigned NOT NULL AUTO_INCREMENT,
                        `field_id`                   int unsigned NOT NULL,
                        `handle`                     varchar(200)   CHARSET ascii COLLATE ascii_bin NOT NULL,
                        `description`                varchar(255) CHARSET utf8mb4 collate utf8mb4_unicode_520_nopad_ci default '',
                        `n_texts`                    int unsigned NOT NULL default 0,
                        `n_tokens`                   bigint unsigned NOT NULL default 0,
                        unique key `field_id_handle`(`field_id`, `handle`),
                        key
                ) ENGINE=InnoDB
        /* from User: ??? | In file: /var/www/html/cqpweb/bin/autosetup.php @ line 104 | 2020-Dec-11 08:18 */</p>
<p class="errormessage">Error # 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ENGINE=InnoDB
        /* from User: ??? | In file: /var/www/html/cqpweb/bin/auto...' at line 10</p>
</td></tr>
...

I tried autoconfig.php, it also doesn't work:
# php autoconfig.php

/***********************/

This is the interactive configuration-file creator for CQPweb.

First, you must enter a username for the system adminstrator account, or 'superuser'.
PHP Fatal error:  Uncaught ArgumentCountError: Too few arguments to function get_variable_username(), 0 passed in /var/www/html/cqpweb/bin/autoconfig.php on line 49 and exactly 1 expected in /var/www/html/cqpweb/bin/cli-lib.php:288
Stack trace:
#0 /var/www/html/cqpweb/bin/autoconfig.php(49): get_variable_username()
#1 {main}
  thrown in /var/www/html/cqpweb/bin/cli-lib.php on line 288

Am Fr., 11. Dez. 2020 um 14:06 Uhr schrieb Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>>:
3.3 is the version in trunk. Still has some known bugs but it’s rather more stable than it was back in March (the Lancaster server has been running it mostly happily since then).

>> Is it possible to make glosses multiline.

Yes in 3.3. but you’d need to write the code for it to reformat the embedded data, which would be complex. In 3.2, no, except with a LOT of hacking about.

best

Andrew.

From: cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it> <cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it>> On Behalf Of mansur
Sent: 10 December 2020 17:13
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it<mailto:cwb at sslmit.unibo.it>>
Subject: Re: [CWB] Displaying of multiple P attributes

Hi, Andrew!

Thank you for the advice. I will try it tomorrow, which repository/directory should I use to get version 3.3? Now I am using 3.2-latest.

Another question arose. Is it possible to make glosses multiline. Inserting tag <br> doesn't work there. My idea was to put there several attributes and divide them into lines.

With best wishes,
Mansur

Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>> schrieb am Do., 10. Dez. 2020, 19:00:
Hi Mansur,

CQPweb v3.3 can embed arbitrary p-attribute data into <span> elements in the concordance HTML. Youi can then use an extra JavaScript file to render them in the interface however you like.

The control for this is under “Manage visualisation”, and looks like this:

Error! Filename not specified.

In version 3.2 things are much more limited. You only really have access to the word and primary annotation, which is what shows up in the tooltip.

best

Andrew.

From: cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it> <cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it>> On Behalf Of mansur
Sent: 10 December 2020 09:23
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it<mailto:cwb at sslmit.unibo.it>>
Subject: [CWB] Displaying of multiple P attributes

Hi!

Our corpora have many layers of word level annotation (P): wordforms in several variants, lemmas in 2 variants, pos, additional morph-l tags and some others...

What is the best way of displaying them all in found sentences? I could only find a way of displaying "word_POS word2_POS2..." in tooltips. Using tooltips looks like a good choice, but any other way is also acceptable. But how to display all those P attributes? And I suppose it is better to display such a big amount of P-attributes in vertical format, not? Any ideas, recommendations, please?

With best wishes,
Mansur
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it<mailto:CWB at sslmit.unibo.it>
http://liste.sslmit.unibo.it/mailman/listinfo/cwb<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&data=04%7C01%7Ca.hardie%40lancaster.ac.uk%7C09263eb7e1454fd5af6608d89dd73cc0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637432895055233840%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=BtqATEiiAEfA34HXFveK64oEcNx8CZiDCCig3chfqXo%3D&reserved=0>
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it<mailto:CWB at sslmit.unibo.it>
http://liste.sslmit.unibo.it/mailman/listinfo/cwb<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&data=04%7C01%7Ca.hardie%40lancaster.ac.uk%7C09263eb7e1454fd5af6608d89dd73cc0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637432895055243801%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=VtNyMPjFbaeko6PoIZziEiA4Cr7w1HqdAUDyte%2F32So%3D&reserved=0>
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it<mailto:CWB at sslmit.unibo.it>
http://liste.sslmit.unibo.it/mailman/listinfo/cwb<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&data=04%7C01%7Ca.hardie%40lancaster.ac.uk%7C09263eb7e1454fd5af6608d89dd73cc0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637432895055243801%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=VtNyMPjFbaeko6PoIZziEiA4Cr7w1HqdAUDyte%2F32So%3D&reserved=0>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20201211/1a097285/attachment-0001.html>