<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Dear All,</p>
<p>I encounter the following SQL syntax error when I was trying to
install a new corpus:</p>
<p>my MySQL version is <br>
</p>
<p>+-----------------+<br>
| @@version |<br>
+-----------------+<br>
| 8.0.17-0ubuntu2 |<br>
+-----------------+<br>
<br>
</p>
<p>___________________</p>
<p class="errormessage">An SQL query did not run successfully!</p>
<p class="errormessage">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 */</p>
<p class="errormessage">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<br>
</p>
<p>___________________</p>
<p>Thank you very much for your help in advance.</p>
<p>Best,</p>
<p>D.<br>
</p>
</body>
</html>