[CWB] [External] Re: CQPweb error on fresh install
Hardie, Andrew
a.hardie at lancaster.ac.uk
Mon Apr 27 10:33:59 CEST 2020
Thanks for the report, will be fixed in the next commit.
Andrew.
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of José Manuel Martínez Martínez
Sent: 27 April 2020 07:42
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: Re: [CWB] [External] Re: CQPweb error on fresh install
Thanks to you, Andrew, for the quick response.
I fixed this error as instructed.
I'm getting more errors now.
Next was in line 407, sql-definitions, a comma was missing, I think.
autosetup.php is now complaining about Key column corpus doesn't exist in table.
sudo php autosetup.php
Now finalising setup for this installation of CQPweb....
Installing database structure; please wait.
<tr><td class="layout-contrast">
<p class="errormessage">An SQL query did not run successfully!</p>
<p class="errormessage">Original query:
CREATE TABLE `saved_subcorpora` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`corpus_id` int unsigned NOT NULL,
`user_id` int unsigned NOT NULL,
`savename` varchar(255) CHARSET utf8mb4 collate utf8mb4_0900_ai_ci default '',
`date_of_user_save` timestamp NOT NULL default CURRENT_TIMESTAMP,
`content` mediumtext CHARSET utf8mb4 collate utf8mb4_0900_bin,
`n_items` int unsigned NOT NULL default 0,
`n_tokens` bigint unsigned NOT NULL default 0,
key (`corpus`, `user`), ## TODO, name it!
primary key (`id`)
) ENGINE=InnoDB
/* from User: ??? | In file: /var/www/html/cqpweb/bin/autosetup.php @ line 103 | 2020-Apr-27 06:38 */</p>
<p class="errormessage">Error # 1072: Key column 'corpus' doesn't exist in table</p>
</td></tr>
</table>
PHP Notice: Undefined property: NotAFullUser::$logged_in in /var/www/html/cqpweb/lib/html-lib.php on line 817
<footer>
<hr>
<table class="layout-frame fullwidth">
<tr>
<td class="footbox algL" width="33%">
CQPweb v3.3.6 © 2008-2020
</td>
<td class="footbox algC" width="33%">
<a class="copynote" href="help.php?ui=hello" target="cqpweb_help_browser">Help! on CQPweb</a>
</td>
<td class="footbox algR" width="33%">
You are not logged in
</td>
</tr>
</table>
</footer>
<div id="templateForToolTip" class="floatingToolTip">
<table class="floatingToolTipFrame">
<tr>
<td class="floatingToolTipTarget"></td>
</tr>
</table>
</div>
</body>
</html>
--
José Manuel Martínez Martínez
https://chozelinek.github.io<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fchozelinek.github.io%2F&data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7Cb2c9a2177c8643f5695908d7ea7628e0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637235665541028627&sdata=9jN1WGlZ94Pmz9LCGgFPBkkCRmhWxFStaTDHEJs26AY%3D&reserved=0>
On Fri, Apr 24, 2020 at 8:24 PM Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>> wrote:
Error is here:
unique key (`corpus`, `handle`), ## TODO, name it!
line 119 in lib/sql-definitions.php
the 2nd comma shouldn’t be there (probably a leftover from deleting a line without removing the previous comma)
Fix will also be in next commit. thanks for trying these things out.
best
Andrew.
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 José Manuel Martínez Martínez
Sent: 24 April 2020 17:11
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it<mailto:cwb at sslmit.unibo.it>>
Subject: [External] Re: [CWB] CQPweb error on fresh install
This email originated outside the University. Check before clicking links or attachments.
Hi Andrew,
thanks for the quick reply! I removed the line and run it again. This time I'm getting a new error:
sudo php autosetup.php
Now finalising setup for this installation of CQPweb....
Installing database structure; please wait.
<tr><td class="layout-contrast">
<p class="errormessage">An SQL query did not run successfully!</p>
<p class="errormessage">Original query:
CREATE TABLE `annotation_info` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`corpus` varchar(20) CHARSET ascii COLLATE ascii_bin NOT NULL,
`order_of_att` smallint unsigned NOT NULL default 0,
`handle` varchar(20) CHARSET ascii COLLATE ascii_bin NOT NULL,
`description` varchar(255) CHARSET utf8mb4 collate utf8mb4_0900_ai_ci default '',
`ft_required` tinyint(1) NOT NULL default 1,
`accent_sensitive` tinyint(1) NOT NULL default 1,
`case_sensitive` tinyint(1) NOT NULL default 1,
`is_feature_set` tinyint(1) NOT NULL default 0,
`tagset` varchar(255) CHARSET utf8mb4 collate utf8mb4_0900_ai_ci default '',
`external_url` varchar(255) CHARSET utf8mb4 collate utf8mb4_0900_ai_ci default '',
primary key (`id`),
unique key (`corpus`, `handle`), ## TODO, name it!
) ENGINE=InnoDB
/* from User: ??? | In file: /var/www/html/cqpweb/bin/autosetup.php @ line 103 | 2020-Apr-24 16:07 */</p>
<p class="errormessage">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 ') ENGINE=InnoDB
/* from User: ??? | In file: /var/www/html/cqpweb/bin/autoset' at line 15</p>
</td></tr>
</table>
PHP Notice: Undefined property: NotAFullUser::$logged_in in /var/www/html/cqpweb/lib/html-lib.php on line 817
<footer>
<hr>
<table class="layout-frame fullwidth">
<tr>
<td class="footbox algL" width="33%">
CQPweb v3.3.6 © 2008-2020
</td>
<td class="footbox algC" width="33%">
<a class="copynote" href="help.php?ui=hello" target="cqpweb_help_browser">Help! on CQPweb</a>
</td>
<td class="footbox algR" width="33%">
You are not logged in
</td>
</tr>
</table>
</footer>
<div id="templateForToolTip" class="floatingToolTip">
<table class="floatingToolTipFrame">
<tr>
<td class="floatingToolTipTarget"></td>
</tr>
</table>
</div>
</body>
</html>
--
José Manuel Martínez Martínez
https://chozelinek.github.io<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fchozelinek.github.io%2F&data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7Cb2c9a2177c8643f5695908d7ea7628e0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637235665541028627&sdata=9jN1WGlZ94Pmz9LCGgFPBkkCRmhWxFStaTDHEJs26AY%3D&reserved=0>
On Fri, Apr 24, 2020 at 5:53 PM Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>> wrote:
Hi José,
Quick solution: delete that line!
Alternatively fix will be in my next commit.
best
Andrew.
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 José Manuel Martínez Martínez
Sent: 24 April 2020 16:41
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it<mailto:cwb at sslmit.unibo.it>>
Subject: [CWB] CQPweb error on fresh install
Hi there,
I'm installing the trunk version of CQPweb on an Ubuntu 20.04.
I'm getting an error message when running
sudo php autosetup.php
The error message is:
PHP Warning: require(../lib/admin-lib.php): failed to open stream: No such file or directory in /var/www/html/cqpweb/bin/autosetup.php on line 36
PHP Fatal error: require(): Failed opening required '../lib/admin-lib.php' (include_path='.:/usr/share/php') in /var/www/html/cqpweb/bin/autosetup.php on line 36
I've seen that the file does not exist in the ../lib folder.
Cheers,
--
José Manuel Martínez Martínez
https://chozelinek.github.io<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fchozelinek.github.io%2F&data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7Cb2c9a2177c8643f5695908d7ea7628e0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637235665541038626&sdata=ytAHZr%2BfMsmPtlCQX%2FeIE831bG3l12nWfYETaItFa4Q%3D&reserved=0>
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it<mailto:CWB at sslmit.unibo.it>
http://liste.sslmit.unibo.it/mailman/listinfo/cwb<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7Cb2c9a2177c8643f5695908d7ea7628e0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637235665541038626&sdata=DYTh8nNXWgcISUkYPiXS%2Fw04iYrPs6yE%2F9dYkRXfbYw%3D&reserved=0>
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it<mailto:CWB at sslmit.unibo.it>
http://liste.sslmit.unibo.it/mailman/listinfo/cwb<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7Cb2c9a2177c8643f5695908d7ea7628e0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637235665541048614&sdata=r51WHJE%2B2W1u7BOOmrB%2BohZEHD7gEWHKmOHFHccev84%3D&reserved=0>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20200427/6784b1c6/attachment-0001.html>
More information about the CWB
mailing list