All LibreOffice crashes when I try to open tables in odb file. I can open odb file but when I try to acces tables (clicking in the left menu on the top) all LibreOffice closes with a message about automatic recovering. When I close the dialog the automatic recovering starts. The data base is an mdb file. It worked until the two last versions of Libre Office I installed on Windows 7 Home Premium 64 bits: 5.0.4.2 x64 and 4.5? It works fine with the same files on Windows XP on another computer.
Please attach a simple sample file. Setting to NEEDINFO - once you do set the bug to UNCONFIRMED. Thanks
If odb file includes embedded HSQLDB, you must think about Java part. If you installed LO 64 bits, you must have Java 64 bits (1.6, 1.7, 1.8, whatever) and of course if you installed LO 32 bits, you must have Java 32 bits
Created attachment 122248 [details] odb file that doesn't works
Created attachment 122249 [details] first step
Created attachment 122250 [details] second step
Created attachment 122251 [details] third step
Created attachment 122252 [details] fourth step
I have installed and verified x64 and x32 Java but LibreOffice crashes again. I think the odb file doesn't includes embedded HSQLDB, because I don't know anything about HSQLDB. The data base is an mdb file. Here you are attached the odb file that crashes and all the steps I do and the screen shots (in catalan). Automatic translation of the screen shots: Step2: Document Recovery for LibreOffice. Due to an unexpected error, LibreOffice has failed. All files that are saved was working. The next time you restart LibreOffice, the files will be recovered automatically. Step3: Select "Start Recovery" to start the process in the documents listed below. Select "Discard the data recovery" to abort attempts to recover these documents. The "Status" column indicates whether documents can be retrieved. It is recovering the document. Step4: The recovery of documents is complete. Select "Finish" to see the documents. It is recovering the document: State of retrieved documents:
For the test, could you rename your LO directory profile (see https://wiki.documentfoundation.org/UserProfile#Windows) and give a new try?
Julien, thanks but doesn't works
Thank you for your feedback. Since I don't have more questions, let's put it back to UNCONFIRMED.
Hello, tested with LO 5.2master, win7 and it crashes with your file. But I have not .mdb file available. I see two bugs here: - crash when accessing mdb file (your original bug). To verify this, please attach .mdb file for testing. - crash when .mdb file is not available Please attach .mdb file for testing.
Errors: The connection to the data source "Diapositives_libre_office" could not be established. SQL Status: 3024 Error code: -2147467259 Unable to find file C:\temp\DIAPOSITIVES.mdb.
needinfo while waiting for file.
Created attachment 123068 [details] mdb file Data source "Diapositives_libre_office.mdb" attached
Crashes. Win 7 Pro 64-bit, Version: 5.1.0.3 (x64) Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Locale: fi-FI (fi_FI)
I can display the list of tables and table contents without any problem in win32-5.2 bibisect repo, version 2016-06-23 or source-hash 49c2b98 (2015-11-25) on Widows Vista 32-bit with MS Access 2003.
Abstract: crashes - in my PC with Windows 7 Home Premium 64 bits and LibreOffice 5.0.4.2 x64 - in LO 5.2master, win7 (raal), without .mdb file - in Win 7 Pro 64-bit, Version: 5.1.0.3 (x64) (Buovjaga), with .mdb file didn't crashes - in my PC with Windows 7 Home Premium 64 bits and with LibreOffice <4.5 don't crashes - in my laptop with Windows XP and LibreOffice 5.0.2.2 - in win32-5.2 bibisect repo, version 2016-06-23 or source-hash 49c2b98 (2015-11-25) on Widows Vista 32-bit with MS Access 2003 (Terrence Enger), with .mdb file Does anyone have any idea about the solution?
5.1.4 still crashes, but 5.3 does not. However, 5.3 does not show me any tables. It does show the .mdb as loaded in the status bar. Would be interesting, if original reporter tested with the latest: http://dev-builds.libreoffice.org/daily/master/Win-x86@42/current/ Win 7 Pro 64-bit Version: 5.3.0.0.alpha0+ Build ID: 28ac6fdc11559b58ac62089300aa99530b0b822d CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2016-07-18_02:54:20 Locale: fi-FI (fi_FI); Calc: CL Win 7 Pro 64-bit, Version: 5.1.3.2 (x64) Build ID: 644e4637d1d8544fd9f56425bd6cec110e49301b CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Locale: fi-FI (fi_FI)
(In reply to Buovjaga from comment #19) > 5.1.4 still crashes, but 5.3 does not. However, 5.3 does not show me any > tables. I got hit by bug 100964
I guess this can be bibisected with this repository: http://dev-downloads.libreoffice.org/bibisect/win/bibisect_win_44.tar.xz. Adding keyword 'bibisectRequest'.
*** Bug 103213 has been marked as a duplicate of this bug. ***
Alex, in my view, bug 97395 is not „a duplicate“ of bug 103213 but only similar. In bug 97395, for example, „5.1.4 still crashes, but 5.3 does not“ – it depends on version. number (within 5). In bug 103213, x64 crushes and x32 does not – it depends on bit (within 5).
In another bug (103217 – „PDF export of Unicode characters does not work with hexadecimal code more than four digits“) I downloaded today both current daily build of master – „master~2016-11-08_06.11.45_LibreOfficeDev_5.3.0.0.alpha1_Win_x86.msi“ and „master~2016-11-07_13.03.37_LibreOfficeDev_5.3.0.0.alpha1_Win_x64_en-US_de_ar_ja_ru_qtz.msi“ – and installed/deinstalled them. Result: The x64-version crushes and the x32-version does not – it depends still on bit (within 5).
i can't reproduce the crash in Versión: 5.3.3.2 Id. de compilación: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448 Subproc. CPU: 1; SO: Windows 6.1; Repr. de IU: predet.; Motor de trazado: HarfBuzz; Configuración regional: es-ES (es_ES); Calc: group and table are seen when clicking on 'Tables' Closing as RESOLVED WORKSFORME
Xisco, it’s not recognizable which version you have used: x32 or x64? With the 5.3.4.1(x64)-Version the bug still exists! Status: REOPENED
(In reply to Dirk W. from comment #26) > Xisco, it’s not recognizable which version you have used: x32 or x64? > > With the 5.3.4.1(x64)-Version the bug still exists! > > Status: REOPENED I've tested it on a VM Win 7 x86. it looks it just happening in x64 then...
Xisco, the „Win 7 x86“ is a 32bit-version, so your LO-version is also a 32bit-version resp. 5.3.3.2 (x32). In the 32bit-version of LO the bug doesn’t emerge since 5.0, but in all x64-versions of 5.x.x.x until today the bug still exists!
Hi Dirk, Thanks for the clarification! The bug's hardware field was set to 'All' so I thought it was reproducible in all architectures. Updated accordingly now.
Now it cannot establish connection to the .mdb. "May be the necessary data provider is not installed". No such problem in my previous tests.. do I need Access now?? Win 7 Pro 64-bit Version: 6.0.0.0.alpha0+ (x64) Build ID: a1ace08b5b86a76e7275dcef2545a7d52ae2ed2d CPU threads: 4; OS: Windows 6.1; UI render: default; TinderBox: Win-x86_64@42, Branch:master, Time: 2017-06-13_03:04:47 Locale: fi-FI (fi_FI); Calc: CL
(In reply to Buovjaga from comment #30) > Now it cannot establish connection to the .mdb. "May be the necessary data > provider is not installed". No such problem in my previous tests.. do I need > Access now?? > ... See https://bugs.documentfoundation.org/show_bug.cgi?id=97579#c10 and https://bugs.documentfoundation.org/show_bug.cgi?id=97579#c16 (I put this tracker in See also)
I have used LO Base for the last 2 years, with Debian 8 Jessie/Cinnamon OS on a 32bit laptop computer. After upgrading to Debian 9 Stretch/Cinnamon, my databases crash as soon as I try to open Tables (Forms, etc seem to be OK.) I cannot access the tables at all.
DocTom: are your files related to mdb? If not, this bugtracker doesn't apply to your case.
(In reply to DocTom from comment #32) > I have used LO Base for the last 2 years, with Debian 8 Jessie/Cinnamon OS > on a 32bit laptop computer. > > After upgrading to Debian 9 Stretch/Cinnamon, my databases crash as soon as > I try to open Tables (Forms, etc seem to be OK.) I cannot access the tables > at all. @DocTom : as Julian has mentioned, unless your problem relates to MDB databases, you are probably reporting in the wrong bug report. At a guess, since you mention 32bit and update to Debian 9, you are suffering from bug 108619
LibreOffice on Windows relies on the database driver components provided by Microsoft. Microsoft no longer provides for reading/writing to a 32bit Access db (versions created with Access 97, 2003) on its 64bit systems. There is information about this on both MSND, and Microsoft's own knowledgebase websites. I suggest closing this, and other similar reports as either WONTFIX, or NOTOURBUG, or else WFM in 64bit everything and Access >= 2010.
*** Bug 114431 has been marked as a duplicate of this bug. ***
Now I have no problem with the odb and mdb. Based on this experience and comment 35, closing as WFM. Version: 6.1.0.0.alpha1+ Build ID: 23c5125148a8110d88385b29570bf0b7d4400458 CPU threads: 4; OS: Windows 10.0; UI render: default; TinderBox: Win-x86@42, Branch:master, Time: 2018-05-12_00:15:25 Locale: fi-FI (fi_FI); Calc: group