[CWB] Can't delete corpus from CQPweb

[Hardie, Andrew]

Hi Simon,

Looks like you have managed to delete one or more of the system database tables. To restore this one in particular run this in the mysql client...

CREATE TABLE `idlink_values` (
  `corpus` varchar(20) COLLATE utf8_bin NOT NULL,
  `att_handle` varchar(64) COLLATE utf8_bin NOT NULL,
  `field_handle` varchar(64) COLLATE utf8_bin NOT NULL,
  `handle` varchar(200) COLLATE utf8_bin NOT NULL,
  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `category_n_items` int(10) unsigned DEFAULT NULL,
  `category_n_tokens` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`corpus`,`att_handle`,`field_handle`,`handle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

... but you might find other tables are missing too. If so, create statements can be found in the file sql-definitions.php

best

Andrew.


-----Original Message-----
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Meier-Vieracker, Simon
Sent: 06 February 2019 07:51
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: [CWB] Can't delete corpus from CQPweb

Hi,

i faced some problems with the Unique Text ID when trying to install a corpus on CQPweb. I even made it worse when trying to fix it. Unfortunately, now I am not able to delete the corpus, but I cannot change the erroneous setting, too, because of "Error # 1146: Table 'cqpweb_db.idlink_values' doesn't exist" (see debugging backtrace below).

Any suggestions how I can fix this manually?

Best, Simon



array(8) {
  [1]=>
  array(4) {
    ["file"]=>
    string(36) "/home/cqp/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(165) "delete from idlink_values where corpus = 'sotu' and att_handle = 'text_id' 
	/* from User: fussballlinguist | Function: delete_xml_idlink() | 2019-Feb-06 07:07:47 */"
    }
  }
  [2]=>
  array(4) {
    ["file"]=>
    string(32) "/home/cqp/CQPweb/lib/xml.inc.php"
    ["line"]=>
    int(966)
    ["function"]=>
    string(14) "do_mysql_query"
    ["args"]=>
    array(1) {
      [0]=>
      &string(74) "delete from idlink_values where corpus = 'sotu' and att_handle = 'text_id'"
    }
  }
  [3]=>
  array(4) {
    ["file"]=>
    string(38) "/home/cqp/CQPweb/lib/admin-lib.inc.php"
    ["line"]=>
    int(338)
    ["function"]=>
    string(17) "delete_xml_idlink"
    ["args"]=>
    array(2) {
      [0]=>
      &string(4) "sotu"
      [1]=>
      &string(7) "text_id"
    }
  }
  [4]=>
  array(2) {
    ["function"]=>
    string(25) "delete_corpus_from_cqpweb"
    ["args"]=>
    array(1) {
      [0]=>
      &string(4) "sotu"
    }
  }
  [5]=>
  array(4) {
    ["file"]=>
    string(36) "/home/cqp/CQPweb/lib/execute.inc.php"
    ["line"]=>
    int(180)
    ["function"]=>
    string(20) "call_user_func_array"
    ["args"]=>
    array(2) {
      [0]=>
      &string(25) "delete_corpus_from_cqpweb"
      [1]=>
      &array(1) {
        [0]=>
        string(4) "sotu"
      }
    }
  }
  [6]=>
  array(4) {
    ["file"]=>
    string(42) "/home/cqp/CQPweb/lib/admin-execute.inc.php"
    ["line"]=>
    int(139)
    ["args"]=>
    array(1) {
      [0]=>
      string(36) "/home/cqp/CQPweb/lib/execute.inc.php"
    }
    ["function"]=>
    string(7) "require"
  }
  [7]=>
  array(4) {
    ["file"]=>
    string(38) "/home/cqp/CQPweb/lib/adminhome.inc.php"
    ["line"]=>
    int(39)
    ["args"]=>
    array(1) {
      [0]=>
      string(42) "/home/cqp/CQPweb/lib/admin-execute.inc.php"
    }
    ["function"]=>
    string(7) "require"
  }
  [8]=>
  array(4) {
    ["file"]=>
    string(30) "/home/cqp/CQPweb/adm/index.php"
    ["line"]=>
    int(3)
    ["args"]=>
    array(1) {
      [0]=>
      string(38) "/home/cqp/CQPweb/lib/adminhome.inc.php"
    }
    ["function"]=>
    string(7) "require"
  }
}

-------

Dr. Simon Meier

Technische Universität Berlin
Institut für Sprache und Kommunikation
Fachgebiet Allgemeine Linguistik
Sekretariat H42
Straße des 17. Juni 135, 10623 Berlin
+49 (0) 30 314 22323
simon.meier at tu-berlin.de
http://www.linguistik.tu-berlin.de/menue/mitarbeiterinnen/wiss_mitarbeiterinnen/simon_meier/




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