[CWB] Another update -- CQPweb has branched!

[Luigi Talamo]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190704/7fd99a3d/attachment.html>