[CWB] [CQPweb] Fresh install, database setup crashes
Hardie, Andrew
a.hardie at lancaster.ac.uk
Sat Jun 8 07:13:32 CEST 2019
Fixed. -- A
From: cwb-bounces at sslmit.unibo.it <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>
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190608/0f81cab0/attachment-0001.html>
More information about the CWB
mailing list