[CWB] Another update -- CQPweb has branched!

[Luigi Talamo]

still a typo in sql-definitions.php

PHP Parse error:  syntax error, unexpected '1' (T_LNUMBER), expecting
')' in /var/www/html/CQPweb/lib/sql-definitions.php on line 145

when executing autosetup.php

On Thu, Jul 4, 2019 at 3:45 PM Hardie, Andrew <hardiea at lancaster.ac.uk> wrote:
>
> 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
> >
> >
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb