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

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

 Status|RESOLVED|VERIFIED

--- Comment #20 from Julien Nabet  ---
Thank you Dan for your feedback.
Let's put this one to VERIFIED then.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #19 from Dan Lewis  ---
The daily build I used was March 31, 2019

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #18 from Dan Lewis  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[Drew Jensen]

Howdy Dan,

You find all the daily builds at https://dev-builds.libreoffice.org/daily/

I install those in parallel on my system, which I figure you already know
how to do but for those who may not:
https://wiki.documentfoundation.org/Installing_in_parallel

Best wishes,

Drew


On Sat, Mar 30, 2019 at 9:11 PM Dan Lewis  wrote:

> I have run into a problem with this bug. I would like to download a daily
> build, but I do not know how. I have clicked on the link below, but I don't
> see any .deb files that I can download. I don't really know what it is that
> I am to download. (I use Ubuntu 18.04.) In fact, I do not see any builds
> available there. I could use some help so that I can test this patch to see
> if it works.
>
> Dan
> On 3/27/19 9:14 AM, bugzilla-dae...@bugs.documentfoundation.org wrote:
>
> *Comment # 17
>  on bug
> 123999  from
> Commit Notification  *
>
> Julien Nabet committed a patch related to this issue.
> It has been pushed to "libreoffice-6-2":
> https://git.libreoffice.org/core/+/15f4f8b7bfd666d69381696fe288da24302d2ecd%5E%21
> tdf#123999 : 
> ParameterNameSubstitution in mysqljdbc
>
> It will be available in 6.2.3.
>
> The patch should be included in the daily builds available 
> athttps://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
> information about daily builds can be found 
> at:https://wiki.documentfoundation.org/Testing_Daily_Builds
>
> Affected users are encouraged to test the fix and report feedback.
>
> --
> You are receiving this mail because:
>
>- You reported the bug.
>
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

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

[Dan Lewis]

I have run into a problem with this bug. I would like to download a 
daily build, but I do not know how. I have clicked on the link below, 
but I don't see any .deb files that I can download. I don't really know 
what it is that I am to download. (I use Ubuntu 18.04.) In fact, I do 
not see any builds available there. I could use some help so that I can 
test this patch to see if it works.


Dan

On 3/27/19 9:14 AM, bugzilla-dae...@bugs.documentfoundation.org wrote:


*Comment # 17 
 on 
bug 123999 
 from 
Commit Notification  *

Julien Nabet committed a patch related to this issue.
It has been pushed to "libreoffice-6-2":

https://git.libreoffice.org/core/+/15f4f8b7bfd666d69381696fe288da24302d2ecd%5E%21

tdf#123999  : ParameterNameSubstitution in mysqljdbc

It will be available in 6.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/  in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

You are receiving this mail because:

  * You reported the bug.

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

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

[bugzilla-daemon]

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

--- Comment #17 from Commit Notification 
 ---
Julien Nabet committed a patch related to this issue.
It has been pushed to "libreoffice-6-2":

https://git.libreoffice.org/core/+/15f4f8b7bfd666d69381696fe288da24302d2ecd%5E%21

tdf#123999: ParameterNameSubstitution in mysqljdbc

It will be available in 6.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|target:6.3.0|target:6.3.0 target:6.2.3

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #16 from Christian Lohmaier  ---
adding comments lost during infra-outage:
https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176623.html
--- Comment #14 from Lionel Elie Mamane ---
If I understand well, all this is with the "MySQL (JDBC)" connection type, not
the JDBC connection type.

(In reply to Julien Nabet from comment #13)
> Lionel: any thoughts about this patch? Does it seem the right lead or would
> you prefer I provide a bt from this location to understand the full
> mechanism?

This looks like a LibreOffice-wide default. The right fix should probably be in
the MySQL-JDBC specific defaults, in
connectivity/registry/mysql_jdbc/org/openoffice/Office/DataAccess/Drivers.xcu

In the "" Properties part,
it should give the correct value for ParameterNameSubstitution, that is "true".
It seems it doesn't.

As usual, this will solve it only for new files...

https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176624.html
--- Comment #15 from Julien Nabet ---
(In reply to Lionel Elie Mamane from comment #14)
> ...
> This looks like a LibreOffice-wide default. The right fix should probably be
> in the MySQL-JDBC specific defaults, in
> connectivity/registry/mysql_jdbc/org/openoffice/Office/DataAccess/Drivers.xcu
> ...
I thought about this after having commented but I just wonder in which case
this option should be put to false.

Anyway, I'll be able to propose a patch after my day time job.

https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176625.html
--- Comment #16 from Lionel Elie Mamane ---
(In reply to Julien Nabet from comment #15)

> I thought about this after having commented but I just wonder in which case
> this option should be put to false.

Databases (or drivers) that support the :named_parameter syntax, as opposed to
only the unnamed parameter syntax with "?".

https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176626.html
--- Comment #17 from Mike Kaganski ---
(In reply to Lionel Elie Mamane from comment #14)
> This looks like a LibreOffice-wide default. The right fix should probably be
> in the MySQL-JDBC specific defaults, in
> connectivity/registry/mysql_jdbc/org/openoffice/Office/DataAccess/Drivers.xcu
> 
> In the "" Properties
> part, it should give the correct value for ParameterNameSubstitution, that
> is "true". It seems it doesn't.
> 
> As usual, this will solve it only for new files...

Please note that we have some issues, so that different defaults are used at
different levels of execution, which makes strange results when a
driver-specific default does not correspond to global defaults, like in bug
121092. I'm afraid bug 124022 should be addressed first.

https://lists.freedesktop.org/archives/libreoffice-bugs/2019-March/176628.html
--- Comment #18 from Julien Nabet ---
(In reply to Mike Kaganski from comment #17)
> ...
> Please note that we have some issues, so that different defaults are used at
> different levels of execution, which makes strange results when a
> driver-specific default does not correspond to global defaults, like in bug
> 121092. I'm afraid bug 124022 should be addressed first.

Let's see the coming patch on
connectivity/registry/mysql_jdbc/org/openoffice/Office/DataAccess/Drivers.xcu
like quick bandaid fix.

tdf#124022 would be useful indeed but seems more a redesign/refactoring which
needs someone wanting to spend some time on internal mechanism.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||8112

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|NEW |RESOLVED

--- Comment #15 from Julien Nabet  ---
Cherry-pick on 6.2 waiting for review here:
https://gerrit.libreoffice.org/#/c/69786/

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:6.3.0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #14 from Commit Notification 
 ---
Julien Nabet committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/+/3149ffea4c7285ceebe990640cbfb74d2e10e7e0%5E%21

tdf#123999: ParameterNameSubstitution in mysqljdbc

It will be available in 6.3.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #18 from Julien Nabet  ---
(In reply to Mike Kaganski from comment #17)
> ...
> Please note that we have some issues, so that different defaults are used at
> different levels of execution, which makes strange results when a
> driver-specific default does not correspond to global defaults, like in bug
> 121092. I'm afraid bug 124022 should be addressed first.

Let's see the coming patch on
connectivity/registry/mysql_jdbc/org/openoffice/Office/DataAccess/Drivers.xcu
like quick bandaid fix.

tdf#124022 would be useful indeed but seems more a redesign/refactoring which
needs someone wanting to spend some time on internal mechanism.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #17 from Mike Kaganski  ---
(In reply to Lionel Elie Mamane from comment #14)
> This looks like a LibreOffice-wide default. The right fix should probably be
> in the MySQL-JDBC specific defaults, in
> connectivity/registry/mysql_jdbc/org/openoffice/Office/DataAccess/Drivers.xcu
> 
> In the "" Properties
> part, it should give the correct value for ParameterNameSubstitution, that
> is "true". It seems it doesn't.
> 
> As usual, this will solve it only for new files...

Please note that we have some issues, so that different defaults are used at
different levels of execution, which makes strange results when a
driver-specific default does not correspond to global defaults, like in bug
121092. I'm afraid bug 124022 should be addressed first.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #16 from Lionel Elie Mamane  ---
(In reply to Julien Nabet from comment #15)

> I thought about this after having commented but I just wonder in which case
> this option should be put to false.

Databases (or drivers) that support the :named_parameter syntax, as opposed to
only the unnamed parameter syntax with "?".

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #15 from Julien Nabet  ---
(In reply to Lionel Elie Mamane from comment #14)
> ...
> This looks like a LibreOffice-wide default. The right fix should probably be
> in the MySQL-JDBC specific defaults, in
> connectivity/registry/mysql_jdbc/org/openoffice/Office/DataAccess/Drivers.xcu
> ...
I thought about this after having commented but I just wonder in which case
this option should be put to false.

Anyway, I'll be able to propose a patch after my day time job.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #14 from Lionel Elie Mamane  ---
If I understand well, all this is with the "MySQL (JDBC)" connection type, not
the JDBC connection type.

(In reply to Julien Nabet from comment #13)
> Lionel: any thoughts about this patch? Does it seem the right lead or would
> you prefer I provide a bt from this location to understand the full
> mechanism?

This looks like a LibreOffice-wide default. The right fix should probably be in
the MySQL-JDBC specific defaults, in
connectivity/registry/mysql_jdbc/org/openoffice/Office/DataAccess/Drivers.xcu

In the "" Properties part,
it should give the correct value for ParameterNameSubstitution, that is "true".
It seems it doesn't.

As usual, this will solve it only for new files...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

 CC||lio...@mamane.lu

--- Comment #13 from Julien Nabet  ---
On pc Debian x86-64 with master sources updated today, I could reproduce this
with a more simple process:
- create brand new odb  file
- choose Mysql then JDBC
- then click by default option + no need to register database

not sure it's useful but I was trying to reproduce the last Dan's comment from
a brand new file
- Select Database > Connection Type
- In the Data Source Properties window, click Next.
- In the Database Properties window, modify the database name.
  add "serverTimezone=EST" without quotes and save

- Click finished and save the database document file
- close LO

Indeed, there's db:parameter-name-substitution="false" added
With this patch, I don't reproduce this:
diff --git a/dbaccess/source/core/dataaccess/ModelImpl.cxx
b/dbaccess/source/core/dataaccess/ModelImpl.cxx
index 00463902b340..bcf15cbbbf22 100644
--- a/dbaccess/source/core/dataaccess/ModelImpl.cxx
+++ b/dbaccess/source/core/dataaccess/ModelImpl.cxx
@@ -985,7 +985,7 @@ const AsciiPropertyValue*
ODatabaseModelImpl::getDefaultDataSourceSettings()
 AsciiPropertyValue( "LocalSocket",makeAny( OUString()
) ),
 AsciiPropertyValue( "NamedPipe",  makeAny( OUString()
) ),
 // misc known driver settings
-AsciiPropertyValue( "ParameterNameSubstitution",  makeAny( false ) ),
+AsciiPropertyValue( "ParameterNameSubstitution",  makeAny( true ) ),
 AsciiPropertyValue( "AddIndexAppendix",   makeAny( true ) ),
 AsciiPropertyValue( "IgnoreDriverPrivileges", makeAny( true ) ),
 AsciiPropertyValue( "ImplicitCatalogRestriction", ::cppu::UnoType<
OUString >::get() ),

Lionel: any thoughts about this patch? Does it seem the right lead or would you
prefer I provide a bt from this location to understand the full mechanism?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

Version|6.2.2.2 release |6.2.1.2 release

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Dan Lewis  changed:

   What|Removed |Added

Version|6.2.1.2 release |6.2.2.2 release

--- Comment #12 from Dan Lewis  ---
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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #11 from Dan Lewis  ---
(In reply to Xisco Faulí from comment #10)
> (In reply to Julien Nabet from comment #8)
> > Dan: would it be possible you create a minimum testcase with embedded hsqldb
> > so it could be easily and quickly reproduceable?
> 
> @Dan, would you mind providing a minimal testcase ?

The quick answer is no; that is not possible at all. I am using Base as the
front end for MySQL. This does not an embedded database. All of the table
structure and data are contained on the MySQL server, not within the Base
document file. I use MySQL server 8.0.15 and MySQL J/connector 8.0.15 to
connect to the MySQL server.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Status|REOPENED|NEW
 CC||xiscofa...@libreoffice.org

--- Comment #10 from Xisco Faulí  ---
(In reply to Julien Nabet from comment #8)
> Dan: would it be possible you create a minimum testcase with embedded hsqldb
> so it could be easily and quickly reproduceable?

@Dan, would you mind providing a minimal testcase ?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #9 from Dan Lewis  ---
(In reply to Dan Lewis from comment #6)
> (In reply to Alex Thurgood from comment #3)
> > @Dan : actually, looks like this is a duplicate of bug 118112, setting as
> > such.
> > 
> > *** This bug has been marked as a duplicate of bug 118112 ***
> 
> Sorry, but this is NOT a duplicate of bug 118112. 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.

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 bug #118112?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

 CC||serval2...@yahoo.fr

--- Comment #8 from Julien Nabet  ---
Dan: would it be possible you create a minimum testcase with embedded hsqldb so
it could be easily and quickly reproduceable?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #7 from Dan Lewis  ---
(In reply to Mike Kaganski from comment #4)
> I believe that's related to
> https://git.libreoffice.org/core/+/d6fce54c82868b82bd6fa190db6047d69bbb3ecf
> and
> https://git.libreoffice.org/core/+/3208fcb3a36d75d6290d9c548430682f153b09db
> 
> which changed the default for ParameterNameSubstitution to true.

I have created a new form to access the same data using 6.2.1.2. Then I edited
the context.xml file replacing
   parameter-name-substitution="false" to
   parameter-name-substitution="true".
When opening the form, I get the error message again about the parameter index
being out of range.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Dan Lewis  changed:

   What|Removed |Added

 Ever confirmed|0   |1
 Resolution|DUPLICATE   |---
 Status|RESOLVED|REOPENED

--- Comment #6 from Dan Lewis  ---
(In reply to Alex Thurgood from comment #3)
> @Dan : actually, looks like this is a duplicate of bug 118112, setting as
> such.
> 
> *** This bug has been marked as a duplicate of bug 118112 ***

Sorry, but this is NOT a duplicate of bug 118112. 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #5 from Dan Lewis  ---
(In reply to Alex Thurgood from comment #1)
> @Dan : could you check to see whether you've been affected by bug 119786 ?

Yes, I believe that is part of the problem which can be solved. But, this does
not solve the problem of the error message concerning "parameter index out of
range...)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #4 from Mike Kaganski  ---
I believe that's related to
https://git.libreoffice.org/core/+/d6fce54c82868b82bd6fa190db6047d69bbb3ecf and
https://git.libreoffice.org/core/+/3208fcb3a36d75d6290d9c548430682f153b09db

which changed the default for ParameterNameSubstitution to true.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #3 from Alex Thurgood  ---
@Dan : actually, looks like this is a duplicate of bug 118112, setting as such.

*** This bug has been marked as a duplicate of bug 118112 ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||9850

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #2 from Alex Thurgood  ---
Oh, and also that bug 119850 isn't interfering either...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||9786

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #1 from Alex Thurgood  ---
@Dan : could you check to see whether you've been affected by bug 119786 ?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs