My backend database is mysql on Windows 10 connected to LO using the mysql JDBC connector.
I am having a known issue when opening a pre LO 6.1 ODB file after upgrading to LO 6.1+. When trying to open the ODB file I now get the following error message:
The data content could not be loaded.
Parameter index out of range (1 > number of parameters, which is 0).
This issue is described in detail here:
https://bugs.documentfoundation.org/show_bug.cgi?id=118112
I am having a problem following the solution instructions in 'Comment 24" which are as follows:
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.
This is what I have done.
-
Used PeaZip to move content.xml to a different, non-archived, folder.
-
Used a text editor to remove exactly the text - db:parameter-name-substitution=“false”
-
Tried but was unable delete the content.xml in the OBD file.
-
Tried to add the altered content.xml file back to my ODB file opened in PeaZip but this action is not allowed.
So, my question is: How do I do this? Of course, if there is an easier way to solve this problem please let me know!
All help is greatly appreciated!!!