Description: opening an old database (via sqlite-Backend) crashes immediately when opening tables or views, I already tried to switch installed java version to no avail, opening the databasse with an windows LO 5.8.1 works without any problems. Steps to Reproduce: 1. Open data base 2. Open view or tables 3. Actual Results: LO crashes and offers to restore database Expected Results: Database should open as it does when opened from Windows version Reproducible: Always User Profile Reset: Yes Additional Info: Version: 25.8.1.1 (X86_64) Build ID: 54047653041915e595ad4e45cccea684809c77b5 CPU threads: 2; OS: Linux 6.16; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded nvidia driver all 550.163.01-3
Can you provide an example database for testing? When was the last time this worked on Linux for you? Note for testers: https://wiki.documentfoundation.org/Documentation/HowTo/Base/Connect_to_SQLite What kind of a setup did you use for connecting?
Created attachment 202918 [details] sample database that uses sqlite3
Created attachment 202919 [details] /etc/odbc.ini this is the file that installs the user odbc access
this is an sample database that crashes also base, with a ODBC sqlite3 database (not provided, any sqlite3 database will do)
The last time it worked for me was I believe in August, when I used 25.8.0.4, or even before when using 25.2.5.2 (before August 22th) , and nvidia was 550.163.01-2 or before 2025-07-24 it was 550.163.01-1
or, if unixodbc is culprit, before 2025-09-04 i used 2.3.12-2, and then 2.3.12-2+b1, and August 20 libsqliteodbc changed from 0.99991-2 to 0.99991-2+b1 and on September 09 to 0.99991-3
(In reply to Heinz Repp from comment #2) > Created attachment 202918 [details] > sample database that uses sqlite3 Where is the sqlite file that this is supposed to connect to ? All you have provided with the ODB file is the indication of how the connection is supposed to happen, i.e. over ODBC, but the ODB file doesn't contain the sqlite3 db (it isn't embedded). It also doesn't specify which ODBC driver version you are using. =>> NEEDINFO
For example, your ODBC.ini file points to: Database = /home/h1/Dokumente/Daten/Fx-downloadhistory.sqlite We need that file to test whether: (1) a connection can be established via ODBC with an appropriate driver, yet to be named ; (2) a connection can be established using some other driver, e.g. JDBC, direct SQLite driver (SDBC), etc
Created attachment 202933 [details] this is the file that should be opened
Created attachment 202934 [details] and this is the file defining the possible sources
the odbc version that I use is 2.3.12-2+b1, the current version in debian testing.