[Libreoffice-bugs] [Bug 123999] 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

Dan Lewis <elderdanlewis at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|6.2.1.2 release             |6.2.2.2 release

--- Comment #12 from Dan Lewis <elderdanlewis at gmail.com> ---
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".

-- 
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/20190322/6568c14c/attachment.html>