[CWB] [CQPweb] Fresh install, database setup crashes
Hardie, Andrew
a.hardie at lancaster.ac.uk
Mon Jun 10 06:38:00 CEST 2019
Sorry, I couldn’t find this in my present copies of the code…
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Scott Sadowsky
Sent: 08 June 2019 10:04
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: Re: [CWB] [CQPweb] Fresh install, database setup crashes
Thanks, Andrew!
There's one little thing left:
PHP Parse error: syntax error, unexpected ',' in /var/www/html/cqpweb/bin/upgrade-database.php on line 232
Best wishes,
Scott
On Sat, Jun 8, 2019 at 1:13 AM Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>> wrote:
Fixed. -- A
From: cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it> <cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it>> On Behalf Of Scott Sadowsky
Sent: 08 June 2019 03:58
To: Open source development of the Corpus WorkBench <CWB at liste.sslmit.unibo.it<mailto:CWB at liste.sslmit.unibo.it>>
Subject: [CWB] [CQPweb] Fresh install, database setup crashes
Hi Andrew,
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...
[REVISION 1218]
Now finalising setup for this installation of CQPweb....
Installing database structure; please wait.
An SQL query did not run successfully!
Original query:
CREATE TABLE `idlink_fields` (
`corpus` varchar(20) CHARSET ascii COLLATE ascii_bin NOT NULL,
`att_handle` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,
`handle` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,
`description` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',
`datatype` tinyint(2) NOT NULL default 0
primary key (`corpus`, `att_handle`, `handle`)
) ENGINE=InnoDB
/* from User: ??? | Function: ???() | 2019-Jun-07 23:24 */
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`)
) ENGINE=InnoDB
/* from User: ??? | Funct' at line 7
PHP debugging backtrace
=======================
array(4) {
[1]=>
array(4) {
["file"]=>
string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"
["line"]=>
int(300)
["function"]=>
string(9) "exiterror"
["args"]=>
array(3) {
[0]=>
array(3) {
[0]=>
string(38) "An SQL query did not run successfully!"
[1]=>
string(539) "Original query:
CREATE TABLE `idlink_fields` (
`corpus` varchar(20) CHARSET ascii COLLATE ascii_bin NOT NULL,
`att_handle` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,
`handle` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,
`description` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',
`datatype` tinyint(2) NOT NULL default 0
primary key (`corpus`, `att_handle`, `handle`)
) ENGINE=InnoDB
/* from User: ??? | Function: ???() | 2019-Jun-07 23:24 */
"
[2]=>
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`)
) ENGINE=InnoDB
/* from User: ??? | Funct' at line 7 "
}
[1]=>
NULL
[2]=>
NULL
}
}
[2]=>
array(4) {
["file"]=>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
["line"]=>
int(179)
["function"]=>
string(20) "exiterror_mysqlquery"
["args"]=>
array(3) {
[0]=>
int(1064)
[1]=>
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`)
) ENGINE=InnoDB
/* from User: ??? | Funct' at line 7"
[2]=>
string(519) "CREATE TABLE `idlink_fields` (
`corpus` varchar(20) CHARSET ascii COLLATE ascii_bin NOT NULL,
`att_handle` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,
`handle` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,
`description` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',
`datatype` tinyint(2) NOT NULL default 0
primary key (`corpus`, `att_handle`, `handle`)
) ENGINE=InnoDB
/* from User: ??? | Function: ???() | 2019-Jun-07 23:24 */"
}
}
[3]=>
array(4) {
["file"]=>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
["line"]=>
int(1011)
["function"]=>
string(12) "do_sql_query"
["args"]=>
array(1) {
[0]=>
string(519) "CREATE TABLE `idlink_fields` (
`corpus` varchar(20) CHARSET ascii COLLATE ascii_bin NOT NULL,
`att_handle` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,
`handle` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,
`description` varchar(255) CHARSET utf8 COLLATE utf8_general_ci default '',
`datatype` tinyint(2) NOT NULL default 0
primary key (`corpus`, `att_handle`, `handle`)
) ENGINE=InnoDB
/* from User: ??? | Function: ???() | 2019-Jun-07 23:24 */"
}
}
[4]=>
array(4) {
["file"]=>
string(38) "/var/www/html/cqpweb/bin/autosetup.php"
["line"]=>
int(92)
["function"]=>
string(18) "do_sql_total_reset"
["args"]=>
array(0) {
}
}
}
PHP Fatal error: Uncaught Error: Call to undefined method NotAFullConfig::disconnect_slave_program() in /var/www/html/cqpweb/lib/environment.php:1334
Stack trace:
#0 /var/www/html/cqpweb/lib/exiterror-lib.php(231): cqpweb_shutdown_environment()
#1 /var/www/html/cqpweb/lib/exiterror-lib.php(300): exiterror(Array, NULL, NULL)
#2 /var/www/html/cqpweb/lib/sql-lib.php(179): exiterror_mysqlquery(1064, 'You have an err...', 'CREATE TABLE `i...')
#3 /var/www/html/cqpweb/lib/sql-lib.php(1011): do_sql_query('CREATE TABLE `i...')
#4 /var/www/html/cqpweb/bin/autosetup.php(92): do_sql_total_reset()
#5 {main}
thrown in /var/www/html/cqpweb/lib/environment.php on line 1334
[REVISION 1237]
Now finalising setup for this installation of CQPweb....
Installing database structure; please wait.
An SQL query did not run successfully!
Original query:
CREATE TABLE `user_macros` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,
`macro_name` varchar(255) CHARSET ascii COLLATE ascii_bin NOT NULL
`macro_num_args` smallint unsigned default 0,
`macro_body` text CHARSET utf8 COLLATE utf8_bin,
key (`user`),
unique key (`user`, `macro_name`),
primary key (`id`)
) ENGINE=InnoDB
/* from User: ??? | Function: ???() | 2019-Jun-07 23:55 */
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,
`macro_body` ' at line 5
PHP debugging backtrace
=======================
array(4) {
[1]=>
array(4) {
["file"]=>
string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"
["line"]=>
int(300)
["function"]=>
string(9) "exiterror"
["args"]=>
array(3) {
[0]=>
array(3) {
[0]=>
string(38) "An SQL query did not run successfully!"
[1]=>
string(581) "Original query:
CREATE TABLE `user_macros` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,
`macro_name` varchar(255) CHARSET ascii COLLATE ascii_bin NOT NULL
`macro_num_args` smallint unsigned default 0,
`macro_body` text CHARSET utf8 COLLATE utf8_bin,
key (`user`),
unique key (`user`, `macro_name`),
primary key (`id`)
) ENGINE=InnoDB
/* from User: ??? | Function: ???() | 2019-Jun-07 23:55 */
"
[2]=>
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,
`macro_body` ' at line 5 "
}
[1]=>
NULL
[2]=>
NULL
}
}
[2]=>
array(4) {
["file"]=>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
["line"]=>
int(198)
["function"]=>
string(20) "exiterror_mysqlquery"
["args"]=>
array(3) {
[0]=>
int(1064)
[1]=>
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,
`macro_body` ' at line 5"
[2]=>
string(561) "CREATE TABLE `user_macros` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,
`macro_name` varchar(255) CHARSET ascii COLLATE ascii_bin NOT NULL
`macro_num_args` smallint unsigned default 0,
`macro_body` text CHARSET utf8 COLLATE utf8_bin,
key (`user`),
unique key (`user`, `macro_name`),
primary key (`id`)
) ENGINE=InnoDB
/* from User: ??? | Function: ???() | 2019-Jun-07 23:55 */"
}
}
[3]=>
array(4) {
["file"]=>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
["line"]=>
int(1035)
["function"]=>
string(12) "do_sql_query"
["args"]=>
array(1) {
[0]=>
string(561) "CREATE TABLE `user_macros` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user` varchar(64) CHARSET ascii COLLATE ascii_bin NOT NULL,
`macro_name` varchar(255) CHARSET ascii COLLATE ascii_bin NOT NULL
`macro_num_args` smallint unsigned default 0,
`macro_body` text CHARSET utf8 COLLATE utf8_bin,
key (`user`),
unique key (`user`, `macro_name`),
primary key (`id`)
) ENGINE=InnoDB
/* from User: ??? | Function: ???() | 2019-Jun-07 23:55 */"
}
}
[4]=>
array(4) {
["file"]=>
string(38) "/var/www/html/cqpweb/bin/autosetup.php"
["line"]=>
int(94)
["function"]=>
string(18) "do_sql_total_reset"
["args"]=>
array(0) {
}
}
}
PHP Fatal error: Uncaught Error: Call to undefined method NotAFullConfig::disconnect_slave_program() in /var/www/html/cqpweb/lib/environment.php:1333
Stack trace:
#0 /var/www/html/cqpweb/lib/exiterror-lib.php(231): cqpweb_shutdown_environment()
#1 /var/www/html/cqpweb/lib/exiterror-lib.php(300): exiterror(Array, NULL, NULL)
#2 /var/www/html/cqpweb/lib/sql-lib.php(198): exiterror_mysqlquery(1064, 'You have an err...', 'CREATE TABLE `u...')
#3 /var/www/html/cqpweb/lib/sql-lib.php(1035): do_sql_query('CREATE TABLE `u...')
#4 /var/www/html/cqpweb/bin/autosetup.php(94): do_sql_total_reset()
#5 {main}
thrown in /var/www/html/cqpweb/lib/environment.php on line 1333
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it<mailto:CWB at sslmit.unibo.it>
http://liste.sslmit.unibo.it/mailman/listinfo/cwb
--
Dr. Scott Sadowsky
Profesor Asistente de Lingüística
Pontificia Universidad Católica de Chile
ssadowsky gmail com
scsadowsky uc cl
http://sadowsky.cl/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190610/f1be9282/attachment-0001.html>
More information about the CWB
mailing list