https://bugs.kde.org/show_bug.cgi?id=524590
--- Comment #4 from [email protected] <[email protected]> --- == Summary == After upgrading to Ubuntu 24.04 LTS, users face a blocker when using the Flatpak package to open SQLCipher-based databases, forcing a fallback to the native system package (v2.31.0) which suffers from regional formatting regressions (parentheses instead of negative signs). == Environment == * '''OS:''' Ubuntu 24.04 LTS (Noble Numbat) * '''Skrooge versions tested:''' ** System package: 2.31.0 (Qt5 / KF5) ** Flatpak package: Latest Flathub release (Qt6 / KF6) == Detailed Issue Breakdown == === 1. Flatpak Runtime Failure (Blocker) === When opening an existing encrypted/SQLCipher-backed {{ic|.skg}} file using Flathub's package, the sandbox fails to load the SQLCipher plugin: <pre> WARNING: QSqlDatabase: can not load requested driver 'SKGSQLCIPHER', available drivers: SKGSQLCIPHER QSQLITE [ERR-10000]: Driver not loaded Driver not loaded [ERR-12]: Bad password </pre> * '''Root cause:''' The Flatpak build misses required SQLCipher shared libraries or plugin bindings inside its runtime sandbox. === 2. Native System Package Regressions (v2.31.0) === As a workaround, installing the native Ubuntu {{ic|.deb}} package alongside {{ic|libsqlcipher1}} opens the document successfully, but introduces visual formatting regressions: * Negative amounts display as '''(100.00 €)''' instead of '''-100.00 €'''. * System environment overrides (such as {{ic|LC_MONETARY=fr_FR.UTF-8}}) fail to restore the negative sign format. == Status Summary Table == {| class="wikitable" border="1" cellpadding="5" cellspacing="0" |- style="background-color:#f2f2f2;" ! Distribution / Package !! App Version !! File Opening (SQLCipher) !! Debit Format !! Current Status |- | '''Native Ubuntu (.deb)''' || 2.31.0 (Qt5) || {{YES}} Functional (requires {{ic|libsqlcipher1}}) || {{NO}} Uses parentheses: {{ic|(100 €)}} || Workaround in use |- | '''Flathub (Flatpak)''' || 2.50+ (Qt6) || {{NO}} Failed (missing {{ic|SKGSQLCIPHER}} driver) || {{YES}} Proper minus sign: {{ic|-100 €}} || Blocked by driver issue |} == Steps to Reproduce (Flatpak Issue) == # Install Skrooge via Flatpak: {{ic|flatpak install flathub org.kde.skrooge}} # Launch an existing {{ic|.skg}} file: {{ic|flatpak run org.kde.skrooge /path/to/file.skg}} # Observe the {{ic|SKGSQLCIPHER}} driver load failure dialog and inability to open the document. == Expected Result == The Flatpak bundle should include all necessary SQLCipher runtime libraries to open encrypted databases out-of-the-box on modern Linux distributions. -- You are receiving this mail because: You are watching all bug changes.
