[CWB] [CQPweb] MySQL error when installing (revision 1219)

[Scott Sadowsky]

Hi Andrew,

I'm getting the following error when trying to install revision 1219 of
CQPweb:

An SQL query did not run successfully!
Original query:

CREATE TABLE `idlink_fields` (
                        `corpus`       varchar(20)     CHARSET ascii
COLLATE ascii_bin NOT NULL,
                        `att_handle`   varchar(64)        CHARSET ascii
COLLATE ascii_bin NOT NULL,
                        `handle`       varchar(64)      CHARSET ascii
COLLATE ascii_bin NOT NULL,
                        `description`  varchar(255) CHARSET utf8 COLLATE
utf8_general_ci default '',
                        `datatype`     tinyint(2) NOT NULL default 0
                        primary key (`corpus`, `att_handle`, `handle`)
        ) ENGINE=InnoDB
        /* from User: ??? | Function: ???() | 2019-May-29 01:35 */
Error # 1064: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'(`corpus`, `att_handle`, `handle`)
        ) ENGINE=InnoDB
        /* from User: ??? | Funct' at line 7


PHP debugging backtrace
=======================
array(4) {
  [1]=>
  array(4) {
    ["file"]=>
    string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"
    ["line"]=>
    int(300)
    ["function"]=>
    string(9) "exiterror"
    ["args"]=>
    array(3) {
      [0]=>
      array(3) {
        [0]=>
        string(38) "An SQL query did not run successfully!"
        [1]=>
        string(539) "Original query:

CREATE TABLE `idlink_fields` (
                        `corpus`       varchar(20)     CHARSET ascii
COLLATE ascii_bin NOT NULL,
                        `att_handle`   varchar(64)        CHARSET ascii
COLLATE ascii_bin NOT NULL,
                        `handle`       varchar(64)      CHARSET ascii
COLLATE ascii_bin NOT NULL,
                        `description`  varchar(255) CHARSET utf8 COLLATE
utf8_general_ci default '',
                        `datatype`     tinyint(2) NOT NULL default 0
                        primary key (`corpus`, `att_handle`, `handle`)
        ) ENGINE=InnoDB
        /* from User: ??? | Function: ???() | 2019-May-29 01:35 */

"
        [2]=>
        string(241) "Error # 1064: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '(`corpus`, `att_handle`, `handle`)
        ) ENGINE=InnoDB
        /* from User: ??? | Funct' at line 7 "
      }
      [1]=>
      NULL
      [2]=>
      NULL
    }
  }
  [2]=>
  array(4) {
    ["file"]=>
    string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
    ["line"]=>
    int(179)
    ["function"]=>
    string(20) "exiterror_mysqlquery"
    ["args"]=>
    array(3) {
      [0]=>
      int(1064)
      [1]=>
      string(226) "You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near '(`corpus`, `att_handle`, `handle`)
        ) ENGINE=InnoDB
        /* from User: ??? | Funct' at line 7"
      [2]=>
      string(519) "CREATE TABLE `idlink_fields` (
                        `corpus`       varchar(20)     CHARSET ascii
COLLATE ascii_bin NOT NULL,
                        `att_handle`   varchar(64)        CHARSET ascii
COLLATE ascii_bin NOT NULL,
                        `handle`       varchar(64)      CHARSET ascii
COLLATE ascii_bin NOT NULL,
                        `description`  varchar(255) CHARSET utf8 COLLATE
utf8_general_ci default '',
                        `datatype`     tinyint(2) NOT NULL default 0
                        primary key (`corpus`, `att_handle`, `handle`)
        ) ENGINE=InnoDB
        /* from User: ??? | Function: ???() | 2019-May-29 01:35 */"
    }
  }
  [3]=>
  array(4) {
    ["file"]=>
    string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
    ["line"]=>
    int(1011)
    ["function"]=>
    string(12) "do_sql_query"
    ["args"]=>
    array(1) {
      [0]=>
      string(519) "CREATE TABLE `idlink_fields` (
                        `corpus`       varchar(20)     CHARSET ascii
COLLATE ascii_bin NOT NULL,
                        `att_handle`   varchar(64)        CHARSET ascii
COLLATE ascii_bin NOT NULL,
                        `handle`       varchar(64)      CHARSET ascii
COLLATE ascii_bin NOT NULL,
                        `description`  varchar(255) CHARSET utf8 COLLATE
utf8_general_ci default '',
                        `datatype`     tinyint(2) NOT NULL default 0
                        primary key (`corpus`, `att_handle`, `handle`)
        ) ENGINE=InnoDB
        /* from User: ??? | Function: ???() | 2019-May-29 01:35 */"
    }
  }
  [4]=>
  array(4) {
    ["file"]=>
    string(38) "/var/www/html/cqpweb/bin/autosetup.php"
    ["line"]=>
    int(92)
    ["function"]=>
    string(18) "do_sql_total_reset"
    ["args"]=>
    array(0) {
    }
  }
}
PHP Fatal error:  Uncaught Error: Call to undefined method
NotAFullConfig::disconnect_slave_program() in
/var/www/html/cqpweb/lib/environment.php:1334
Stack trace:
#0 /var/www/html/cqpweb/lib/exiterror-lib.php(231):
cqpweb_shutdown_environment()
#1 /var/www/html/cqpweb/lib/exiterror-lib.php(300): exiterror(Array, NULL,
NULL)
#2 /var/www/html/cqpweb/lib/sql-lib.php(179): exiterror_mysqlquery(1064,
'You have an err...', 'CREATE TABLE `i...')
#3 /var/www/html/cqpweb/lib/sql-lib.php(1011): do_sql_query('CREATE TABLE
`i...')
#4 /var/www/html/cqpweb/bin/autosetup.php(92): do_sql_total_reset()
#5 {main}
  thrown in /var/www/html/cqpweb/lib/environment.php on line 1334

Best,
Scott
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190529/be602933/attachment-0001.html>