<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><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> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - 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>
<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;">Version</td>
<td>6.2.1.2 release
</td>
<td>6.2.2.2 release
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - 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#c12">Comment # 12</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - 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>I have finally discovered what happened; I just do not know why. This is the
steps I used to create and temporarily solve it.
1) Use Base to connect to the MySQL server using the J/connector (MySQL). My
versions of these two are 8.0.15.
2) Open a form with a subform and add some data. No problem yet.
3) Display the lists of forms contained in the database.
4) Right click below this list.
5) Select Database > Connection Type
6) In the Data Source Properties window, click Next.
7) In the Database Properties window, modify the database name.
In my case, it was Budget?serverTimezone=EST. I changed this to
Budget?serverTimezone=EDT.
8) When testing the connection, the error message stated EDT is not a
recognized time zone, so I changed it back. This time testing the connection
worked.
9) Click finished and save the database document file.
10) Open the form with the subform. Immediately, the error message appears
about the parameter being out of range.
11) Close the database file.
12 Edit the context.xml file and remove db;parameter-name-substitution="false".
13) Connect the database to MySQl again. When the form with the subform is
opened, it does so nomally. Data can be added, deleted, or modified.
Conclusion: When changing the connection type including the time zone, you are
also causing Base to again add db:parameter-name-substitution="false".</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>