<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Verdana",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Fixed. -- A<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> cwb-bounces@sslmit.unibo.it <cwb-bounces@sslmit.unibo.it>
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 08 June 2019 03:58<br>
<b>To:</b> Open source development of the Corpus WorkBench <CWB@liste.sslmit.unibo.it><br>
<b>Subject:</b> [CWB] [CQPweb] Fresh install, database setup crashes<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi Andrew,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">On a fresh install of CQPweb, I'm getting the following database error. I'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">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><b>[REVISION 1218]</b><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">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 '',<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 '(`corpus`, `att_handle`, `handle`)<br>
) ENGINE=InnoDB <br>
/* from User: ??? | Funct' at line 7<br>
<br>
<br>
PHP debugging backtrace<br>
=======================<br>
array(4) {<br>
[1]=><br>
array(4) {<br>
["file"]=><br>
string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"<br>
["line"]=><br>
int(300)<br>
["function"]=><br>
string(9) "exiterror"<br>
["args"]=><br>
array(3) {<br>
[0]=><br>
array(3) {<br>
[0]=><br>
string(38) "An SQL query did not run successfully!"<br>
[1]=><br>
string(539) "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 '',<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>
"<br>
[2]=><br>
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`)<br>
) ENGINE=InnoDB <br>
/* from User: ??? | Funct' at line 7 "<br>
}<br>
[1]=><br>
NULL<br>
[2]=><br>
NULL<br>
}<br>
}<br>
[2]=><br>
array(4) {<br>
["file"]=><br>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"<br>
["line"]=><br>
int(179)<br>
["function"]=><br>
string(20) "exiterror_mysqlquery"<br>
["args"]=><br>
array(3) {<br>
[0]=><br>
int(1064)<br>
[1]=><br>
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`)<br>
) ENGINE=InnoDB <br>
/* from User: ??? | Funct' at line 7"<br>
[2]=><br>
string(519) "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 '',<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>
}<br>
[3]=><br>
array(4) {<br>
["file"]=><br>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"<br>
["line"]=><br>
int(1011)<br>
["function"]=><br>
string(12) "do_sql_query"<br>
["args"]=><br>
array(1) {<br>
[0]=><br>
string(519) "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 '',<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>
}<br>
[4]=><br>
array(4) {<br>
["file"]=><br>
string(38) "/var/www/html/cqpweb/bin/autosetup.php"<br>
["line"]=><br>
int(92)<br>
["function"]=><br>
string(18) "do_sql_total_reset"<br>
["args"]=><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, 'You have an err...', 'CREATE TABLE `i...')<br>
#3 /var/www/html/cqpweb/lib/sql-lib.php(1011): do_sql_query('CREATE TABLE `i...')<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</span><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-family:"Courier New"">[REVISION 1237]</span></b><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">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 '`macro_num_args` smallint unsigned default 0,<br>
`macro_body` ' at line 5<br>
<br>
<br>
PHP debugging backtrace<br>
=======================<br>
array(4) {<br>
[1]=><br>
array(4) {<br>
["file"]=><br>
string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"<br>
["line"]=><br>
int(300)<br>
["function"]=><br>
string(9) "exiterror"<br>
["args"]=><br>
array(3) {<br>
[0]=><br>
array(3) {<br>
[0]=><br>
string(38) "An SQL query did not run successfully!"<br>
[1]=><br>
string(581) "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>
"<br>
[2]=><br>
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 '`macro_num_args` smallint unsigned default 0,<br>
`macro_body` ' at line 5 "<br>
}<br>
[1]=><br>
NULL<br>
[2]=><br>
NULL<br>
}<br>
}<br>
[2]=><br>
array(4) {<br>
["file"]=><br>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"<br>
["line"]=><br>
int(198)<br>
["function"]=><br>
string(20) "exiterror_mysqlquery"<br>
["args"]=><br>
array(3) {<br>
[0]=><br>
int(1064)<br>
[1]=><br>
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 '`macro_num_args` smallint unsigned default 0,<br>
`macro_body` ' at line 5"<br>
[2]=><br>
string(561) "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>
}<br>
[3]=><br>
array(4) {<br>
["file"]=><br>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"<br>
["line"]=><br>
int(1035)<br>
["function"]=><br>
string(12) "do_sql_query"<br>
["args"]=><br>
array(1) {<br>
[0]=><br>
string(561) "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>
}<br>
[4]=><br>
array(4) {<br>
["file"]=><br>
string(38) "/var/www/html/cqpweb/bin/autosetup.php"<br>
["line"]=><br>
int(94)<br>
["function"]=><br>
string(18) "do_sql_total_reset"<br>
["args"]=><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, 'You have an err...', 'CREATE TABLE `u...')<br>
#3 /var/www/html/cqpweb/lib/sql-lib.php(1035): do_sql_query('CREATE TABLE `u...')<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</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</body>
</html>