<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:tim@tim-passingham.co.uk" title="tim@tim-passingham.co.uk">tim@tim-passingham.co.uk</a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Parameter index out of range (1 > number of parameters, which is 0)."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118112">bug 118112</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>tim@tim-passingham.co.uk
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Parameter index out of range (1 > number of parameters, which is 0)."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118112#c26">Comment # 26</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Parameter index out of range (1 > number of parameters, which is 0)."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118112">bug 118112</a>
from <span class="vcard"><a class="email" href="mailto:tim@tim-passingham.co.uk" title="tim@tim-passingham.co.uk">tim@tim-passingham.co.uk</a>
</span></b>
<pre>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.</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>