[CWB] CWB Digest, Vol 168, Issue 4
mansur
6688000 at gmail.com
Mon Feb 15 13:49:19 CET 2021
Hi, Andrew!
Strange, I don't see a new commit in the trunk?
Did you upload it to the server?
With best regards,
Mansur
Am Mo., 15. Feb. 2021 um 13:24 Uhr schrieb <cwb-request at sslmit.unibo.it>:
> Send CWB mailing list submissions to
> cwb at sslmit.unibo.it
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
> or, via email, send a message with subject or body 'help' to
> cwb-request at sslmit.unibo.it
>
> You can reach the person managing the list at
> cwb-owner at sslmit.unibo.it
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of CWB digest..."
>
>
> Today's Topics:
>
> 1. Re: Error in cqpweb autosetup.php (Hardie, Andrew)
> 2. Re: CQPweb: php error (Hardie, Andrew)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 15 Feb 2021 11:18:24 +0000
> From: "Hardie, Andrew" <a.hardie at lancaster.ac.uk>
> To: Open source development of the Corpus WorkBench
> <cwb at sslmit.unibo.it>
> Subject: Re: [CWB] Error in cqpweb autosetup.php
> Message-ID:
> <
> CWLP265MB19242A3CBF62FA2FDB07DBB1CB889 at CWLP265MB1924.GBRP265.PROD.OUTLOOK.COM
> >
>
> Content-Type: text/plain; charset="utf-8"
>
> Hi Mansur,
>
> Thanks for the report. Fixed in trunk.
>
> best
>
> Andrew.
>
> From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf
> Of mansur
> Sent: 15 February 2021 10:39
> To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
> Subject: [CWB] Error in cqpweb autosetup.php
>
> Hi!
>
> I found a couple of problems in the most recent version of cqpweb.
> The file: cqpweb/lib/sql-definitions.php
>
> 1) The problem is somewhere near "TYPE_DT_DATE, TYPE_DT_TIME":
> CREATE TABLE `metadata_template_info` (
> `id` int unsigned NOT NULL
> AUTO_INCREMENT,
> `description` varchar(255) CHARSET
> utf8mb4 collate utf8mb4_unicode_520_nopad_ci default '',
> `primary_classification` varchar(64)
> CHARSET ascii COLLATE ascii_bin default NULL,
> primary key (`id`) TYPE_DT_DATE, TYPE_DT_TIME
> ) ENGINE=InnoDB
> /* from User: ??? | In file:
> /var/www/html/cqpweb/bin/autosetup.php @ line 104 | 2021-Feb-15 10:26 */</p>
> <p class="errormessage">Error # 1064: You have an error in your SQL
> syntax; check the manual that corresponds to your MariaDB server version
> for the right syntax to use near ' TYPE_DT_TIME
> ) ENGINE=InnoDB
>
>
> 2) In this case it seems one comma is missed:
> CREATE TABLE `saved_restrictions` (
> `id` bigint unsigned NOT
> NULL AUTO_INCREMENT,
> `corpus_id` int unsigned NOT NULL,
> `cache_time` int unsigned NOT NULL
> default 0,
> `serialised_restriction` text CHARSET utf8mb4
> collate utf8mb4_nopad_bin,
> `size_bytes` bigint unsigned NOT
> NULL default 0,
> `n_ids` int unsigned NOT NULL
> default 0,
> `n_items` int unsigned NOT NULL
> default 0,
> `n_tokens` bigint unsigned NOT
> NULL default 0,
> `data` longblob,
> key (`corpus_id`),
> key (`serialised_restriction`(191)),
> key (`cache_time`)
> primary key (`id`)
> ) ENGINE=InnoDB
> /* from User: ??? | In file:
> /var/www/html/cqpweb/bin/autosetup.php @ line 104 | 2021-Feb-15 10:32 */</p>
> <p class="errormessage">Error # 1064: You have an error in your SQL
> syntax; check the manual that corresponds to your MariaDB server version
> for the right syntax to use near 'primary key (`id`)
> ) ENGINE=InnoDB
>
>
> With best wishes,
> Mansur
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20210215/11e0dd4a/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 2
> Date: Mon, 15 Feb 2021 11:24:13 +0000
> From: "Hardie, Andrew" <a.hardie at lancaster.ac.uk>
> To: Open source development of the Corpus WorkBench
> <cwb at sslmit.unibo.it>
> Subject: Re: [CWB] CQPweb: php error
> Message-ID:
> <
> CWLP265MB1924D73CF9147EBD8D6B3542CB889 at CWLP265MB1924.GBRP265.PROD.OUTLOOK.COM
> >
>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi Simon,
>
> It sounds like your web server is not processing the PHP scripts are PHP
> but is instead serving them up as plain text. This is a web server
> configuration problem not a CQPweb problem I'm afraid.
>
> If you're on Apache, the issue may be that mod_php is not enabled. On
> other webservers, there will be similar things.
>
> best
>
> Andrew
>
> -----Original Message-----
> From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf
> Of Simon Meier-Vieracker
> Sent: 15 February 2021 07:33
> To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
> Subject: Re: [CWB] CQPweb: php error
>
>
> Some more information:
>
> PHP 8.0.2
> Server version: Apache/2.4.25 (Debian)
>
> I checked the required extensions in the Admin Manual and found that
> "Extension 'intl' not present."
>
> But I guess that the problem is more basic, since it does not execute the
> very simple command "<?php require('lib/mainhome.php');"
>
> Best, Simon
>
>
> > Am 14.02.2021 um 10:18 schrieb Simon Meier-Vieracker <
> simon.meier-vieracker at tu-dresden.de>:
> >
> > Hi,
> >
> > since today, I get the following error when I try to call CQPweb on my
> server
> https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fali.gsw.tu-dresden.de%2F&data=04%7C01%7Ca.hardie%40lancaster.ac.uk%7C5e469cc667d347fe67d608d8d184139b%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637489712530551010%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=rE%2FqcvUB59QzuZQ6oG1JCPZ2ckrcpWSI%2FKIlfvcJV4g%3D&reserved=0
> >
> >> <?php require('lib/mainhome.php');
> >
> > Same thing on other pages:
> >
> >> <?php require ('../lib/adminhome.php');
> >
> > The server is running, I can call pages outside of CQPweb (e.g.
> https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fali.gsw.tu-dresden.de%2Ftutorial.html&data=04%7C01%7Ca.hardie%40lancaster.ac.uk%7C5e469cc667d347fe67d608d8d184139b%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637489712530551010%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=ANxbnpA%2BJbvubdeRUbLMhMxlSSRkicEYpWDCbfTQU1A%3D&reserved=0
> )
> >
> > And within the lib folder, everything seems to be okay (see attached
> file) and mainhome.php looks good, too.
> >
> > Any suggestions what I can check in order to fix this?
> >
> > Best, Simon
> >
> > <lib.txt>
> >
> > _______________________________________________
> > CWB mailing list
> > CWB at sslmit.unibo.it
> >
> https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&data=04%7C01%7Ca.hardie%40lancaster.ac.uk%7C5e469cc667d347fe67d608d8d184139b%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637489712530551010%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=ICBmNvRtV4z26cKxZR%2FuvtFMimnqLPlZZSC3xQA9IK4%3D&reserved=0
>
>
>
>
> ------------------------------
>
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>
>
> End of CWB Digest, Vol 168, Issue 4
> ***********************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20210215/13fe77c6/attachment.html>
More information about the CWB
mailing list