Description: After deleting a Firebird file that was connected to a Base database, the file is recreated when the Base document is opened again. Steps to Reproduce: To test this issue, it is needed an external Firebird database, so we will create a Firebird external database file (it is not needed to have Firebird server installed) 1. Open Base 2. Select Connect to an existing database 3. In the dropdown list, select Firebird external. Click Next 4. Click on Create new button 5. In the Save as dialog, choose a suitable place and give a name to the Firebird database file, for example Test1.fdb. Click on Save, then Click Next 6. In the Setup the user authentication step, do not change anything. Click Next 7. In the Save and proceed step, click on No, do not register the database (it is not needed register). 8. Click on Finish. 9. Give a name to the Base .odb file, for example Test2.odb Once the database file has been created, to see the issue: 1. Close Base 2. Delete the Firebird file Test1.fdb 3. Open the Base file Test2.odb 4. Go to the Tables area 5. Observe that has been created a new Firebird file called Test1.fdb in the original place where the old .fdb file was deleted Moreover: 6. Open Test2.odb 7. Go to menu Edit > Database > Properties 8. In General section, it is shown the path of the firebird file. Change the name of the file to other different, for example Test3.fdb 9. Close Database Properties dialog 10. Go to any other different area but Tables, return to the Tables area 11. A new Firebird file named Test3.fdb has been created, although Test1.fdb hadn't been deleted Actual Results: A new file is created when reopen Base Expected Results: No file would be created Reproducible: Always User Profile Reset: No Additional Info: The issue was NOT present in LibreOffice 7.1.6.2 version The issue begins in LibreOffice 7.1.7.1
Error tested and is present in: Version: 7.1.7.1 (x64) / LibreOffice Community Build ID: b7e169ea97ed281a064d4e488fa1bb29cb906303 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL Also present in: Version: 7.4.2.3 / LibreOffice Community Build ID: 40(Build:3) CPU threads: 1; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: es-ES (es_ES.UTF-8); UI: es-ES 7.4.2-2 Calc: threaded ---------- NO ERROR in: Version: 7.1.6.2 (x64) / LibreOffice Community Build ID: 0e133318fcee89abacd6a7d077e292f1145735c3 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL
Get the same behavior with Version: 7.0.5.2 Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded also Version: 6.1.5.2 Older versions I installed won't open any external Firebird file. All versions up to LO 7.4.3.1 will create an empty Firebird file if the file doesn't exist. In Linux it seems to be a (buggy) behavior since external Firebird file with direct connection works. I would prefer to give a message: File couldn't be found. Should a new file be created?
(In reply to Robert Großkopf from comment #2) > All versions up to LO 7.4.3.1 will create an empty Firebird file if the file > doesn't exist. Maybe you are right, I misunderstood the message when I tested with version 7.1.6.2 and earlier
I seem to remember that the code was deliberately modified to create a Firebird fdb file if one didn't exist when the ODB file was initially setup. Seems like the case where someone deletes the FDB file at a later date wasn't taken into account.
Dear jcsanz, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still the same buggy behavior in Version: 25.2.3.1 (X86_64) / LibreOffice Community Build ID: d8d1af5f77df955194e52baabe19324532ac8e8b CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded