[CWB] [CQPweb] Fresh install, database setup crashes
Scott Sadowsky
ssadowsky at gmail.com
Sat Jun 8 11:04:01 CEST 2019
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>
wrote:
> 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
>
>
> _______________________________________________
> CWB mailing list
> 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/20190608/4c7a4aa3/attachment-0001.html>
More information about the CWB
mailing list