[CWB] Another update -- CQPweb has branched!

Hardie, Andrew hardiea at lancaster.ac.uk
Thu Jul 4 15:45:05 CEST 2019


Thanks for the report - bugfixed.

Andrew.

========================================

On Thu, 4 Jul 2019, Luigi Talamo wrote:

> Hi Andrew.
> Done, but autosetup.php gave the following error:
> 
> create table query_history (
> 
> `id`                         bigint unsigned NOT NULL AUTO_INCREMENT,
> 
> `user`                       varchar(64)   CHARSET ascii COLLATE ascii_bin default NULL,
> 
> `corpus`                     varchar(20)     CHARSET ascii COLLATE ascii_bin default NULL,
> 
> `cqp_query`                  text CHARSET utf8 COLLATE utf8_bin NOT NULL,
> 
> `query_scope`                text CHARSET utf8 COLLATE utf8_bin,
> 
> `date_of_query`              timestamp NOT NULL default CURRENT_TIMESTAMP,
> 
> `hits`                       int(11) default NULL, ### TODO bigint?? could be made unsigned if there was an enum for -1, -3 (EG called `outcome`)
> 
> `simple_query`               text CHARSET utf8 COLLATE utf8_bin,
> 
> `query_mode`                 ,
> 
> key (`user`,`corpus`),
> 
> key (`cqp_query`(255)),
> 
> primary key (`id`)
> 
> ) ENGINE=InnoDB 
> 
> /* from User: ??? | In file:  @ line  | 2019-Jul-04 12:33 */
> 
> 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 '
> 
> key (`user`,`corpus`),
> 
> key (`cqp_query`(255)),
> 
> primary key (`id`)
> 
> ) ' at line 10
> 
> 
> Thank you.Best,
> Luigi
> 
> On Thu, Jul 4, 2019 at 11:41 AM Hardie, Andrew <a.hardie at lancaster.ac.uk> wrote:
> >
> > Hi all,
> >
>> >
> > I have branched off the 3.2.39+ line of CQPweb. Those of you who are running servers that follow the SVN dev version will probably want to flip over to the branch until further
> notice, as the trunk will be broken, starting today.
> >
>> >
> > (SVN Command for this below.)
> >
>> >
> > The 3.2 branch will continue to receive bug fixes indefinitely, and minor function updates until the trunk diverges enough to make doing so a pain. When it reaches a steady state,
> hopefully in no more than a month, I’ll export it as a new tarball and create a new CQPwebInABox image.
> >
>> >
> > The trunk will go to version 3.2.999, just to keep everything numerical. Once I am reasonably happy that it is safe for people to switch live servers back to the trunk, I’ll announce
> it to the list and the version number will become 3.3.0.
> >
>> >
> > The major change will be to enable full coverage of UTF-8 – as more and more people want to index texts that may contain emojis, using the stunted mysql 3-byte legacy version of UTF-8
> is increasingly a showstopper.
> >
>> >
> > After 3.3.0 arrives, I hope to take some time away from CQPweb dev work to focus on improving the manual, recording more tutorial videos, and possibly even some work on Ziggurat.
> >
>> >
> > best
> >
>> >
> > Andrew.
> >
>> >
> > ===================
> >
>> >
> > To switch from the trunk to the 3.2 branch, cd to the root of your checkout, and run:
> >
>> >
> > svn switch https://svn.code.sf.net/p/cwb/code/gui/cqpweb/branches/3.2-latest .
> >
>> >
> > … note final dot.
> >
> > _______________________________________________
> > CWB mailing list
> > CWB at sslmit.unibo.it
> > http://liste.sslmit.unibo.it/mailman/listinfo/cwb
> 
>


More information about the CWB mailing list