<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - time change causes the return of "parameter index out of range... using mysql and J/connector"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123999#c9">Comment # 9</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - time change causes the return of "parameter index out of range... using mysql and J/connector"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123999">bug 123999</a>
from <span class="vcard"><a class="email" href="mailto:elderdanlewis@gmail.com" title="Dan Lewis <elderdanlewis@gmail.com>"> <span class="fn">Dan Lewis</span></a>
</span></b>
<pre>(In reply to Dan Lewis from <a href="show_bug.cgi?id=123999#c6">comment #6</a>)
<span class="quote">> (In reply to Alex Thurgood from <a href="show_bug.cgi?id=123999#c3">comment #3</a>)
> > @Dan : actually, looks like this is a duplicate of <a class="bz_bug_link
bz_status_NEW "
title="NEW - Parameter index out of range (1 > number of parameters, which is 0). (see comment 39 for manual fix)"
href="show_bug.cgi?id=118112">bug 118112</a>, setting as
> > such.
> >
> > *** This bug has been marked as a duplicate of <a class="bz_bug_link
bz_status_NEW "
title="NEW - Parameter index out of range (1 > number of parameters, which is 0). (see comment 39 for manual fix)"
href="show_bug.cgi?id=118112">bug 118112</a> ***
>
> Sorry, but this is NOT a duplicate of <a class="bz_bug_link
bz_status_NEW "
title="NEW - Parameter index out of range (1 > number of parameters, which is 0). (see comment 39 for manual fix)"
href="show_bug.cgi?id=118112">bug 118112</a>. I had a problem with bug
> 118112 more than a month ago. That is when I removed: db
> parameter-name-substitution="false. I have even edited context.xml when this
> problem occurred "yesterday. db parameter" only exists in one place in this
> file. However, "db parameter name" does not exist. So that is not the
> problem.</span >
More investigation on my part: When I finally edited the context.xml file, I
again found 'db: parameter-name-sustiution="false" '. Deleting it solved the
problem this time.
However, it had to have been added again sometime between Saturday afternoon
when I entered data into a form with a subform and Sunday morning when the
problem resurfaced. The only thing I did in that time was to add the time zone
to the name of my database because of an bug in the MySQL J/connector (8.0.15)
when the time went from EST to DST.
I also have discovered that creating a new form results in
db:parameter-name-substituion="false" being added to the context.xml file if it
is not present. So is this really a duplication of <a class="bz_bug_link
bz_status_NEW "
title="NEW - Parameter index out of range (1 > number of parameters, which is 0). (see comment 39 for manual fix)"
href="show_bug.cgi?id=118112">bug #118112</a>?</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>