<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi, Andrew,</p>
<p>Thank you very much for the tips of enlarging SQL database
size. Here is attached the full message in the following.
Sorry for the confusion. I kept only part of the original message
because they are similar and I thought a snippet of it would be
suffice.<br>
</p>
<p>Best,</p>
<p>D.<br>
</p>
<table class="concordtable fullwidth">
<tbody>
<tr>
<td class="concorderror">
<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, dependency varchar(255) NOT
NULL, headindex varchar(255) NOT NULL, index varchar(255)
NOT NULL, lemma varchar(255) NOT NULL, morphology
varchar(255) NOT NULL, namedentity varchar(255) NOT NULL,
pos varchar(255) NOT NULL, possimple varchar(255) NOT
NULL, key (word), key (dependency), key (headindex), key
(index), key (lemma), key (morphology), key (namedentity),
key (pos), key (possimple) ) CHARACTER SET utf8 COLLATE
utf8_general_ci /* from User: user | Function:
corpus_make_freqtables() | 2019-Nov-07 12:51 */</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,
morphology varchar(255' at line 6</p>
</td>
</tr>
<tr>
<th class="concordtable">PHP debugging backtrace</th>
</tr>
<tr>
<td class="concorderror">
<pre>array(6) {
[1]=>
array(4) {
["file"]=>
string(42) "/var/www/html/CQPweb/lib/exiterror-lib.php"
["line"]=>
int(367)
["function"]=>
string(9) "exiterror"
["args"]=>
array(3) {
[0]=>
array(3) {
[0]=>
string(38) "An SQL query did not run successfully!"
[1]=>
string(702) "Original query:
CREATE TABLE __tempfreq_mencow (
freq int(11) unsigned default NULL,
word varchar(255) NOT NULL,
dependency varchar(255) NOT NULL,
headindex varchar(255) NOT NULL,
index varchar(255) NOT NULL,
lemma varchar(255) NOT NULL,
morphology varchar(255) NOT NULL,
namedentity varchar(255) NOT NULL,
pos varchar(255) NOT NULL,
possimple varchar(255) NOT NULL,
key (word),
key (dependency),
key (headindex),
key (index),
key (lemma),
key (morphology),
key (namedentity),
key (pos),
key (possimple)
) CHARACTER SET utf8 COLLATE utf8_general_ci
/* from User: user | Function: corpus_make_freqtables() | 2019-Nov-07 12:51 */
"
[2]=>
string(241) "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,
morphology varchar(255' at line 6 "
}
[1]=>
NULL
[2]=>
NULL
}
}
[2]=>
array(4) {
["file"]=>
string(36) "/var/www/html/CQPweb/lib/sql-lib.php"
["line"]=>
int(213)
["function"]=>
string(18) "exiterror_sqlquery"
["args"]=>
array(3) {
[0]=>
int(1064)
[1]=>
string(226) "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,
morphology varchar(255' at line 6"
[2]=>
string(682) "CREATE TABLE __tempfreq_mencow (
freq int(11) unsigned default NULL,
word varchar(255) NOT NULL,
dependency varchar(255) NOT NULL,
headindex varchar(255) NOT NULL,
index varchar(255) NOT NULL,
lemma varchar(255) NOT NULL,
morphology varchar(255) NOT NULL,
namedentity varchar(255) NOT NULL,
pos varchar(255) NOT NULL,
possimple varchar(255) NOT NULL,
key (word),
key (dependency),
key (headindex),
key (index),
key (lemma),
key (morphology),
key (namedentity),
key (pos),
key (possimple)
) CHARACTER SET utf8 COLLATE utf8_general_ci
/* from User: user | Function: corpus_make_freqtables() | 2019-Nov-07 12:51 */"
}
}
[3]=>
array(4) {
["file"]=>
string(42) "/var/www/html/CQPweb/lib/freqtable-lib.php"
["line"]=>
int(93)
["function"]=>
string(12) "do_sql_query"
["args"]=>
array(1) {
[0]=>
string(682) "CREATE TABLE __tempfreq_mencow (
freq int(11) unsigned default NULL,
word varchar(255) NOT NULL,
dependency varchar(255) NOT NULL,
headindex varchar(255) NOT NULL,
index varchar(255) NOT NULL,
lemma varchar(255) NOT NULL,
morphology varchar(255) NOT NULL,
namedentity varchar(255) NOT NULL,
pos varchar(255) NOT NULL,
possimple varchar(255) NOT NULL,
key (word),
key (dependency),
key (headindex),
key (index),
key (lemma),
key (morphology),
key (namedentity),
key (pos),
key (possimple)
) CHARACTER SET utf8 COLLATE utf8_general_ci
/* from User: user | Function: corpus_make_freqtables() | 2019-Nov-07 12:51 */"
}
}
[4]=>
array(4) {
["file"]=>
string(39) "/var/www/html/CQPweb/lib/corpus-lib.php"
["line"]=>
int(1005)
["function"]=>
string(22) "corpus_make_freqtables"
["args"]=>
array(1) {
[0]=>
string(6) "mencow"
}
}
[5]=>
array(4) {
["file"]=>
string(41) "/var/www/html/CQPweb/lib/metadata-act.php"
["line"]=>
int(193)
["function"]=>
string(30) "setup_all_corpus_freqlist_data"
["args"]=>
array(1) {
[0]=>
string(6) "mencow"
}
}
[6]=>
array(4) {
["file"]=>
string(41) "/var/www/html/CQPweb/exe/metadata-act.php"
["line"]=>
int(1)
["args"]=>
array(1) {
[0]=>
string(41) "/var/www/html/CQPweb/lib/metadata-act.php"
}
["function"]=>
string(7) "require"
}
}
</pre>
</td>
</tr>
</tbody>
</table>
<p><br>
</p>
</body>
</html>