[CWB] Error with idlink

[José Manuel Martínez Martínez]

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>
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] *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
> >
> *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
> 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/884d8b38/attachment-0001.html>