[CWB] [CQPweb] Fresh install, database setup crashes
Scott Sadowsky
ssadowsky at gmail.com
Sat Jun 8 04:58:02 CEST 2019
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/20190607/55126a45/attachment.html>
More information about the CWB
mailing list