Bug#933499: libreoffice-base: database form with subform no longer works with "Data content could not be loaded" error
I'm completely stumped. There must be SQL statement created to
accomplish the link for the subform.
I found error detail on the sql statement. Here is the statement for
one of the errors:
The SQL command leading to this error is:
SELECT * FROM "aquarium"."corrections" WHERE (
"aquarium"."corrections"."testID" = :link_from_ID )
The statement for the other database is:
The SQL command leading to this error is:
SELECT * FROM "running"."workout" WHERE ( "running"."workout"."ID" =
:link_from_workoutID )
For both of these statements the master field is the last portion of
the generated name "ID" for the first and "workoutID" for the second.
Now if that is how the
Now if I run one of those statements directly from the sql view of
query design, I'm asked to provide a parameter. If I provide a valid
value, I get the exact error message that we got before.
Now if I replace the variable name with the parameter I just gave in
the dialogue, I now get the result I expect. So the bug must have to do
with the link parameter not getting replaced with the appropriate
value.
Does this help?
On Thu, 2019-08-01 at 18:31 +0200, Rene Engelhard wrote:
> Hi again,
>
> On Thu, Aug 01, 2019 at 12:04:58AM +0200, Rene Engelhard wrote:
> > On Wed, Jul 31, 2019 at 04:00:04PM -0500, william l-k wrote:
> > >have linked sub-forms from two seperate tables for entering related
> > > data.
> > >One of the databases started out as a libreoffice base then was
> > > converted
> > >to a mariadb connection. The other started out as a connection to
> > > mariadb.
>
> Maybe it's not related at all but connection to mariadb how? MySQL ODBC?
> MySQL JDBC? (both of which are removed because being buggy), MariaDB
> JDBC? Or libreoffice-mysql-connector?
>
> If the latter, 5.2 removed the extension and need for libmysqlcppconn
> but integrated it properly into the "main" packages
> (libreoffice-sdbc-mysql), just using lib{mariadb,mysql}client/libmariadb
> properly.
>
> Maybe it's related to one of those?
>
> Regards,
>
> Rene
Bug#933499: libreoffice-base: database form with subform no longer works with "Data content could not be loaded" error
Both forms now no longer change properly when the record is changing on
the main form. Now, both databases display the first record in the
table for the subform for every record in the main table. I'll toy with
this to see why one direction is behaves badly and the other just
throws an error.
On Thu, 2019-08-01 at 18:31 +0200, Rene Engelhard wrote:
> Hi again,
>
> On Thu, Aug 01, 2019 at 12:04:58AM +0200, Rene Engelhard wrote:
> > On Wed, Jul 31, 2019 at 04:00:04PM -0500, william l-k wrote:
> > >have linked sub-forms from two seperate tables for entering related
> > > data.
> > >One of the databases started out as a libreoffice base then was
> > > converted
> > >to a mariadb connection. The other started out as a connection to
> > > mariadb.
>
> Maybe it's not related at all but connection to mariadb how? MySQL ODBC?
> MySQL JDBC? (both of which are removed because being buggy), MariaDB
> JDBC? Or libreoffice-mysql-connector?
>
> If the latter, 5.2 removed the extension and need for libmysqlcppconn
> but integrated it properly into the "main" packages
> (libreoffice-sdbc-mysql), just using lib{mariadb,mysql}client/libmariadb
> properly.
>
> Maybe it's related to one of those?
>
> Regards,
>
> Rene
Bug#933499: libreoffice-base: database form with subform no longer works with "Data content could not be loaded" error
The connection type is MYSQL(native). In the wayback I vaguely remember
using the JDBC connection type. I believe I switched the oldest to
MYSQL(native) to solve a problem with complex querys. The newest
database affected started with MYSQL(native).
Perhaps the clue is in the error states verbatum:
The data content could not be loaded. 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 )'.
Data is displayed for the parent table. It does not display for the
subform.
I just checked the form properties for the subform. The link fields had
the slave in the masters position and visa versa. I flipped the order
and tested the form, and voila, it works.
The wierd thing is, it had been working fine for years. If the order
had always been reversed
I checked the second table and got the exact same error message. Made
the identical changes on this form and ta da! Everything works.
Maybe everything working before was the bug? This is fixed for me, just
leaving me curious as to exactly which change led to the problem.
Thanks for your help.
On Thu, 2019-08-01 at 18:31 +0200, Rene Engelhard wrote:
> Hi again,
>
> On Thu, Aug 01, 2019 at 12:04:58AM +0200, Rene Engelhard wrote:
> > On Wed, Jul 31, 2019 at 04:00:04PM -0500, william l-k wrote:
> > >have linked sub-forms from two seperate tables for entering related
> > > data.
> > >One of the databases started out as a libreoffice base then was
> > > converted
> > >to a mariadb connection. The other started out as a connection to
> > > mariadb.
>
> Maybe it's not related at all but connection to mariadb how? MySQL ODBC?
> MySQL JDBC? (both of which are removed because being buggy), MariaDB
> JDBC? Or libreoffice-mysql-connector?
>
> If the latter, 5.2 removed the extension and need for libmysqlcppconn
> but integrated it properly into the "main" packages
> (libreoffice-sdbc-mysql), just using lib{mariadb,mysql}client/libmariadb
> properly.
>
> Maybe it's related to one of those?
>
> Regards,
>
> Rene
Bug#933499: libreoffice-base: database form with subform no longer works with "Data content could not be loaded" error
Hi Rene, upgrading some days ago from version 6.1.5-3 with libreoffice-mysql- connector to 6.3.0~rc2-1 with libreoffice-sdbc-mysql we find the bug in the old .odb files (created with libreoffice-mysql-connector and solved using https:// bugs.documentfoundation.org/show_bug.cgi?id=117053#c11). The new .odb files (created with libreoffice-sdbc-mysql) are not affected. Regards! Guido
Bug#933499: libreoffice-base: database form with subform no longer works with "Data content could not be loaded" error
Hi again,
On Thu, Aug 01, 2019 at 12:04:58AM +0200, Rene Engelhard wrote:
> On Wed, Jul 31, 2019 at 04:00:04PM -0500, william l-k wrote:
> >have linked sub-forms from two seperate tables for entering related data.
> >One of the databases started out as a libreoffice base then was converted
> >to a mariadb connection. The other started out as a connection to
> > mariadb.
Maybe it's not related at all but connection to mariadb how? MySQL ODBC?
MySQL JDBC? (both of which are removed because being buggy), MariaDB
JDBC? Or libreoffice-mysql-connector?
If the latter, 5.2 removed the extension and need for libmysqlcppconn
but integrated it properly into the "main" packages
(libreoffice-sdbc-mysql), just using lib{mariadb,mysql}client/libmariadb
properly.
Maybe it's related to one of those?
Regards,
Rene
Bug#933499: libreoffice-base: database form with subform no longer works with "Data content could not be loaded" error
Hi, we can confirm the bug with MariaDB that we solved using https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c11 ... Regards! Guido
Bug#933499: libreoffice-base: database form with subform no longer works with "Data content could not be loaded" error
[ please always keep the bug CCed so that the discussion gets recorded. ] On Wed, Jul 31, 2019 at 04:00:04PM -0500, william l-k wrote: >The database is mariadb. Two database entry forms are now affected. Both >have linked sub-forms from two seperate tables for entering related data. >One of the databases started out as a libreoffice base then was converted >to a mariadb connection. The other started out as a connection to mariadb. >I saw that bug before I submitted mine, but didn't see a solution. I'll >take a closer look to see. comments 11, 12 and 15 Regards, Rene
Bug#933499: libreoffice-base: database form with subform no longer works with "Data content could not be loaded" error
Hi, On Tue, Jul 30, 2019 at 03:20:20PM -0500, william l-k wrote: > The pop up says that there is a problem with my SQL statement for MariaDB > server version near ':link_from_ID)' at line one. But this isn't from a query > I MariaDB? This sounds like https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c15 (found by just googling) but if you say you use MariaDB... Or did you use the internal hsqldb once and it got converted to Firebird? Then the above big would apply and it has the solutions to fix it inside. > knowingly wrote. All of the reports relying on them still function fine. > Adding > data to the master form works, but the linked sub-form does not. If there is a > work around to try I'm all ears. See above? Maybe even if it is MariaDB removing that option works? Regards, Rene > > > > > > > -- System Information: > Debian Release: bullseye/sid > APT prefers testing > APT policy: (800, 'testing'), (700, 'unstable'), (600, 'experimental'), > (500, 'stable') > Architecture: amd64 (x86_64) > > Kernel: Linux 4.19.0-5-amd64 (SMP w/4 CPU cores) > Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8), > LANGUAGE=en_US.utf8 (charmap=UTF-8) > Shell: /bin/sh linked to /bin/dash > Init: systemd (via /run/systemd/system) > LSM: AppArmor: enabled > > Versions of packages libreoffice-base depends on: > ii libc6 2.28-10 > ii libgcc1 1:9.1.0-10 > ii libreoffice-base-core 1:6.3.0~rc2-1 > ii libreoffice-base-drivers 1:6.3.0~rc2-1 > ii libreoffice-core 1:6.3.0~rc2-1 > ii libstdc++69.1.0-10 > ii uno-libs3 6.3.0~rc2-1 > ii ure 6.3.0~rc2-1 > > Versions of packages libreoffice-base recommends: > ii default-jre [java6-runtime] 2:1.11-72 > ii libreoffice-java-common 1:6.3.0~rc2-1 > ii libreoffice-writer1:6.3.0~rc2-1 > ii openjdk-10-jre [java6-runtime]10.0.2+13-2 > ii openjdk-11-jre [java6-runtime]11.0.4+11-1 > ii openjdk-8-jre [java6-runtime] 8u222-b10-1 > ii openjdk-9-jre [java6-runtime] 9.0.4+12-4 > ii oracle-java8-jdk [java6-runtime] 8u65 > > Versions of packages libreoffice-base suggests: > ii libreoffice-report-builder 1:6.3.0~rc2-1 > pn unixodbc > > Versions of packages libreoffice-core depends on: > ii fontconfig 2.13.1-2 > ii fonts-opensymbol2:102.11+LibO6.3.0~rc2-1 > ii libboost-date-time1.67.01.67.0-13 > ii libboost-locale1.67.0 1.67.0-13 > ii libc6 2.28-10 > ii libcairo2 1.16.0-4 > ii libclucene-contribs1v5 2.3.3.4+dfsg-1 > ii libclucene-core1v5 2.3.3.4+dfsg-1 > ii libcmis-0.5-5v5 0.5.2-1 > ii libcups22.2.10-6 > ii libcurl3-gnutls 7.65.1-1 > ii libdbus-1-3 1.12.16-1 > ii libdconf1 0.30.1-2 > ii libeot0 0.01-5 > ii libepoxy0 1.5.3-0.1 > ii libexpat1 2.2.7-1 > ii libexttextcat-2.0-0 3.4.5-1 > ii libfontconfig1 2.13.1-2 > ii libfreetype62.9.1-4 > ii libgcc1 1:9.1.0-10 > ii libglib2.0-02.60.6-1 > ii libgpgmepp6 1.12.0-6 > ii libgraphite2-3 1.3.13-7 > ii libgstreamer-plugins-base1.0-0 1.16.0-2 > ii libgstreamer1.0-0 1.16.0-2 > ii libharfbuzz-icu02.5.3-1 > ii libharfbuzz0b 2.5.3-1 > ii libhunspell-1.7-0 1.7.0-2+b1 > ii libhyphen0 2.8.8-7 > ii libice6 2:1.0.9-2 > ii libicu6363.2-2 > ii libjpeg62-turbo 1:1.5.2-2+b1 > ii liblcms2-2 2.9-3 > ii libldap-2.4-2 2.4.48+dfsg-1 > ii libmythes-1.2-0 2:1.2.4-3+b1 > ii libneon27-gnutls0.30.2-3 > ii libnspr42:4.21-1 > ii libnss3 2:3.45-1 > ii libnumbertext-1.0-0 1.0.5-1 > ii libodfgen-0.1-1 0.1.7-1 > ii liborcus-0.14-0 0.14.1-6 > ii libpng16-16 1.6.37-1 > ii libpoppler820.71.0-5 > ii librdf0 1.0.17-1.1+b1 > ii libreoffice-common 1:6.3.0~rc2-1 > ii librevenge-0.0-00.0.4-6+b1 > ii libsm6 2:1.2.3-1 > ii libstdc++6 9.1.0-10 > ii libx11-62:1.6.7-1 > ii libxext62:1.3.3-1+b2 > ii libxinerama12:1.1.4-2 > ii libxml2 2.9.4+dfsg1-7+b3 > ii libxmlsec1 1.2.28-2 > ii libxmlsec1-nss 1.2.28-2 > ii libxrandr2
Bug#933499: libreoffice-base: database form with subform no longer works with "Data content could not be loaded" error
Package: libreoffice-base Version: 1:6.3.0~rc2-1 Severity: important As of today Jul 30 2019, a sub form no longer works that has worked for years. The pop up says that there is a problem with my SQL statement for MariaDB server version near ':link_from_ID)' at line one. But this isn't from a query I knowingly wrote. All of the reports relying on them still function fine. Adding data to the master form works, but the linked sub-form does not. If there is a work around to try I'm all ears. -- System Information: Debian Release: bullseye/sid APT prefers testing APT policy: (800, 'testing'), (700, 'unstable'), (600, 'experimental'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 4.19.0-5-amd64 (SMP w/4 CPU cores) Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8), LANGUAGE=en_US.utf8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages libreoffice-base depends on: ii libc6 2.28-10 ii libgcc1 1:9.1.0-10 ii libreoffice-base-core 1:6.3.0~rc2-1 ii libreoffice-base-drivers 1:6.3.0~rc2-1 ii libreoffice-core 1:6.3.0~rc2-1 ii libstdc++69.1.0-10 ii uno-libs3 6.3.0~rc2-1 ii ure 6.3.0~rc2-1 Versions of packages libreoffice-base recommends: ii default-jre [java6-runtime] 2:1.11-72 ii libreoffice-java-common 1:6.3.0~rc2-1 ii libreoffice-writer1:6.3.0~rc2-1 ii openjdk-10-jre [java6-runtime]10.0.2+13-2 ii openjdk-11-jre [java6-runtime]11.0.4+11-1 ii openjdk-8-jre [java6-runtime] 8u222-b10-1 ii openjdk-9-jre [java6-runtime] 9.0.4+12-4 ii oracle-java8-jdk [java6-runtime] 8u65 Versions of packages libreoffice-base suggests: ii libreoffice-report-builder 1:6.3.0~rc2-1 pn unixodbc Versions of packages libreoffice-core depends on: ii fontconfig 2.13.1-2 ii fonts-opensymbol2:102.11+LibO6.3.0~rc2-1 ii libboost-date-time1.67.01.67.0-13 ii libboost-locale1.67.0 1.67.0-13 ii libc6 2.28-10 ii libcairo2 1.16.0-4 ii libclucene-contribs1v5 2.3.3.4+dfsg-1 ii libclucene-core1v5 2.3.3.4+dfsg-1 ii libcmis-0.5-5v5 0.5.2-1 ii libcups22.2.10-6 ii libcurl3-gnutls 7.65.1-1 ii libdbus-1-3 1.12.16-1 ii libdconf1 0.30.1-2 ii libeot0 0.01-5 ii libepoxy0 1.5.3-0.1 ii libexpat1 2.2.7-1 ii libexttextcat-2.0-0 3.4.5-1 ii libfontconfig1 2.13.1-2 ii libfreetype62.9.1-4 ii libgcc1 1:9.1.0-10 ii libglib2.0-02.60.6-1 ii libgpgmepp6 1.12.0-6 ii libgraphite2-3 1.3.13-7 ii libgstreamer-plugins-base1.0-0 1.16.0-2 ii libgstreamer1.0-0 1.16.0-2 ii libharfbuzz-icu02.5.3-1 ii libharfbuzz0b 2.5.3-1 ii libhunspell-1.7-0 1.7.0-2+b1 ii libhyphen0 2.8.8-7 ii libice6 2:1.0.9-2 ii libicu6363.2-2 ii libjpeg62-turbo 1:1.5.2-2+b1 ii liblcms2-2 2.9-3 ii libldap-2.4-2 2.4.48+dfsg-1 ii libmythes-1.2-0 2:1.2.4-3+b1 ii libneon27-gnutls0.30.2-3 ii libnspr42:4.21-1 ii libnss3 2:3.45-1 ii libnumbertext-1.0-0 1.0.5-1 ii libodfgen-0.1-1 0.1.7-1 ii liborcus-0.14-0 0.14.1-6 ii libpng16-16 1.6.37-1 ii libpoppler820.71.0-5 ii librdf0 1.0.17-1.1+b1 ii libreoffice-common 1:6.3.0~rc2-1 ii librevenge-0.0-00.0.4-6+b1 ii libsm6 2:1.2.3-1 ii libstdc++6 9.1.0-10 ii libx11-62:1.6.7-1 ii libxext62:1.3.3-1+b2 ii libxinerama12:1.1.4-2 ii libxml2 2.9.4+dfsg1-7+b3 ii libxmlsec1 1.2.28-2 ii libxmlsec1-nss 1.2.28-2 ii libxrandr2 2:1.5.1-1 ii libxrender1 1:0.9.10-1 ii libxslt1.1 1.1.32-2 ii uno-libs3 6.3.0~rc2-1 ii ure 6.3.0~rc2-1 ii zlib1g 1:1.2.11.dfsg-1 Versions of packages libreoffice-core recommends: ii gstreamer1.0-libav 1.16.0-2 ii gstreamer1.0-plugins-bad 1.16.0-2 ii gstreamer1.0-plugins-base 1.16.0-2 ii gstreamer1.0-plugins-good 1.16.0-2 ii gstreamer1.0-plugins-ugly 1.16.0-2 ii libpaper-utils
