Description: I updated LO from 6.0.7 to 6.4.2.2. Now I get an error when trying to open a form in a split database: “Error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE]“ When running in Safe Mode, I can access the database. But even when using a new, clean profile, I can't access the database! When starting LO with LC_ALL=C libreoffice I can open a form within the database but then an error like “The data could not be loaded. There exists no table named "[Name of my table]".“ is displayed. Steps to Reproduce: 1. Update LibreOffice from 6.0.7 to 6.4.2.2 on Ubuntu using https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-6-4 2. Start LO and open a split database 3. Click on a table or a form Actual Results: Seeing following error message (when using German localization as normally) “Error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE]“ When starting LO with LC_ALL=C libreoffice I can open a form within the database but then an error message like “The data could not be loaded. There exists no table named "[Name of my table]".“ is displayed. So the database is not usable at all. Expected Results: The split database should be accessible. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: [Information automatically included from LibreOffice] Locale: de Module: OfficeDatabaseDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes Version: 6.4.2.2 Build ID: 1:6.4.2-0ubuntu0.18.04.3 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: en-US (C); UI-Language: en-US Calc: threaded
Hello, Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you
What kind of database do you use? "Split database" isn't enough to test the behavior. HSQLDB? Version?
Created attachment 159465 [details] Test Split Database with HSQLDB 2.3.2 I just created a new test database with one table, using the Wizard from https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=61183 . Sorry, I forgot to include the information in the report that I`m using HSQLDB 2.3.2.
Have tested the attached database. Have to set the Cllass Path and the path to the database first, deactivated macros. No problem to connect to the external HSQLDB, no problem to add a row. to delete a row ... Couldn't confirm any buggy behavior here. Tested with LO 6.4.3.1 on OpenSUSE 15.1 64bit rpm Linux
@ Robert: What do you mean with the following? > Have to set the Cllass Path and the path to the database first I have no Class Paths set like described in https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=61183 . Where do you need to set a path to the database? I let LO create a new profile (by renaming the old one), when opening the database, I get the described error. When restarting LO in Safe Mode and opening the database, there is no error message and everything works as expected.
(In reply to Hans from comment #5) > @ Robert: What do you mean with the following? > > Have to set the Cllass Path and the path to the database first > > I have no Class Paths set like described in > https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=61183 . Where do > you need to set a path to the database? I have to set the classpath, because I won't execute macros of a database, which I get by download from anywhere outside. If I start your database with activated macros it will get the classpath for hsqldb.jar itself. The path to database is set to your special home-directory. You could see this on the bottom of the screen (statusbar). You are using the packages of Ubuntu, not of LO directly. Install a parallel-installation of LO directly from LO to test if the behavior will occur there also. I could open the database without any problem. Tested with different versions on my system.
Ubuntu PPAs have repeatedly shown themselves to the be source of numerous problems, and you can not unfortunately simply assume that any given version will work correctly over the top of an existing LibreOffice version, especially if you didn't purge all of the pre-existing LO version files beforehand, AND their dependencies... From what I recall, the LO version included in the distribution links to the jars required for Java functionality, including hsqldb.jar, in a special system-wide way, which I'm guessing overrides part of your user LO configuration profile. As Robert has suggested, the best way to test that this is specific to your environment is to download the independently provided LO DEB packages and install those in parallel to your existing LO version (PPA), or even better, remove the PPA and any dependencies, and just install the LO DEBS with the TDF provided packages (of course, you won't get the same degree of system integration on the desktop)
I tried installing the DEB packages provided on https://www.libreoffice.org/download/download/ , same version 6.4.2.2, and there the split database is working as expected! I'm sorry I reported the bug in the wrong place, I opend a bug report on launchpad: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1872103 Before using the PPA ppa:libreoffice/libreoffice-6-4 , I worked with the split database nearly every day, so it is not a general problem with LO in Ubuntu…
(In reply to Hans from comment #8) > I tried installing the DEB packages provided on > https://www.libreoffice.org/download/download/ , same version 6.4.2.2, and > there the split database is working as expected! So let us close this one as WORKSFORME.