[CWB] Can't delete corpus from CQPweb

[Meier-Vieracker, Simon]

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/