<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 - Open Sub-Form causes PostgreSQL error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119569">bug 119569</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 - Open Sub-Form causes PostgreSQL error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119569#c12">Comment # 12</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Open Sub-Form causes PostgreSQL error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119569">bug 119569</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 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.
I have not yet tried to produce a demo form but will try to do so if asked.
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>