[CWB] [CQPweb] MySQL error when installing (revision 1219)
Scott Sadowsky
ssadowsky at gmail.com
Thu May 30 01:21:31 CEST 2019
Thanks as always, Andrew!
On Wed, May 29, 2019, 19:06 Hardie, Andrew <a.hardie at lancaster.ac.uk> wrote:
> Thanks, will be fixed in next commit - A
>
>
>
> *From:* cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> *On
> Behalf Of *Scott Sadowsky
> *Sent:* 29 May 2019 05:39
> *To:* Open source development of the Corpus WorkBench <
> CWB at liste.sslmit.unibo.it>
> *Subject:* [CWB] [CQPweb] MySQL error when installing (revision 1219)
>
>
>
> Hi Andrew,
>
>
>
> I'm getting the following error when trying to install revision 1219 of
> CQPweb:
>
>
>
> 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-May-29 01:35 */
> 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-May-29 01:35 */
>
> "
> [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-May-29 01:35 */"
> }
> }
> [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-May-29 01:35 */"
> }
> }
> [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
>
>
>
> Best,
> Scott
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190529/80638b5c/attachment.html>
More information about the CWB
mailing list