I have tried to transfer my working database from my old win 10 laptop to a new win 11 laptop.
I first copied over data using %appdata% [using copy/paste via usb ]to new laptop.
I then installed latest version of libreoffice on to the new laptop, then tried to access one of the backup files in appdata, but all though the forms and queries are all there, the tables were blank.
I then tried to copy the old database files that i found in the user directory to the new pc, but again all I got is blank tables.
Which database did you use? If you have used internal databases the data are saved inside the *.odb-file.
Open such a file and have a look at the bottom of the file in status bar. For an embedded database you could read
Embedded Database → Embedded HSQLDB
or
Embedded Database → Firebird (embedded)
They are Firebird (embedded)
It it’s embedded all data will be inside the Base file.
Only working with Linux here since 25 years. Might be the files are protected for writing an executing when copying from on system to another by the system. Have a look if the files are writable.
Is your laptop still running win10? Can you open the files there? Data will show? This is only to check, if your data was really available before transfer.
.
… is an unusual place for your user-files to save. I would expect them to be below Documents for your user-name.
.
To inspect contents: all odb-files are essentially zip-files, so create a copy and rename it to something like xx.zip or xx.odb.zip, then check the contents of the archive.
.
Did you use a 25.x version of LO on Windows10 ?
Thanks for your suggestions,
1 yes the files are writeable ( although win 11 did originally make them protected)
2 yes the data was ready to be transferred.
3. I used appdata because someone on redit suggested it, it’s where the backups are kept. But I also tried with the real files from the normal documents files.
But I have now found the cause of the problem, but not the solution.
for some reason when I first made the database I made it FIREBIRD embedded. It appears I can transfer HSQLDB embedded but not FIREBIRD
Its not a solution but I’m opening this as a new query.
the problem is not transfering the database but -
How to do you open a firebird embedded Database in LO 25.8
The database opened no problem in LO 6.4
I still have a woking copy on a Win 10 laptop( with LO6.4 ) but would like to use it on a Win 11 laptop with LO 25.8
I remember some problems with newer versions of firebase, but I thought the tables were visible. @RobertG may remember more.
.
One way would be a SQL-dump or similiar of your data, then re-import on the new system. I assume you would have the same problems with an updated LO on your Win10.
so we continue here:
Might be there have been problems when changing from the first Firebird 2.5-version to the current used 3.0-version. But changing had happen with LO 5.3. It has been running with LO 6.4 so there wouldn’t be this problem.
Have had such a problem with external databases and Firebird. If you set Firebird to use a collation for the whole database with this command: ALTER CHARACTER SET UTF8 SET DEFAULT COLLATION UNICODE the whole content wouldn’t be shown any more with LO 24.8 and newer. See Bug 168959, a horrible bug, but not confirmed. Have created such a database and the user of this database has to run older LO-version, because newer versions won’t show any data.
I would try a installation of the latest LO 24.2 (Index of /libreoffice/old/24.2.7.2/win)
The bug-report i found (and linked in the other thread) would be between 7.1 and 7.2
I’ll try to check out your test-database, but maybe read the following thread on firebird. If it fixes your problem it may be dependent on your distribution for linux.
The bug first appears for other users with Windows. We have installed a newer version of LibreOffice and all tables have been gone.
It might be a problem with Linux and LibreOffice packed by Linux, because they are often packing separate Firebird drivers. I only use the original from LibreOffice, which supports all for Firebird and won’t need any part of Linux-Firebird-installation.
The bug with the empty tables will appear on the same system: I have installed about 40 LibreOffice-version parallel. Could create the Firebird database with an old version, send the command for collation, create a table … Then I close this connection and open it wit LO 24.8 and the table isn’t there.
As I assume cou don’t have them in a container but “real” installs, this should rule out the simple solution to just install icu-devtools
Icu is already installed. icu-devtools aren’t available for OpenSUSE.
Note: The bug first detected on Windows - had to go back to older version to see the data. Then created a new database here with LO 7.4.7.2. Works well. Opened it with with LO 24.8 or newer - no tables.
The bug I reported appears with the same version another bug for collation had been fixed: 162115 – Charset/collation data is missing in embedded Firebird