<div dir="ltr">Hi Andrew,<div><br></div><div>On a fresh install of CQPweb, I&#39;m getting the following database error. I&#39;ve tried with revisions from 1210 on up, and and the most recent one that installs is 1217. 1218 and later exhibit this behavior. The relevant info is below...<br clear="all"><div><br></div><div><b>[REVISION 1218]</b></div><div><font face="courier new, monospace">Now finalising setup for this installation of CQPweb....<br><br><br>Installing database structure; please wait.<br><br>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-Jun-07 23:24 */<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-Jun-07 23:24 */<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-Jun-07 23:24 */&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-Jun-07 23:24 */&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><div><font face="courier new, monospace"><br></font></div><div><font face="courier new, monospace"><br></font></div><div><font face="courier new, monospace"><b>[REVISION 1237]</b></font></div><div><font face="courier new, monospace">Now finalising setup for this installation of CQPweb....<br><br><br>Installing database structure; please wait.<br><br>An SQL query did not run successfully!<br>Original query: <br><br>CREATE TABLE `user_macros` (<br>                        `id`                         int unsigned NOT NULL AUTO_INCREMENT,<br>                        `user`                       varchar(64)   CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `macro_name`                 varchar(255)    CHARSET ascii COLLATE ascii_bin NOT NULL<br>                        `macro_num_args`             smallint unsigned default 0,<br>                        `macro_body`                 text CHARSET utf8 COLLATE utf8_bin,<br>                        key (`user`), <br>                        unique key (`user`, `macro_name`),<br>                        primary key (`id`)<br>                ) ENGINE=InnoDB <br>        /* from User: ??? | Function: ???() | 2019-Jun-07 23:55 */<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;`macro_num_args`             smallint unsigned default 0,<br>                        `macro_body`       &#39; at line 5<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(581) &quot;Original query: <br><br>CREATE TABLE `user_macros` (<br>                        `id`                         int unsigned NOT NULL AUTO_INCREMENT,<br>                        `user`                       varchar(64)   CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `macro_name`                 varchar(255)    CHARSET ascii COLLATE ascii_bin NOT NULL<br>                        `macro_num_args`             smallint unsigned default 0,<br>                        `macro_body`                 text CHARSET utf8 COLLATE utf8_bin,<br>                        key (`user`), <br>                        unique key (`user`, `macro_name`),<br>                        primary key (`id`)<br>                ) ENGINE=InnoDB <br>        /* from User: ??? | Function: ???() | 2019-Jun-07 23:55 */<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;`macro_num_args`             smallint unsigned default 0,<br>                        `macro_body`       &#39; at line 5 &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(198)<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;`macro_num_args`             smallint unsigned default 0,<br>                        `macro_body`       &#39; at line 5&quot;<br>      [2]=&gt;<br>      string(561) &quot;CREATE TABLE `user_macros` (<br>                        `id`                         int unsigned NOT NULL AUTO_INCREMENT,<br>                        `user`                       varchar(64)   CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `macro_name`                 varchar(255)    CHARSET ascii COLLATE ascii_bin NOT NULL<br>                        `macro_num_args`             smallint unsigned default 0,<br>                        `macro_body`                 text CHARSET utf8 COLLATE utf8_bin,<br>                        key (`user`), <br>                        unique key (`user`, `macro_name`),<br>                        primary key (`id`)<br>                ) ENGINE=InnoDB <br>        /* from User: ??? | Function: ???() | 2019-Jun-07 23:55 */&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(1035)<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(561) &quot;CREATE TABLE `user_macros` (<br>                        `id`                         int unsigned NOT NULL AUTO_INCREMENT,<br>                        `user`                       varchar(64)   CHARSET ascii COLLATE ascii_bin NOT NULL,<br>                        `macro_name`                 varchar(255)    CHARSET ascii COLLATE ascii_bin NOT NULL<br>                        `macro_num_args`             smallint unsigned default 0,<br>                        `macro_body`                 text CHARSET utf8 COLLATE utf8_bin,<br>                        key (`user`), <br>                        unique key (`user`, `macro_name`),<br>                        primary key (`id`)<br>                ) ENGINE=InnoDB <br>        /* from User: ??? | Function: ???() | 2019-Jun-07 23:55 */&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(94)<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:1333<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(198): exiterror_mysqlquery(1064, &#39;You have an err...&#39;, &#39;CREATE TABLE `u...&#39;)<br>#3 /var/www/html/cqpweb/lib/sql-lib.php(1035): do_sql_query(&#39;CREATE TABLE `u...&#39;)<br>#4 /var/www/html/cqpweb/bin/autosetup.php(94): do_sql_total_reset()<br>#5 {main}<br>  thrown in /var/www/html/cqpweb/lib/environment.php on line 1333</font><br></div><div><font face="courier new, monospace"><br></font></div></div>