[CWB] CQPweb error on fresh install

[José Manuel Martínez Martínez]

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 &#169; 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 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%7Cfb0147306e18475a3b2008d7e865ec3e%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637233396769565074&sdata=IRYqzpJkRKCYacRxp3wnU5P2bOmRpKd%2FzgtcpOZ2iA8%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/20200424/bc2bd82f/attachment-0001.html>