Discussion:
[Libreoffice-bugs] [Bug 118112] New: Parameter index out of range (1 > number of parameters, which is 0).
b***@bugs.documentfoundation.org
2018-06-11 14:10:12 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

Bug ID: 118112
Summary: Parameter index out of range (1 > number of
parameters, which is 0).
Product: LibreOffice
Version: 6.1.0.0.beta1+
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: mcmurchy1917-***@yahoo.co.uk

When opening a form, in LibreOffice Base, I get the following error box
displayed

The data content could not be loaded.
SQL Status: S1009

Parameter index out of range (1 > number of parameters, which is 0).


The form has worked on all versions of LibreOffice up to and including 6.0.4

I'm using

Slackware 14.2
Mariadb 10.0.35
mysql-connector-java-5.1.39
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-11 14:16:00 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #1 from Alex Kempshall <mcmurchy1917-***@yahoo.co.uk> ---
Created attachment 142656
--> https://bugs.documentfoundation.org/attachment.cgi?id=142656&action=edit
git bisect log

Attached is a git bisect log. The first bad commit is described as -

a29d97e6ddab8ec002ba9827bd5fc874117712e0 is the first bad commit
commit a29d97e6ddab8ec002ba9827bd5fc874117712e0
Author: Lionel Elie Mamane <***@mamane.lu>
Date: Tue Jan 2 22:49:31 2018 +0100

tdf#104986 move named parameters substitution into generic layer

Previously, drivers were responsible for making the substitution
themselves.
In practice they all (Firebird, ODBC and JDBC) used the LibreOffice SQL
parser to parse the SQL statement and do the substitution.

This had a few negative consequences:
* The substitition was applied to _all_ SQL commands, including
queries having the "execute SQL directly" bit set. Which means
that the SQL was _not_ sent to the DBMS exactly as typed by
the user. Even if there was no substitution to be made, since
the SQL command was always round-tripped through the parser,
thus "normalising" it (which is what led to tdf#104986).
* "execute SQL directly" queries "magically" behaved slightly
differently depending on whether the LibreOffice SQL parser
succeeded in parsing them or not.

Change-Id: Ieedc643f33467435a139e2565a01e6f398af041f
Reviewed-on: https://gerrit.libreoffice.org/47283
Tested-by: Jenkins <***@libreoffice.org>
Reviewed-by: Lionel Elie Mamane <***@mamane.lu>

:040000 040000 21498e671d4de80e991c7b51dec9934941e385a2
9ad610a6a942238862876f30a23e287fdbbda9b4 M connectivity
:040000 040000 e9abefeaa3966bf120917e674b181db122593c34
7e986739f2e48cc68966a085f241f46fd2ec80ae M include
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-11 14:20:03 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@libreoffice.org

--- Comment #2 from Xisco Faulí <***@libreoffice.org> ---
Hello Alex,
Could you please attach the document you're using to reproduce this problem ?
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-11 14:52:12 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #3 from Alex Kempshall <mcmurchy1917-***@yahoo.co.uk> ---
Created attachment 142660
--> https://bugs.documentfoundation.org/attachment.cgi?id=142660&action=edit
Base application and mysql data

tar gz file with database document and sql data for mariadb/mysql

Steps to recreate problem in LibreOffice 6.1

1.
untar the attached btuc.mysql.tar.gz

2.
Create the btuc database using the attached mysqldump file

3.
Open attached btuc_mysql.odb file with libreoffice

4.
Register btuc database in LibreOffice

5.
Open the form FMBTUC_DATA_ENTRY

6.
Error Box is displayed.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-11 14:55:06 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #4 from Alex Kempshall <mcmurchy1917-***@yahoo.co.uk> ---
I've created an equivalent application using the embedded hsqldb database. The
application behaves as expected - no error box.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-13 15:46:40 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #5 from Alex Kempshall <mcmurchy1917-***@yahoo.co.uk> ---
The commit that caused this regression was to fix bug tdf#104986.

In that bug report there's a discussion

(In reply to Lionel Elie Mamane from comment #18)
There is probably a much more robust way to do it... One only has to grossly
lex the SQL, just keeping track of whether on is inside a '-delimited string
or a "-delimited identifier. And outside of that, replace any word that
starts with ":" with "?".
In GDB of tdf#118112 I see this

Thread 7 "UNO AffineBridg" hit Breakpoint 1,
connectivity::java_sql_Connection::prepareStatement (this=0x35f5350,
sql="SELECT * FROM `btuc`.`tblBTUC_details` WHERE (
`btuc`.`tblBTUC_details`.`Contact_ID` = :link_from_Contact_ID )")
at /home/alex/master/connectivity/source/drivers/jdbc/JConnection.cxx:474
474 java_sql_PreparedStatement* pStatement = new
java_sql_PreparedStatement( t.pEnv, *this, sql );


Does this mean that :link_from_Contact_ID is being changed to ? and causing
the bug that I'm seeing.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-13 16:16:05 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

Lionel Elie Mamane <***@mamane.lu> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@gmail.com,
| |***@yahoo.fr

--- Comment #6 from Lionel Elie Mamane <***@mamane.lu> ---
Either:
1) The data source of the form is configured as "execute directly: yes" /
"analyse SQL command: no", and then, well, it was kinda based on a bug that it
worked before.
Or:
2) Looks like on the contrary :link_from_Contact_ID is _not_ being replaced by
"?" anymore, and that's your problem. Assuming my guess is correct, then the
reason is probably that ParameterNameSubstitution is not set to "true", and the
solution is to set ParameterNameSubstitution to "true". It needs to be set in
existing files manually / by macro (sorry....), and to set it in new files,
connectivity/registry/mysql/org/openoffice/Office/DataAccess/Drivers.xcu needs
the same change as

https://gerrit.libreoffice.org/#/c/47283/5/connectivity/registry/firebird/org/openoffice/Office/DataAccess/Drivers.xcu

Julien, you want to take this?
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-13 20:20:48 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

Julien Nabet <***@yahoo.fr> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
Ever confirmed|0 |1

--- Comment #7 from Julien Nabet <***@yahoo.fr> ---
I submitted this patch to gerrit: https://gerrit.libreoffice.org/#/c/55771/1
but it doesn't seem to work.
See comment in gerrit.

Anyway, I could reproduce this, let's put this to NEW.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-14 05:27:26 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #8 from Lionel Elie Mamane <***@mamane.lu> ---
(In reply to Lionel Elie Mamane from comment #6)
the reason is probably that ParameterNameSubstitution is not set to "true",
and the solution is to set ParameterNameSubstitution to "true". It needs to
be set in existing files manually / by macro (sorry....),
Refer to
https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c11
https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c15
for how to do that by editing the files in the odb manually or by macro,
respectively.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-14 07:49:19 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

Commit Notification <libreoffice-***@lists.freedesktop.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Whiteboard| |target:6.2.0
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-14 07:49:23 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #9 from Commit Notification <libreoffice-***@lists.freedesktop.org> ---
Julien Nabet committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=c179e8a7ea273a48713192c3ba7dfea313149cd8

tdf#118112: Use ParameterNameSubstitution for Mysql

It will be available in 6.2.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://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.
b***@bugs.documentfoundation.org
2018-06-14 09:49:51 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #10 from Alex Kempshall <mcmurchy1917-***@yahoo.co.uk> ---
Just tested this.

Can see the patch in my git log.
commit c179e8a7ea273a48713192c3ba7dfea313149cd8
Date: Wed Jun 13 22:16:44 2018 +0200
tdf#118112: Use ParameterNameSubstitution for Mysql
Change-Id: Ic48aee378d0a89466c49de85baa96a3bea127d2f
Reviewed-on: https://gerrit.libreoffice.org/55771
Have recompiled.

Still have the same problem. Is there anything else I'm supposed to have done?
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-14 09:51:50 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #11 from Lionel Elie Mamane <***@mamane.lu> ---
(In reply to Alex Kempshall from comment #10)
Post by b***@bugs.documentfoundation.org
Just tested this.
Have recompiled.
Still have the same problem. Is there anything else I'm supposed to have
done?
See comment 8
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-14 10:18:54 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #12 from Alex Kempshall <mcmurchy1917-***@yahoo.co.uk> ---
Thanks for pointing me in the right direction.

Now works as expected.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-14 16:26:09 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

Commit Notification <libreoffice-***@lists.freedesktop.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Whiteboard|target:6.2.0 |target:6.2.0 target:6.1.0.1
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-14 16:26:12 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #13 from Commit Notification <libreoffice-***@lists.freedesktop.org> ---
Julien Nabet committed a patch related to this issue.
It has been pushed to "libreoffice-6-1":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=90d77c7d18050437d47ba967e4c4ad7e523ced0e&h=libreoffice-6-1

tdf#118112: Use ParameterNameSubstitution for Mysql

It will be available in 6.1.0.1.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://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.
b***@bugs.documentfoundation.org
2018-06-14 18:21:48 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #14 from Julien Nabet <***@yahoo.fr> ---
(In reply to Lionel Elie Mamane from comment #8)
Post by b***@bugs.documentfoundation.org
...
Refer to
https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c11
https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c15
for how to do that by editing the files in the odb manually or by macro,
respectively.
Just for information, I tested both methods (even if first one has already been
confirmed), I confirm it works.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-15 08:20:44 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

Julien Nabet <***@yahoo.fr> changed:

What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=11
| |7589

--- Comment #15 from Julien Nabet <***@yahoo.fr> ---
Lionel: about your comment https://gerrit.libreoffice.org/#/c/55771/, "force
ParameterNameSubstitution to true", I checked YDriver.cxx and there's already
the property at true (see
https://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/mysql/YDriver.cxx#211)

I didn't test but it seems that default value of "ParameterNameSubstitution" is
in
https://opengrok.libreoffice.org/xref/core/dbaccess/source/core/dataaccess/ModelImpl.cxx#992
Thought it might help for tdf#117589 put in see also if the by default value is
true.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-15 11:36:34 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #16 from Lionel Elie Mamane <***@mamane.lu> ---
(In reply to Julien Nabet from comment #15)
Post by b***@bugs.documentfoundation.org
Lionel: about your comment https://gerrit.libreoffice.org/#/c/55771/, "force
ParameterNameSubstitution to true", I checked YDriver.cxx and there's
already the property at true (see
https://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/mysql/
YDriver.cxx#211)
Hmm... Maybe the bug then is that if ParamterNameSubstitution is _already_ in
info, it is added a second time, and only the first value takes effect. In that
case, IMHO it needs to be *changed* in info, not appended to it. Can you check
if my guess is correct?
Post by b***@bugs.documentfoundation.org
I didn't test but it seems that default value of "ParameterNameSubstitution"
is in
https://opengrok.libreoffice.org/xref/core/dbaccess/source/core/dataaccess/
ModelImpl.cxx#992
Thought it might help for tdf#117589 put in see also if the by default value
is true.
No, that's a LibreOffice-wide default for all drivers, I wouldn't touch it for
the needs of a few drivers.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-18 21:20:10 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

Commit Notification <libreoffice-***@lists.freedesktop.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Whiteboard|target:6.2.0 target:6.1.0.1 |target:6.2.0 target:6.1.0.1
| |target:6.0.6
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-06-18 21:20:13 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #17 from Commit Notification <libreoffice-***@lists.freedesktop.org> ---
Julien Nabet committed a patch related to this issue.
It has been pushed to "libreoffice-6-0":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=4de33eb2b5a802e8eda36c5806913efeead68441&h=libreoffice-6-0

tdf#118112: Use ParameterNameSubstitution for Mysql

It will be available in 6.0.6.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://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.
b***@bugs.documentfoundation.org
2018-06-20 06:51:03 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #18 from Alex Kempshall <mcmurchy1917-***@yahoo.co.uk> ---
Is my understanding correct in that this patch -

1.
will stop the problem in new applications;

2.
applications built before this patch will have to be fixed by manually applying
one of the work arounds.

If the above is true can we make a comment in the change log and/or release
notes to that effect and also provide a macro in LibreOffice Macros & Dialogs
that can be manually run to fix the problem in old applications.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-07-23 12:00:11 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #19 from Xisco Faulí <***@libreoffice.org> ---
A polite ping to Julien Nabet:
Is this bug fixed? if so, could you please close it as RESOLVED FIXED ?
Otherwise, Could you please explain what's missing?
Thanks
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-07-23 12:25:32 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #20 from Julien Nabet <***@yahoo.fr> ---
Xisco: I must recognize I don't know.
We may say it's fixed because the brand new files won't have the pb + we can
fix this with a macro.
We may say it's not fixed yet (or partly fixed) because we'd like "force
ParameterNameSubstitution to true" and I don't know how to do it.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-07-23 12:28:56 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #21 from Alex Kempshall <mcmurchy1917-***@yahoo.co.uk> ---
I manually applied one of the work arounds and it fixed the problem for me.

I've not built an application from scratch to see whether the problem never
occurs.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-07-30 14:10:19 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

***@familiegrosskopf.de changed:

What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=11
| |8984
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-08-20 05:58:43 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #22 from ***@familiegrosskopf.de ---
Just read this in the users-mailinglist:
OLD SETTING:<db:driver-settings db:system-driver-settings="" db:base-dn=""
db:parameter-name-substitution="false"/>
NEW SETTING:<db:driver-settings db:system-driver-settings="" db:base-dn=""/>

You have to change the content of content.xml inside the *.odb-file for
*.odb-files, which are created before 6.1. So we couldn't say the bug has been
solved.

http://document-foundation-mail-archive.969070.n3.nabble.com/LibreOffice-Base-now-does-not-apply-named-parameter-substitution-after-upgrade-from-LO-6-0-to-LO-6-1s-td4246734.html
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-08-26 08:49:59 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

david <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@gmail.com

--- Comment #23 from david <***@gmail.com> ---
While waiting for a better way to convert the .odb file, can someone please
post the steps to extract and edit the content.xml file manually? Thanks!
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-08-26 17:17:50 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #24 from ***@familiegrosskopf.de ---
(In reply to david from comment #23)
Post by b***@bugs.documentfoundation.org
While waiting for a better way to convert the .odb file, can someone please
post the steps to extract and edit the content.xml file manually? Thanks!
Try the following with a copy of your *.odb-file:

Open the *.odb-file with a packing-program ("Zip", here on Linux it's called
"Ark").
content.xml should be moved outside the *.odb-file (Unzip only this file).
Take a simple text-editor (I use Kate in Linux ...) and open content.xml.
Search for
db:parameter-name-substitution="false"
and delete this.
Save the new content.xml
Delete old content.xml in the *.odb-file with the packing-program.
Move the new content.xml into the *.odb-file.

Hope this works for you.

Regards

Robert
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-08-27 13:47:35 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #25 from david <***@gmail.com> ---
Thanks Robert! Its working now. : )
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-09-14 09:06:15 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

***@tim-passingham.co.uk changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@tim-passingham.co.uk

--- Comment #26 from ***@tim-passingham.co.uk ---
I reported this against #119569, which may have been the wrong bug, so I'm
repeating here.

I am getting much the same error on Windows version 6.1.0.3 and

ubuntu Version: 6.1.1.2
Build ID: 1:6.1.1~rc2-0ubuntu0.18.04.1~lo3
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk2;
Locale: en-GB (en_GB.UTF-8); Calc: group threaded

ubuntu version 6.0.5.2 is OK on my system.

I'm using base with mysql/mariadb sql. When I open a form with a subform I get
(at least) one of these for each subform:

"The data content could not be loaded.

Parameter index out of range (1 > number of parameters, which is 0)."

And the detail: "SQL Status: S1009

Parameter index out of range (1 > number of parameters, which is 0)."

I have checked that it is the queries used by the subforms that are giving the
errors (not the subform code itself), but opening the query and supplying
parameters. On 6.0.5.2 it works.

This is critical for me. I use Base a lot, and all my applications makes
extensive use of subforms. I have had to revert back to 6.0.5.2 on my main
system.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-09-14 09:33:44 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #27 from ***@tim-passingham.co.uk ---
Having read through more of the comments above I can confirm that deleting

db:parameter-name-substitution="false"

does work for me, so it's no longer 'critical' for me.

Editing content.xml turned out to be slightly tricky because on my system using
xml editors such as kate or geany, it's all one line, with no xml structure.

That fix could be a lot of work for a lot of users of existing databases. If
this is the only fix I suggest the ability to do this from within Base itself
is added to the database edit menu.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-09-14 09:48:14 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #28 from Lionel Elie Mamane <***@mamane.lu> ---
(In reply to tim from comment #27)
Post by b***@bugs.documentfoundation.org
Editing content.xml turned out to be slightly tricky because on my system
using xml editors such as kate or geany, it's all one line, with no xml
structure.
Using the macro could be considered easier. See
https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c15
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-09-14 10:00:42 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #29 from ***@tim-passingham.co.uk ---
I think there may be users for which some of this could be difficult. I still
think some for of easy to understand migration tool for pre 6.1 odbs should be
provided.

Many users may not find it easy to find stuff in bugzilla (I struggle at
times), let alone find and execute a macro or edit an odb.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-09-14 13:01:58 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #30 from Lionel Elie Mamane <***@mamane.lu> ---
(In reply to tim from comment #29)
Post by b***@bugs.documentfoundation.org
I think there may be users for which some of this could be difficult. I
still think some for of easy to understand migration tool for pre 6.1 odbs
should be provided.
Yes. No one disputes your statement, nor said anything to the contrary.
Possibly, the settings the LibreOffice *knows* are the correct one should just
overwrite the ones in the file...
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-09-14 13:06:54 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #31 from ***@tim-passingham.co.uk ---
(In reply to Lionel Elie Mamane from comment #30)
Post by b***@bugs.documentfoundation.org
(In reply to tim from comment #29)
Post by b***@bugs.documentfoundation.org
I think there may be users for which some of this could be difficult. I
still think some for of easy to understand migration tool for pre 6.1 odbs
should be provided.
Yes. No one disputes your statement, nor said anything to the contrary.
Possibly, the settings the LibreOffice *knows* are the correct one should
just overwrite the ones in the file...
Yes, apologies if I was misunderstanding the drift of the suggestions and
commments.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-09-14 20:31:24 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #32 from ***@tim-passingham.co.uk ---
I just noticed that using MYSQL(Native) avoids this problem. I was using
MYSQL(JDBC) when I came across it.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-12-06 22:50:41 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

--- Comment #33 from Dan Lewis <***@gmail.com> ---
(In reply to tim from comment #32)
Post by b***@bugs.documentfoundation.org
I just noticed that using MYSQL(Native) avoids this problem. I was using
MYSQL(JDBC) when I came across it.
I have recently installed MySQL and MySQL workbook. I use LibreOffice 6.0.6.2
and 6.1.4.1 downloaded from LibreOffice website. I also have two Java
connectors for MySQL (8.0.13 and 5.1.23) which I downloaded from the MySQL
website in the last couple of days. Both of them work with LO 6.0.6.2 but give
the same error message with 6.1.4.1.
--
You are receiving this mail because:
You are the assignee for the bug.
b***@bugs.documentfoundation.org
2018-12-10 09:10:39 UTC
Permalink
https://bugs.documentfoundation.org/show_bug.cgi?id=118112

Alex Thurgood <***@tuta.io> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@koritec.de

--- Comment #34 from Alex Thurgood <***@tuta.io> ---
*** Bug 121997 has been marked as a duplicate of this bug. ***
--
You are receiving this mail because:
You are the assignee for the bug.
Loading...