[CWB] [External] Re: CQPweb error on fresh install
José Manuel Martínez Martínez
chozelinek at gmail.com
Mon Apr 27 08:41:50 CEST 2020
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
On Fri, Apr 24, 2020 at 8:24 PM Hardie, Andrew <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 <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
> >
> *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%7C78e47ae0c185414a820208d7e86a24e0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637233414901938290&sdata=HimgGxsBfvm1c%2BpthD49ixwsuOMnBUYtctbEv9C0nyI%3D&reserved=0>
>
>
>
>
>
> On Fri, Apr 24, 2020 at 5:53 PM Hardie, Andrew <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 <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
> >
> *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%7C78e47ae0c185414a820208d7e86a24e0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637233414901948285&sdata=toGHtn%2FxQoQcMfhcbPvH8mx9GJO%2FaJaq0g9%2BdHYVif0%3D&reserved=0>
>
> _______________________________________________
> CWB mailing list
> 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%7C78e47ae0c185414a820208d7e86a24e0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637233414901948285&sdata=wnG%2FeBGZL8xOrIXtQUBhcd2jUCeMMvU%2BMFBkjmz2ecs%3D&reserved=0>
>
> _______________________________________________
> 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/20200427/db59862f/attachment-0001.html>
More information about the CWB
mailing list