<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - subform bug"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139207">139207</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>subform bug
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>fbertoldi@tiscali.it
</td>
</tr></table>
<p>
<div>
<pre>Today, eventually, I managed to solve a critical problem with Mysql Direct
Connector, but even though now I can see tables and queries in my odb, I still
get an error message when I open a form with a subform.
This is the error message:
SQL Status: 42000
Error code: 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 ':link_from_ID_classe )
ORDER BY "ID_classe", "cognome"' at line 1
/build/libreoffice-muaG6z/libreoffice-7.0.4~rc2/connectivity/source/drivers/mysqlc/mysqlc_general.cxx:119
And the mysql syntax is this:
The SQL command leading to this error is:
SELECT "studenti"."ID" AS "ID", "studenti"."cognome" AS "cognome",
"studenti"."nome" AS "nome",
"studenti"."data_nascita" AS "data nascita", "studenti"."abitazione" AS
"abitazione", "studenti"."via" AS "via",
"studenti"."telefono" AS "telefono", "studenti"."origine" AS "origine",
"studenti"."ID_classe" AS "ID_classe",
"studenti"."dati_personali" AS "dati personali",
"studenti"."situazione_scolastica" AS "situazione scolastica",
"studenti"."voto_matu" AS "voto matu", "studenti"."significativita" AS
"significativita" FROM "miei"."studenti" "studenti"
WHERE ( "studenti"."ID_classe" = :link_from_ID_classe ) ORDER BY "ID_classe",
"cognome", "cognome" ASC
Therefore now I see, in my form, the main form (correctly), but the subform is
empty.
What should I do?
LO: Version: 7.0.4.2
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: kf5
Locale: it-IT (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.4~rc2-0ubuntu0.20.04.2
Calc: threaded</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>