[Libreoffice-bugs] [Bug 118112] Parameter index out of range (1 > number of parameters, which is 0).

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118112

Lionel Elie Mamane <lionel at mamane.lu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |btomi96 at gmail.com,
                   |                            |serval2412 at yahoo.fr

--- Comment #6 from Lionel Elie Mamane <lionel at mamane.lu> ---
Either:
1) The data source of the form is configured as "execute directly: yes" /
"analyse SQL command: no", and then, well, it was kinda based on a bug that it
worked before.
Or:
2) Looks like on the contrary :link_from_Contact_ID is _not_ being replaced by
"?" anymore, and that's your problem. Assuming my guess is correct, then the
reason is probably that ParameterNameSubstitution is not set to "true", and the
solution is to set ParameterNameSubstitution to "true". It needs to be set in
existing files manually / by macro (sorry....), and to set it in new files,
connectivity/registry/mysql/org/openoffice/Office/DataAccess/Drivers.xcu needs
the same change as

https://gerrit.libreoffice.org/#/c/47283/5/connectivity/registry/firebird/org/openoffice/Office/DataAccess/Drivers.xcu

Julien, you want to take this?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180613/40fb9c51/attachment.html>