<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
Hi, I am writing on behalf of the Mexican Academy of Language and
because we are having issues between TLex and our MySQL server.
<div class="moz-forward-container">
<p>We are using TLex on Windows 7, version 14.1.0.3250 on
evaluation mode. Our MySQL server is v 8. The ODBC connection is
successful:</p>
<p><img moz-do-not-send="false"
src="cid:part1.P0DrkFJX.jtR3ieFK@academia.org.mx" alt=""
class="" width="160" height="133"></p>
<p>The ODBC driver is for 64 bit, so we used TLex 64 bit version.
Unfortunately, when we try to save any dictionary, with any
values in it (all empty fields, all full fields, with entries or
no entries, presaved locally or not) we always get the same
result. First, the system hangs for a couple seconds or even
minutes:</p>
<p><img moz-do-not-send="false"
src="cid:part2.7KbfjChG.VQhoxJAu@academia.org.mx" alt=""
class="" width="636" height="153"></p>
<p>Then the system throws and error:</p>
<p><img moz-do-not-send="false"
src="cid:part3.ELFETsLP.2XqnhMVy@academia.org.mx" alt=""
class="" width="352" height="185"></p>
<p>At this point I decide to check the logs. TLex error log only
saves this:</p>
<blockquote>
<p>LOAD ERROR REPORT:
"C:\Users\perro\Documents\TLex\ErrorReports\Load error report
(Lexicografia_tl_) (2023-01-14 03h23).txt"</p>
</blockquote>
<p>I activated the MySQL logs, and in any try, with any values in
it, it always throws the following:</p>
<blockquote>
<p>2023-01-16T19:33:41.216616Z 44 Connect <a
class="moz-txt-link-abbreviated moz-txt-link-freetext"
href="mailto:tlex@XXX.XXX.XXX.XX" moz-do-not-send="true">tlex@XXX.XXX.XXX.XX</a>
on lexicografia using SSL/TLS<br>
2023-01-16T19:33:41.395388Z 44 Query SET NAMES
utf8mb4 <br>
2023-01-16T19:33:41.573590Z 44 Query SET
character_set_results = NULL<br>
2023-01-16T19:33:41.757360Z 44 Query SET
SQL_AUTO_IS_NULL = 0<br>
2023-01-16T19:33:41.945809Z 44 Query SET
AUTOCOMMIT=0
<br>
2023-01-16T19:33:42.270723Z 38 Query set
@@sql_select_limit=DEFAULT
<br>
2023-01-16T19:33:42.460951Z 38 Query SELECT
TABLE_NAME,TABLE_COMMENT,IF(TABLE_TYPE='BASE TABLE', 'TABLE',
TABLE_TYPE),TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES WHERE
TABLE_SCHEMA=DATABASE() AND ( TABLE_TYPE='BASE TABLE' OR
TABLE_TYPE='VIEW' ) AND TABLE_NAME LIKE 'tl_document' ORDER BY
TABLE_SCHEMA,
TABLE_NAME <br>
2023-01-16T19:33:42.651017Z 38 Prepare INSERT INTO
tl_document
(node_id,name,description,createdby,copyright,url,schema_version,mediapath)
VALUES
(?,?,?,?,?,?,?,?)
<br>
2023-01-16T19:33:42.830815Z 38 Query SELECT
TABLE_NAME,TABLE_COMMENT,IF(TABLE_TYPE='BASE TABLE', 'TABLE',
TABLE_TYPE),TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES WHERE
TABLE_SCHEMA=DATABASE() AND ( TABLE_TYPE='BASE TABLE' OR
TABLE_TYPE='VIEW' ) AND TABLE_NAME LIKE 'tl_document' ORDER BY
TABLE_SCHEMA,
TABLE_NAME
<br>
2023-01-16T19:33:43.016648Z 38 Query SELECT
node_id,name,description,createdby,copyright,url,schema_version,mediapath
FROM tl_document<br>
2023-01-16T19:33:43.200718Z 38 Query CREATE TABLE
tl_blocks (sortorder integer,guid varchar(1000),number
integer,name varchar(1000),size integer,data
varchar(1000)) <br>
2023-01-16T19:33:43.549805Z 38 Query
ROLLBACK <br>
2023-01-16T19:33:45.730791Z 38 Query UPDATE
tl_users SET loggedin = '0' WHERE user_id =
'1' <br>
2023-01-16T19:33:45.920780Z 38 Query SELECT
Now() <br>
2023-01-16T19:33:46.092584Z 38 Query
COMMIT <br>
2023-01-16T19:33:46.257757Z 38 Query
COMMIT <br>
2023-01-16T19:33:46.450663Z 38 Close stmt<br>
</p>
</blockquote>
<p>Finally, the tl_document table shows this:</p>
<blockquote>
<p>mysql> select * from tl_document;<br>
+---------+------+-------------+-----------+-----------+------+--------------------+-----------+<br>
| node_id | name | description | createdby | copyright | url
| schema_version | mediapath |<br>
+---------+------+-------------+-----------+-----------+------+--------------------+-----------+<br>
| 1 | Test | | | |
| 3.0999999046325684 | |<br>
+---------+------+-------------+-----------+-----------+------+--------------------+-----------+<br>
</p>
</blockquote>
<p>So at this point we don't know what we are doing wrong. So we
would appreciate some hints on how we can make TLex MySQL
connection work and, therefore, evaluate if we can use TLex for
our needs.</p>
<p>Thanks,<br>
Ram<br>
</p>
<p><br>
</p>
<br>
</div>
</body>
</html>