[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

tim at tim-passingham.co.uk changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |tim at tim-passingham.co.uk

--- Comment #26 from tim at tim-passingham.co.uk ---
I reported this against #119569, which may have been the wrong bug, so I'm
repeating here.

I am getting much the same error on Windows version 6.1.0.3 and 

ubuntu Version: 6.1.1.2
Build ID: 1:6.1.1~rc2-0ubuntu0.18.04.1~lo3
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk2; 
Locale: en-GB (en_GB.UTF-8); Calc: group threaded

ubuntu version 6.0.5.2 is OK on my system.

I'm using base with mysql/mariadb sql.  When I open a form with a subform I get
(at least) one of these for each subform:

"The data content could not be loaded.

Parameter index out of range (1 > number of parameters, which is 0)."

And the detail: "SQL Status: S1009

Parameter index out of range (1 > number of parameters, which is 0)."

I have checked that it is the queries used by the subforms that are giving the
errors (not the subform code itself), but opening the query and supplying
parameters.  On 6.0.5.2 it works.

This is critical for me.  I use Base a lot, and all my applications makes
extensive use of subforms.  I have had to revert back to 6.0.5.2 on my main
system.

-- 
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/20180914/358605ce/attachment-0001.html>