<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:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
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;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.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="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Thanks, will be fixed in next commit - 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"><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> 29 May 2019 05:39<br>
<b>To:</b> Open source development of the Corpus WorkBench <CWB@liste.sslmit.unibo.it><br>
<b>Subject:</b> [CWB] [CQPweb] MySQL error when installing (revision 1219)<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">I'm getting the following error when trying to install revision 1219 of CQPweb:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">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-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 '(`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-May-29 01:35 */<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-May-29 01:35 */"<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-May-29 01:35 */"<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>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Best,<br>
Scott<o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>