<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>