Hi Andrew.<br>
Done, but autosetup.php gave the following error:<br>
<br>
create table query_history (<br>
<br>
`id` bigint unsigned NOT NULL AUTO_INCREMENT,<br>
<br>
`user` varchar(64) CHARSET ascii COLLATE ascii_bin default NULL,<br>
<br>
`corpus` varchar(20) CHARSET ascii COLLATE ascii_bin default NULL,<br>
<br>
`cqp_query` text CHARSET utf8 COLLATE utf8_bin NOT NULL,<br>
<br>
`query_scope` text CHARSET utf8 COLLATE utf8_bin,<br>
<br>
`date_of_query` timestamp NOT NULL default CURRENT_TIMESTAMP,<br>
<br>
`hits` int(11) default NULL, ### TODO bigint?? could be made unsigned if there was an enum for -1, -3 (EG called `outcome`)<br>
<br>
`simple_query` text CHARSET utf8 COLLATE utf8_bin,<br>
<br>
`query_mode` ,<br>
<br>
key (`user`,`corpus`),<br>
<br>
key (`cqp_query`(255)),<br>
<br>
primary key (`id`)<br>
<br>
) ENGINE=InnoDB <br>
<br>
/* from User: ??? | In file: @ line | 2019-Jul-04 12:33 */<br>
<br>
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 '<br>
<br>
key (`user`,`corpus`),<br>
<br>
key (`cqp_query`(255)),<br>
<br>
primary key (`id`)<br>
<br>
) ' at line 10<br>
<br>
<br>
Thank you.<div>Best,</div><div>Luigi<br>
<br>
On Thu, Jul 4, 2019 at 11:41 AM Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>> wrote:<br>
><br>
> Hi all,<br>
><br>
> <br>
><br>
> 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.<br>
><br>
> <br>
><br>
> (SVN Command for this below.)<br>
><br>
> <br>
><br>
> 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.<br>
><br>
> <br>
><br>
> 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.<br>
><br>
> <br>
><br>
> 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.<br>
><br>
> <br>
><br>
> 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.<br>
><br>
> <br>
><br>
> best<br>
><br>
> <br>
><br>
> Andrew.<br>
><br>
> <br>
><br>
> ===================<br>
><br>
> <br>
><br>
> To switch from the trunk to the 3.2 branch, cd to the root of your checkout, and run:<br>
><br>
> <br>
><br>
> svn switch <a href="https://svn.code.sf.net/p/cwb/code/gui/cqpweb/branches/3.2-latest" target="_blank">https://svn.code.sf.net/p/cwb/<wbr>code/gui/cqpweb/branches/3.2-<wbr>latest</a> .<br>
><br>
> <br>
><br>
> … note final dot.<br>
><br>
> ______________________________<wbr>_________________<br>
> CWB mailing list<br>
> <a href="mailto:CWB@sslmit.unibo.it">CWB@sslmit.unibo.it</a><br>
> <a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" target="_blank">http://liste.sslmit.unibo.it/<wbr>mailman/listinfo/cwb</a><br>
</div>