<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - 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#c18">Comment # 18</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - 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 <a class="email" href="mailto:elderdanlewis@gmail.com" title="Dan Lewis <elderdanlewis@gmail.com>"> Dan Lewis</a> <pre>This morning, I tested LibreOfficeDev_6.2.4.0.0_Linux_x86-64_deb for this bug. After installing this in parallel, I copied the config files for LO 6.2.2.2 to 6.2.4.0.0 config folder so that it would have the same settings. Opening the database file I use to connect to the MySQL 8.0.15 server, I changed the time zone setting from EST to UTC. Both of these are recognizable time zone. Then I opened a form with subform. No "parameter out of range" error message. The patch works! I also edited the content.xml file for this database file searching for "db:parameter-name-substitution". There was not one. Thanks to everyone who worked on this bug!! Someone else can close this bug as resolved if you think it should be.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>