[Libreoffice-bugs] [Bug 123999] New: time change causes the return of "parameter index out of range... using mysql and J/connector

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123999

            Bug ID: 123999
           Summary: time change causes the return of "parameter index out
                    of range... using mysql and J/connector
           Product: LibreOffice
           Version: 6.2.1.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: elderdanlewis at gmail.com

Description:
My database backend is mysql 8.0.15 along with same versions of J/connector and
workbook. On the day of a time change, I could not connect to MySQL (a known
bug) In the main database window, I opened the Connection dialog (Database >
Properties > Advanced ). In the Advanced Properties tab, I changed the name of
the database: from "my_database" to my_database?serverTimezone=UTC" as per the
bug instructions. I tested the connection: success. I closed the dialog. When I
opened a form with a subform, I can not get the data to load. Error message
begins with Parameter index out of range. I then unzipped the *.odb file and
looked in the context file. I looked for 'db
parameter-name-substitution="false"', but it did not exist in the file.

Actual Results:
1) Use a database which contains a form with a main and sub forms using MySQL
as the backend and Base as the front end.
2) The time must have changed. (In my case, EST became DST at 2AM on
3/10/2019.)
3) Open the database and connect to MySQL.
4) Open the form containing the subform.

Expected Results:
The error message immediately appeared: The data could not be loaded. Parameter
index out of range (1> number of parameters, which is 0)


Reproducible: Always


User Profile Reset: No



Additional Info:
It should have loaded the data into the fields of the form.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190311/db4de843/attachment.html>