[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