[CWB] CQPweb 3.2.4 related: query returns a blank page and corpus deletion partial

[Hardie, Andrew]

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:

CREATE TABLE `xml_metadata` (
                       `id` int NOT NULL AUTO_INCREMENT,
                       `corpus` varchar(20) NOT NULL,
                       `handle` varchar(64) NOT NULL,
                       `att_family` varchar(64) NOT NULL default '',
                       `description` varchar(255) default NULL,
                       `datatype`  tinyint(2) NOT NULL default 0,
                       primary key(`id`),
                       unique key (`corpus`, `handle`)
               ) CHARACTER SET utf8 COLLATE utf8_bin;

Andrew.


From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of (Ray) WU Liangping
Sent: 27 October 2015 07:13
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] CQPweb 3.2.4 related: query returns a blank page and corpus deletion partial

hi Andrew,

I tried the older tarballed v3.2.1 on the same server with the same configurations, but the corpus installation is not successful.

1) After some error messages, the site is up and running;
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 */
Error # 1146: Table 'cqpweb_data.xml_metadata' doesn't exist

However, the corpus can be deleted without any problem in v3.2.1, which is not possible in v3.2.4.

Best,
Liangping

At 2015-10-27 14:35:32, "(Ray) WU Liangping" <liangpingwu at 126.com<mailto:liangpingwu at 126.com>> wrote:

hi Andrew,

The Apache logs says no error about the empty page after a query, just some access info:
  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 -

The deletion gets the same info (no error, just access traces):
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 -

Even a re-deletion of the same corpus (it just hangs on there) generates no error in the Apache logs.

But a re-run of Frequency lists do generate the following error: Error # 1146: Table 'cqpweb_data.freq_corpus_brown_word' doesn't exist.

My server is happy with the old v3.0.7 version but not this one. Maybe I'd better wait for a few moments.

I also want to try the more stable v3.2.3 version, but the command " svn co http://svn.code.sf.net/p/cwb/code/gui/cqpweb/branches/3.2.3 cqpweb " doesn't seem to work (no file error returned).

I am trying the tarballed v3.2.1 now to see whether this is a version issue or some misconfiguration of my server.

Best,
Liangping




At 2015-10-27 14:05:59, "Hardie, Andrew" <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>> wrote:

Hi Liangpeng,

Can you check your server log to see if there is a corresponding error message written when these errors occur?

These things aren’t happening on my own machine, so it’s difficult to diagnose without  an error message.

You may also have an uneven set of code files – I am still working on some stuff…

best

Andrew.

From: cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it> [mailto:cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it>] On Behalf Of (Ray) WU Liangping
Sent: 27 October 2015 05:58
To: cwb at sslmit.unibo.it<mailto:cwb at sslmit.unibo.it>
Subject: [CWB] CQPweb 3.2.4 related: query returns a blank page and corpus deletion partial

Hi all,

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.
Currently I have two problems:
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.
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).

Any hints?
Thanks.

Best,
WU Liangping

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20151027/ba3bcc41/attachment-0001.html>