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

(Ray) WU Liangping liangpingwu at 126.com
Wed Oct 28 17:30:30 CET 2015


Thanks for the update. Much appreciated.

Liangping




At 2015-10-28 21:25:03, "Hardie, Andrew" <a.hardie at lancaster.ac.uk> wrote:


No, it’s something else: a mistake in the fix I gave you before.

 

When I said

 

Add the following line at the top of indexforms-admin.inc.php :

          require("../lib/xml.inc.php");

 

…. it should have been added at the top of adminhome.inc.php instead. Sorry!

 

Andrew.

 

From:cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of (Ray) WU Liangping
Sent: 28 October 2015 10:04
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

 

Wait a moment.
When deleting a corpus (just for trial , with all patches done), I got another empty page in v3.2.4.
The error log says:
[Wed Oct 28 17:54:03 2015] [error] [client 127.0.0.1] PHP Fatal error:  Cannot redeclare list_xml_all() (previously declared in /usr/local/apache2/htdocs/lib/xml.inc.php:78) in /usr/local/apache2/htdocs/lib/xml.inc.php on line 88, referer: http://127.0.1.1/adm/index.php?thisF=deleteCorpus&corpus=brown&uT=y

But I could only see one list_xml_all() function in xml.inc.php.
Could this be a PHP version issue, again?

Liangping

 


At 2015-10-28 13:22:31, "Hardie, Andrew" <a.hardie at lancaster.ac.uk> wrote:



Ah, this brings back memories – this was the cluster of bugs that I fixed in 3.2.1.

 

Anyway:

no 1 – Timezone error - can be ignored. Error on reinstallation -– known, cleanup of the xml_metadata was not added till 3.2.4., you can do it manually though:

delete from xml_metadata where corpus="put name of corpus you deleted here"

no 2 – fix manually as follows:

Add the following line at the top of indexforms-admin.inc.php :

          require("../lib/xml.inc.php");

          In the file exe/metadata-admin.php, change the reference metadata-create.inc.php to  refer to tometadata-admin.inc.php

 

Or just wait for me to finish 3.2.4…

 

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 11:11
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

 

I reinstalled v3.2.1 (using the tarball) from scratch to reproduce the errors. The following are what I got:

1. In the system installation step:
(when running autosetup.php)PHP Warning:  date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Chongqing' for 'CST/8.0/no DST' instead in /usr/local/apache2/htdocs/lib/library.inc.php on line 225


(when reinstall a corpus after deleting it)Error # 1062: Duplicate entry 'brown-text' for key 2.  This indicates a deleting of a failed corpus is not clean enough so I just drop the database and re-created it every time I fail to install a corpus correctly in v3.2.1.

2. In the corpus installation step:
(when installing the metadat) After choosing "No thanks, I'll run this myself (safer for very large corpora) ", I got an empty page. The following are what I found in Apache's error_log file:
[Tue Oct 27 18:58:09 2015] [error] [client 127.0.0.1] PHP Fatal error:  Call to undefined function list_xml_with_content() in /usr/local/apache2/htdocs/lib/indexforms-admin.inc.php on line 893, referer: http://127.0.1.1/adm/index.php?thisF=installCorpusDone&newlyInstalledCorpus=brown&uT=y
[Tue Oct 27 18:58:49 2015] [error] [client 127.0.0.1] PHP Fatal error:  Call to undefined function list_xml_with_content() in /usr/local/apache2/htdocs/lib/indexforms-admin.inc.php on line 893, referer: http://127.0.1.1/brown/index.php?thisQ=corpusSettings&uT=y
[Tue Oct 27 18:59:40 2015] [error] [client 127.0.0.1] PHP Warning:  require(../lib/metadata-create.inc.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /usr/local/apache2/htdocs/exe/metadata-admin.php on line 3, referer: http://127.0.1.1/brown/index.php?thisQ=manageMetadata&uT=y

[Tue Oct 27 18:59:40 2015] [error] [client 127.0.0.1] PHP Fatal error:  require() [<a href='function.require'>function.require</a>]: Failed opening required '../lib/metadata-create.inc.php' (include_path='.:/usr/local/lib/php') in /usr/local/apache2/htdocs/exe/metadata-admin.php on line 3, referer: http://127.0.1.1/brown/index.php?thisQ=manageMetadata&uT=y

I can find no metadata-create.inc.php in the lib directory, but just metadata-admin.inc.php instead.

Liangping
 


At 2015-10-27 15:50:27, "Hardie, Andrew" <a.hardie at lancaster.ac.uk> wrote:

Sorry but I need more info on the precise error on “still cannot handle the metadata so no frequency data can be generated”!

 

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:25
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,

Thanks for the script and the v3.2.1 can leap one step forward but still cannot handle the metadata so no frequency data can be generated.
I also checked the error log (not the access log) for v3.2.4 but nothing is there.

Ok, maybe more work on me to sort out what's going wrong on my particular server.

Best,
Liangping

 


At 2015-10-27 15:18:43, "Hardie, Andrew" <a.hardie at lancaster.ac.uk> wrote:

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> 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> 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] On Behalf Of (Ray) WU Liangping
Sent: 27 October 2015 05:58
To: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/20151029/238ff984/attachment-0001.html>


More information about the CWB mailing list