[Libreoffice-bugs] [Bug 141132] SQL Query to MARIADB fails (conn=1411) Could not set parameter at position..... in a formular
https://bugs.documentfoundation.org/show_bug.cgi?id=141132 --- Comment #7 from Alex Thurgood --- For the record, see also: https://bz.apache.org/ooo/show_bug.cgi?id=42464 and: https://bz.apache.org/ooo/show_bug.cgi?id=8949 to get an idea of just how old this is. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141132] SQL Query to MARIADB fails (conn=1411) Could not set parameter at position..... in a formular
https://bugs.documentfoundation.org/show_bug.cgi?id=141132 Alex Thurgood changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |DUPLICATE --- Comment #6 from Alex Thurgood --- *** This bug has been marked as a duplicate of bug 137893 *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141132] SQL Query to MARIADB fails (conn=1411) Could not set parameter at position..... in a formular
https://bugs.documentfoundation.org/show_bug.cgi?id=141132 --- Comment #5 from Herbert --- Created attachment 171155 --> https://bugs.documentfoundation.org/attachment.cgi?id=171155=edit Attachment of example testcase set with HSQLDB in libreoffice forgotten to attache the testcase -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141132] SQL Query to MARIADB fails (conn=1411) Could not set parameter at position..... in a formular
https://bugs.documentfoundation.org/show_bug.cgi?id=141132 Herbert changed: What|Removed |Added Version|7.1.1.2 release |7.1.2.2 release --- Comment #4 from Herbert --- Version: 7.1.2.2 / LibreOffice Community Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4 CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: kf5 Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded System is : SuSE-Linus tubleweed and Mariadb mariadb-admin Ver 9.1 Distrib 10.5.9-MariaDB, for Linux on x86_64 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Server version 10.5.9-MariaDB Protocol version10 Connection Localhost via UNIX socket I created an HSQL Database for Test : see attachment then I created and copied the database to 1. mariadb - jdbc connection 2. mysql - direct connection using mariadb as well Errors appeared in both mariadb versions while creating a form and setting a subform with the help of the database-assistent : Errormessage: "Die Dateninhalte konn:en nicht geladen werden. /home/buildslave/source/libo-core/connectivity/source/commontools/dbtools.cxx:751 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_accNo )' at line 1 /home/buildslave/source/libo-core/connectivity/source/drivers/mysqlc/mysqlc_general.cxx:119" The errors are mostly always wih the remark: ":link_from_accNo" It seems to be an uncompatibility of mariadb with libreoffice-jdbc or mysql direct connection. As well errors appeard in case a field is not configured with a standard value. With native HSQLDB it works fine. See the example database here attached. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141132] SQL Query to MARIADB fails (conn=1411) Could not set parameter at position..... in a formular
https://bugs.documentfoundation.org/show_bug.cgi?id=141132 Robert Großkopf changed: What|Removed |Added CC||rob...@familiegrosskopf.de --- Comment #3 from Robert Großkopf --- Could be it is a problem with parameters. If this is a part of the content.xml in the Base file: You have to change it to You could also try it by running the macro: SUB FB_Parameter DIM oSettings AS OBJECT oSettings = ThisComponent.DataSource.Settings oSettings.ParameterNameSubstitution = True END SUB This will change it also. The possibility to change this in additional properties for the database has been gone for MySQL/MariaDB -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141132] SQL Query to MARIADB fails (conn=1411) Could not set parameter at position..... in a formular
https://bugs.documentfoundation.org/show_bug.cgi?id=141132 Alex Thurgood changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||7893 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141132] SQL Query to MARIADB fails (conn=1411) Could not set parameter at position..... in a formular
https://bugs.documentfoundation.org/show_bug.cgi?id=141132 --- Comment #2 from Alex Thurgood --- Indeed, seems to me that this is a duplicate of bug 137893 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141132] SQL Query to MARIADB fails (conn=1411) Could not set parameter at position..... in a formular
https://bugs.documentfoundation.org/show_bug.cgi?id=141132 Alex Thurgood changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #1 from Alex Thurgood --- >From the linked error message pointing to the Object.cxx file, it appears that you are using a JDBC connection. Does the same problem also manifest itself with the built-in native mysql connector driver ? I wouldn't be surprised if this has never worked. I seem to recall that it was never possible to use a subform to query a separate database schema (but I would like to hope that this is only a regression, instead of a missing feature). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs