<div dir="auto">Thanks as always, Andrew!</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, May 29, 2019, 19:06 Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-GB" link="blue" vlink="purple">
<div class="m_-3577639246608979637WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1f497d">Thanks, will be fixed in next commit - A<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> <a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank" rel="noreferrer">cwb-bounces@sslmit.unibo.it</a> <<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank" rel="noreferrer">cwb-bounces@sslmit.unibo.it</a>>
<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 <<a href="mailto:CWB@liste.sslmit.unibo.it" target="_blank" rel="noreferrer">CWB@liste.sslmit.unibo.it</a>><br>
<b>Subject:</b> [CWB] [CQPweb] MySQL error when installing (revision 1219)<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Hi Andrew,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I'm getting the following error when trying to install revision 1219 of CQPweb:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></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><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Best,<br>
Scott<u></u><u></u></p>
</div>
</div>
</div>
</div>
_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank" rel="noreferrer">CWB@sslmit.unibo.it</a><br>
<a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" rel="noreferrer noreferrer" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><br>
</blockquote></div>