<div style="line-height:1.7;color:#000000;font-size:14px;font-family:arial">Hi there,<br>This is Ray Wu from China. This is my first time being here. My solution to you all on the list.<br><br>I am a college ESL teacher and just a few days ago I started to learn CQPweb, both for teaching and research. Now I am fiddling with a toy corpus on CQPweb to get initiated.<br><br>My toy corpus is as suggested in Andrew's paper: test.vrt (encoded in ISO-8859-1)<br><text id="test"><br><s><br>The AT0 the<br>cat NN1 cat<br>sat VVD sit<br>on PRP on<br>the AT0 the<br>mat NN1 mat<br>. PUN .<br></s><br><s><br>Many DT0 many<br>cats NN2 cat<br>sit VVB sit<br>on PRP on<br>mats NN2 mat<br>. PUN .<br></s><br></text><br><br>My metadata file: test_meta.dat (encoded in ISO-8859-1, tab separated)<br>text_id genre sampled<br>test press &n
bsp; all <br><br>Presently, the corpus can be loaded into CQPweb without any fuss. But when I arrived at the "Admin tools for managing corpus metadata" page, I hit upon an error. Here are my then choices on that page:<br>field 1 genre classification<br>field 2 sampled classification<br><br>After clicking "install metadata table using the settings above", I got an error message like this:<br>A mySQL query did not run successfully!<br>Error # 1062: Duplicate entry 'test-__HANDLE' for key 1 <br><br>I then peeped into MySQL and found the following 4 tables concerning metadata:<br>mysql> show tables;<br>...<br>corpus_metadata_fixed (empty)<br>corpus_metadata_variable (empty)<br>...<br>text_metadata_fields<br>text_metadata_values (empty)<br>...<br><br>mysql> select * from text_metadata_fields
;<br>+--------+----------+-------------+-------------------+<br>| corpus | handle | description | is_classification |<br>+--------+----------+-------------+-------------------+<br>| test | genre | | 1 | <br>| test | sampled | | 1 | <br>| test | __HANDLE | | 0 | <br>+--------+----------+-------------+-------------------+<br><br>But if I click "create mini
malist metadata table", a metadata table can be created successfully and I could start to query.<br>mysql> select * from text_metadata_for_test;<br>+---------+-------+-----------+---------+<br>| text_id | words | cqp_begin | cqp_end |<br>+---------+-------+-----------+---------+<br>| test | 13 | 0 | 12 | <br>+---------+-------+-----------+---------+<br><br>This frustrates me as I know that without metadata, a corpus is of little value for search/research. Has anyone encountered similar messages before?<br><br>I have browsed all the archived mailinglist but found no direct answer to this problem (but I haven't looked at the source code yet). I don't know whether this indicates I need to manually add a few columns to the text_metadata_for_test table or I have just missed something important to get it done. Thanks
for any pointers.<br><br>My thanks also goes to Andrew for a previous help regarding a CQPweb 3.0.5 file-write permission problem in a personal emai and pointing me at here. Thank you, Andrew.<br><br>PS: my computer paratemers:<br>System: Ubuntu 8.04<br>Apache: 2.0.63<br>MySQL: 5.0.88<br>PHP: 5.2.12 (lower than expected 5.3.0)<br>Perl: 5.8.8<br>CWB: 3.0.0<br>Linux utilites: awk, tar, gzip, iconv<br><br><div><span style="color: rgb(128, 128, 128);"><span style="color: rgb(128, 128, 128);">Wu Liangping</span><br><span style="color: rgb(128, 128, 128);">
School of International Studies</span><br><span style="color: rgb(128, 128, 128);">
Hunan University of Commerce</span><br><span style="color: rgb(128, 128, 128);">
PO Box 410000</span><br><span style="color: rgb(128, 128, 128);">
Changsha, China </span></span></div></div><br><br><span title="neteasefooter"><span id="netease_mail_footer"></span></span>