[CWB] Error with idlink

[Hardie, Andrew]

Hi José,

Thanks – that helped me track down a pretty severe bug!

In any case – here’s your fix. Run the following from the MySQL command line:

DROP TABLE IF EXISTS `text_metadata_values`;
DROP TABLE IF EXISTS `idlink_values`;

CREATE TABLE `text_metadata_values` (
   `corpus` varchar(20) NOT NULL,
   `field_handle` varchar(64) NOT NULL,
   `handle` varchar(200) NOT NULL,
   `description` varchar(255) default NULL,
   `category_num_files` int unsigned default NULL,
   `category_num_words` int unsigned default NULL,
   primary key(`corpus`, `field_handle`, `handle`)
  ) CHARACTER SET utf8 COLLATE utf8_bin;

CREATE TABLE `idlink_values` (
   `corpus` varchar(20) NOT NULL,
   `att_handle` varchar(64) NOT NULL,
   `field_handle` varchar(64) NOT NULL,
   `handle` varchar(200) NOT NULL,
   `description` varchar(255) default NULL,
   `category_n_items` int unsigned default NULL,
   `category_n_tokens` int unsigned default NULL,
   primary key(`corpus`, `att_handle`, `field_handle`, `handle`)
) CHARACTER SET utf8 COLLATE utf8_bin;


Then delete/reinstall the text metadata for your corpus, then change the datatype of your XML attributes to free text, then back to idlink, and it should now be possible to install the table.

best

Andrew.

From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of José Manuel Martínez Martínez
Sent: 07 July 2018 06:44
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: Re: [CWB] Error with idlink

Hi, Andrew,

thanks for your reply. I tried that,

/var/www/html/cqpweb/bin$ php upgrade-database.php
CQPweb database is now at or above the most-recently-changed version (3.2.27). Upgrade complete!

However, the problem persists.

I'm copy-pasting below the PHP traceback in case helps for a change of data type from ID link to free text:

PHP debugging backtrace
array(5) {
  [1]=>
  array(4) {
    ["file"]=>
    string(40) "/var/www/html/cqpweb/lib/library.inc.php"
    ["line"]=>
    int(286)
    ["function"]=>
    string(20) "exiterror_mysqlquery"
    ["args"]=>
    array(3) {
      [0]=>
      int(1146)
      [1]=>
      string(45) "Table 'cqpweb_db.idlink_values' doesn't exist"
      [2]=>
      string(167) "delete from idlink_values where corpus = 'empac_en' and att_handle = 'text_srt_url'
            /* from User: jmartinez | Function: delete_xml_idlink() | 2018-Jul-07 05:41:30 */"
    }
  }
  [2]=>
  array(4) {
    ["file"]=>
    string(36) "/var/www/html/cqpweb/lib/xml.inc.php"
    ["line"]=>
    int(1119)
    ["function"]=>
    string(14) "do_mysql_query"
    ["args"]=>
    array(1) {
      [0]=>
      &string(167) "delete from idlink_values where corpus = 'empac_en' and att_handle = 'text_srt_url'
            /* from User: jmartinez | Function: delete_xml_idlink() | 2018-Jul-07 05:41:30 */"
    }
  }
  [3]=>
  array(4) {
    ["file"]=>
    string(36) "/var/www/html/cqpweb/lib/xml.inc.php"
    ["line"]=>
    int(296)
    ["function"]=>
    string(17) "delete_xml_idlink"
    ["args"]=>
    array(2) {
      [0]=>
      string(8) "empac_en"
      [1]=>
      string(12) "text_srt_url"
    }
  }
  [4]=>
  array(4) {
    ["file"]=>
    string(47) "/var/www/html/cqpweb/lib/metadata-admin.inc.php"
    ["line"]=>
    int(275)
    ["function"]=>
    string(19) "change_xml_datatype"
    ["args"]=>
    array(3) {
      [0]=>
      string(8) "empac_en"
      [1]=>
      string(12) "text_srt_url"
      [2]=>
      int(2)
    }
  }
  [5]=>
  array(4) {
    ["file"]=>
    string(43) "/var/www/html/cqpweb/exe/metadata-admin.php"
    ["line"]=>
    int(3)
    ["args"]=>
    array(1) {
      [0]=>
      string(47) "/var/www/html/cqpweb/lib/metadata-admin.inc.php"
    }
    ["function"]=>
    string(7) "require"
  }
}
CQPweb v3.2.31 © 2008-2018          Help! on CQPweb      You are logged in as user [jmartinez]



--
José Manuel Martínez Martínez
https://chozelinek.github.io

On Fri, Jul 6, 2018 at 12:07 PM, Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>> wrote:
I think this problem will go away if you run the upgrade-database script!

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 José Manuel Martínez Martínez
Sent: 06 July 2018 02:00
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it<mailto:cwb at sslmit.unibo.it>>
Subject: [CWB] Error with idlink

Hi there,

I've been trying to install an already indexed corpus. When I was in Manage corpus XML I changed the data type of an structural attribute from free text to ID link. I clicked on Change and I could see the following ID link (linked table does not exist)

Then I decided to roll back to free text, but then I got the following message:

A MySQL query did not run successfully!

Original query: delete from idlink_values where corpus = 'empac_en' and att_handle = 'text_srt_url' /* from User: jmartinez | Function: delete_xml_idlink() */

Error # 1146: Table 'cqpweb_db.idlink_values' doesn't exist

I then tried to delete the corpus and start from scratch again, but this seems not to work either:

A MySQL query did not run successfully!

Original query: delete from idlink_values where corpus = 'empac_en' and att_handle = 'text_srt_url' /* from User: jmartinez | Function: delete_xml_idlink() | 2018-Jul-06 00:59:27 */

Error # 1146: Table 'cqpweb_db.idlink_values' doesn't exist

Any help with this will be much appreciated!

Cheers,

--
José Manuel Martínez Martínez
https://chozelinek.github.io

_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it<mailto:CWB at sslmit.unibo.it>
http://liste.sslmit.unibo.it/mailman/listinfo/cwb

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20180707/b6e07450/attachment-0001.html>