<div dir="ltr">Hi Andrew,<div><br></div><div>I&#39;m getting the following error when trying to install revision 1219 of CQPweb:</div><div><br></div><div><font face="courier new, monospace">An SQL query did not run successfully!<br>Original query: <br><br>CREATE TABLE `idlink_fields` (<br>                        `corpus`       varchar(20)     CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `att_handle`   varchar(64)        CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `handle`       varchar(64)      CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `description`  varchar(255) CHARSET utf8 COLLATE utf8_general_ci default &#39;&#39;,<br>                        `datatype`     tinyint(2) NOT NULL default 0<br>                        primary key (`corpus`, `att_handle`, `handle`)<br>        ) ENGINE=InnoDB  <br>        /* from User: ??? | Function: ???() | 2019-May-29 01:35 */<br>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 &#39;(`corpus`, `att_handle`, `handle`)<br>        ) ENGINE=InnoDB  <br>        /* from User: ??? | Funct&#39; at line 7<br><br><br>PHP debugging backtrace<br>=======================<br>array(4) {<br>  [1]=&gt;<br>  array(4) {<br>    [&quot;file&quot;]=&gt;<br>    string(42) &quot;/var/www/html/cqpweb/lib/exiterror-lib.php&quot;<br>    [&quot;line&quot;]=&gt;<br>    int(300)<br>    [&quot;function&quot;]=&gt;<br>    string(9) &quot;exiterror&quot;<br>    [&quot;args&quot;]=&gt;<br>    array(3) {<br>      [0]=&gt;<br>      array(3) {<br>        [0]=&gt;<br>        string(38) &quot;An SQL query did not run successfully!&quot;<br>        [1]=&gt;<br>        string(539) &quot;Original query: <br><br>CREATE TABLE `idlink_fields` (<br>                        `corpus`       varchar(20)     CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `att_handle`   varchar(64)        CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `handle`       varchar(64)      CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `description`  varchar(255) CHARSET utf8 COLLATE utf8_general_ci default &#39;&#39;,<br>                        `datatype`     tinyint(2) NOT NULL default 0<br>                        primary key (`corpus`, `att_handle`, `handle`)<br>        ) ENGINE=InnoDB  <br>        /* from User: ??? | Function: ???() | 2019-May-29 01:35 */<br><br>&quot;<br>        [2]=&gt;<br>        string(241) &quot;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 &#39;(`corpus`, `att_handle`, `handle`)<br>        ) ENGINE=InnoDB  <br>        /* from User: ??? | Funct&#39; at line 7 &quot;<br>      }<br>      [1]=&gt;<br>      NULL<br>      [2]=&gt;<br>      NULL<br>    }<br>  }<br>  [2]=&gt;<br>  array(4) {<br>    [&quot;file&quot;]=&gt;<br>    string(36) &quot;/var/www/html/cqpweb/lib/sql-lib.php&quot;<br>    [&quot;line&quot;]=&gt;<br>    int(179)<br>    [&quot;function&quot;]=&gt;<br>    string(20) &quot;exiterror_mysqlquery&quot;<br>    [&quot;args&quot;]=&gt;<br>    array(3) {<br>      [0]=&gt;<br>      int(1064)<br>      [1]=&gt;<br>      string(226) &quot;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 &#39;(`corpus`, `att_handle`, `handle`)<br>        ) ENGINE=InnoDB  <br>        /* from User: ??? | Funct&#39; at line 7&quot;<br>      [2]=&gt;<br>      string(519) &quot;CREATE TABLE `idlink_fields` (<br>                        `corpus`       varchar(20)     CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `att_handle`   varchar(64)        CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `handle`       varchar(64)      CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `description`  varchar(255) CHARSET utf8 COLLATE utf8_general_ci default &#39;&#39;,<br>                        `datatype`     tinyint(2) NOT NULL default 0<br>                        primary key (`corpus`, `att_handle`, `handle`)<br>        ) ENGINE=InnoDB  <br>        /* from User: ??? | Function: ???() | 2019-May-29 01:35 */&quot;<br>    }<br>  }<br>  [3]=&gt;<br>  array(4) {<br>    [&quot;file&quot;]=&gt;<br>    string(36) &quot;/var/www/html/cqpweb/lib/sql-lib.php&quot;<br>    [&quot;line&quot;]=&gt;<br>    int(1011)<br>    [&quot;function&quot;]=&gt;<br>    string(12) &quot;do_sql_query&quot;<br>    [&quot;args&quot;]=&gt;<br>    array(1) {<br>      [0]=&gt;<br>      string(519) &quot;CREATE TABLE `idlink_fields` (<br>                        `corpus`       varchar(20)     CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `att_handle`   varchar(64)        CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `handle`       varchar(64)      CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `description`  varchar(255) CHARSET utf8 COLLATE utf8_general_ci default &#39;&#39;,<br>                        `datatype`     tinyint(2) NOT NULL default 0<br>                        primary key (`corpus`, `att_handle`, `handle`)<br>        ) ENGINE=InnoDB  <br>        /* from User: ??? | Function: ???() | 2019-May-29 01:35 */&quot;<br>    }<br>  }<br>  [4]=&gt;<br>  array(4) {<br>    [&quot;file&quot;]=&gt;<br>    string(38) &quot;/var/www/html/cqpweb/bin/autosetup.php&quot;<br>    [&quot;line&quot;]=&gt;<br>    int(92)<br>    [&quot;function&quot;]=&gt;<br>    string(18) &quot;do_sql_total_reset&quot;<br>    [&quot;args&quot;]=&gt;<br>    array(0) {<br>    }<br>  }<br>}<br>PHP Fatal error:  Uncaught Error: Call to undefined method NotAFullConfig::disconnect_slave_program() in /var/www/html/cqpweb/lib/environment.php:1334<br>Stack trace:<br>#0 /var/www/html/cqpweb/lib/exiterror-lib.php(231): cqpweb_shutdown_environment()<br>#1 /var/www/html/cqpweb/lib/exiterror-lib.php(300): exiterror(Array, NULL, NULL)<br>#2 /var/www/html/cqpweb/lib/sql-lib.php(179): exiterror_mysqlquery(1064, &#39;You have an err...&#39;, &#39;CREATE TABLE `i...&#39;)<br>#3 /var/www/html/cqpweb/lib/sql-lib.php(1011): do_sql_query(&#39;CREATE TABLE `i...&#39;)<br>#4 /var/www/html/cqpweb/bin/autosetup.php(92): do_sql_total_reset()<br>#5 {main}<br>  thrown in /var/www/html/cqpweb/lib/environment.php on line 1334</font><br></div><div><br></div><div>Best,<br>Scott</div></div>