FS#18373 - [openoffice-base] 3.2.0-1 breaks existing database files
Attached to Project:
Arch Linux
Opened by Ross Melin (rdmelin) - Wednesday, 17 February 2010, 16:20 GMT
Last edited by Andreas Radke (AndyRTR) - Saturday, 12 June 2010, 08:52 GMT
Opened by Ross Melin (rdmelin) - Wednesday, 17 February 2010, 16:20 GMT
Last edited by Andreas Radke (AndyRTR) - Saturday, 12 June 2010, 08:52 GMT
|
Details
Description:If I open an existing openoffice "base" database
file created with an earlier version of openoffice, and then
close it, when I open it a second time I get this error
message:
SQL Status: HY000 The connection could not be established. The database was created by a newer version of OpenOffice.org. Additional info: * package version(s) openoffice-base 3.2.0-1 go-openoffice 3.2.0.5-1 also affected hsqldb-java 1.8.1.1-1 * config and/or log files etc. removing existing user configs does not resolve this issue Steps to reproduce: Open an existing .odb file. DO NOT USE A FILE YOU WILL NEED TO ACCESS IN THE FUTURE. An example file used in a tutorial on the oooforums can be downloaded for testing from this url: http://www.paintedfrogceramics.com/OpenOffice/employees/employees.odb It is not necessary to edit or save the file, simply close it and reopen it. Then try to view a table, run a query, open a form or any action that requires reading the data. The above error message will be displayed. THIS BUG WILL EAT YOUR DATA FOR BREAKFAST AND YOUR BACKUPS FOR LUNCH! |
This task depends upon
Regarding the Severity change to High, I'm not sure that a bug which prevents your system from booting or allows an intruder is more severe than one which damages every file it touches. I would gladly reinstall from scratch and still have my database intact, thank you.
I can also reproduce this bug in go-openoffice-3.2.0.5-1 and hsqldb-java-1.8.1.1-1
The problem is that the file "database/properties" (inside employees.odb) is writed with incorrect version number:
...
version=1.8.1 <<<<<< bad, should be 1.8.0 >>>>>>
hsqldb.cache_version=1.7.0
hsqldb.original_version=1.8.0
hsqldb.compatible_version=1.8.0
changing this fixed the document ;)
Thank you for posting the fix for affected files!
Yes, this hack helps.
* Maybe openoffice and go-openoffice should be recompiled.
* Maybe something is wrong in new hsqldb-java.
I don't know much about these software.
It seems that every time the file is closed (and thus saved), it changes the values *back* to 1.8.1, which prevents it from being opened again.
Running unzip, grep, zip every time I need to open the file kind of defeats the purpose of using ooBase.
Any idea on a fix schedule (even a rough one)?
>>The problem is that the file "database/properties" (inside employees.odb) is writed with incorrect version number
thnx! this is a bad way, but it works!
That means it is NOT a upstream bug. It probably just needs to be recompiled.
-- Stephen
Please look for an existing bug or file a new one. hsqldb update 1.8.1.2 is also pending.
Maybe this is just an issue of our rolling release system?
-> reopen soffice-beta, loading the saved database -> same sql error
openoffice-base-beta 3.2.1_ooo320_m17-1
so: Yes, there seems to be something left to do :)
... and compiled it this way:
$ ./configure --prefix=/usr/local/ooo --with-package-format=native --with-mingwin=/usr/bin/i486-mingw32-g++ --with-system-mozilla --with-openldap
$ make -j
this seems to work fine with the hsqldb 1.8.1 package... it is using version 1.8.0 internally without screwing up the database files
It's not a directory, and my attempt to find info as to its format has failed.
Please help. Thanks in advance.