<div dir="ltr">Thanks, Andrew!<div><br></div><div>There's one little thing left:</div><div><br></div><div><font face="courier new, monospace">PHP Parse error: syntax error, unexpected ',' in /var/www/html/cqpweb/bin/upgrade-database.php on line 232</font><br></div><div><br></div><div>Best wishes,</div><div>Scott</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Jun 8, 2019 at 1:13 AM 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:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-GB">
<div class="gmail-m_-3829020672453233610WordSection1">
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Fixed. -- A<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><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">cwb-bounces@sslmit.unibo.it</a> <<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a>>
<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 <<a href="mailto:CWB@liste.sslmit.unibo.it" target="_blank">CWB@liste.sslmit.unibo.it</a>><br>
<b>Subject:</b> [CWB] [CQPweb] Fresh install, database setup crashes<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">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">
<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><b>[REVISION 1218]</b><u></u><u></u></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><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-family:"Courier New"">[REVISION 1237]</span></b><u></u><u></u></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><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a><br>
<a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" rel="noreferrer" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div style="font-size:12.7273px">Dr. Scott Sadowsky<br>Profesor Asistente de Lingüística</div><div dir="ltr" style="font-size:12.7273px">Pontificia Universidad Católica de Chile<br></div><div dir="ltr" style="font-size:12.7273px"><br></div><div dir="ltr" style="font-size:12.7273px">ssadowsky gmail com</div><div dir="ltr" style="font-size:12.7273px">scsadowsky uc cl<br><a href="http://sadowsky.cl/" target="_blank">http://sadowsky.cl/</a></div><div dir="ltr" style="font-size:12.7273px"> </div></div></div></div></div></div></div></div></div></div></div>