[CWB] SQL Syntax error when installing new corpus

[D. Yuan]

Dear All,

I encounter the following SQL syntax error when I was trying to install 
a new corpus:

my MySQL version is

+-----------------+
| @@version       |
+-----------------+
| 8.0.17-0ubuntu2 |
+-----------------+

___________________

An SQL query did not run successfully!

Original query: CREATE TABLE __tempfreq_mencow ( freq int(11) unsigned 
default NULL, word varchar(255) NOT NULL,  lemma varchar(255) NOT 
NULL,namedentity varchar(255) NOT NULL, pos varchar(255) NOT NULL, 
possimple varchar(255) NOT NULL, key (word), key (lemma), key (pos), key 
(possimple) ) CHARACTER SET utf8 COLLATE utf8_general_ci /* from User: 
cqpwebadmin_wxy | Function: corpus_make_freqtables() | 2019-Nov-05 12:48 */

Error # 1064: You have an error in your SQL syntax; check the manual 
that corresponds to your MySQL server version for the right syntax to 
use near 'varchar(255) NOT NULL, lemma varchar(255) NOT NULL at line 6

___________________

Thank you very much for your help in advance.

Best,

D.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20191105/6c89338f/attachment.html>