Bug 499908 - Fail to open .kmy file. Similar to bug 400684 but the fixes there are already implemented
Summary: Fail to open .kmy file. Similar to bug 400684 but the fixes there are already...
Status: RESOLVED WORKSFORME
Alias: None
Product: kmymoney
Classification: Applications
Component: database (other bugs)
Version First Reported In: 5.1.3
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-02-12 18:26 UTC by pizzafarmer
Modified: 2025-03-16 03:47 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments
attachment-3454966-0.html (12.96 KB, text/html)
2025-02-12 21:08 UTC, pizzafarmer
Details
attachment-3722962-0.html (2.63 KB, text/html)
2025-02-14 01:51 UTC, pizzafarmer
Details

Note You need to log in before you can comment on or make changes to this bug.
Description pizzafarmer 2025-02-12 18:26:21 UTC
SUMMARY


STEPS TO REPRODUCE
1.  Open kmymoney as usual
2.  Attempt to open a different .kmy file
3. 

OBSERVED RESULT
Get the following error message:
Could not read your data source. Please check the KMyMoney settings that the necessary plugin is enabled.

EXPECTED RESULT
Should have opened the file like it did this morning.

SOFTWARE/OS VERSIONS
Windows: 
macOS: 
(available in the Info Center app, or by running `kinfo` in a terminal window)
Linux/KDE Plasma: Ubuntu 24.04
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION
Comment 1 Jack 2025-02-12 18:41:32 UTC
For completeness, pleas provide the Qt and KDE versions.  Are you running Xorg or Wayland (it shouldn't matter here, but one never knows.)
You say it worked this morning, but not now.  What changed?  Please don't say nothing changed.  What packages got upgraded?  Did you do any maintenance on the database (assuming you are using a database from the bug headers.)
What type of database are you using?  Can you access the database directly with sql?
If you look at the KMM Configuration dialog, plugins page, is there an SQL Storage plugin listed and enabled?
Can you run KMyMoney from command line and see if there is any useful message output.
Comment 2 pizzafarmer 2025-02-12 21:08:25 UTC
Created attachment 178231 [details]
attachment-3454966-0.html

 KDE Plasma version = 5.27.12KDE Frameworks version = 5.115.0QT version = 5.15.13
Kernel version = 6.8.0-52-generic (64 bit)Graphics Platform = X11
This happened within a 5 minute time frame. I was in the process of building a new database and have been using that file for about a month. I was setting up some payees, but couldn't remember what categories I had originally set up for them, so I opened my old database file, made some notes, and then went to open my new file. That's when I got the error.
The SQL plugin is listed.
I guess I'm too much of an SQL newb to access the file directly.
I started from the command line, printout here:


$ kmymoney Personal7.kmyWebConnect: Try to connect to WebConnect serverWebConnect: Connect to server failedWebConnect: Running in server modeFound html dir(s): ("/usr/share/kmymoney//html/")Found an 'html' folder with CSS files: "/usr/share/kmymoney//html/"System icon theme as reported by QT:  "Yaru"QPainter::begin: Paint device returned engine == 0, type: 2QPainter::begin: Paint device returned engine == 0, type: 2kf.xmlgui: Shortcut for action  "transaction_new" "New" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.kf.xmlgui: Shortcut for action  "transaction_assign_number" "Assign next number" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.kf.xmlgui: Shortcut for action  "transaction_mark_toggle" "Toggle" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.kf.xmlgui: Shortcut for action  "transaction_mark_cleared" "Cleared" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.kf.xmlgui: Shortcut for action  "transaction_mark_reconciled" "Reconciled" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.kf.xmlgui: Shortcut for action  "transaction_select_all" "Select all" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.kf.xmlgui: Shortcut for action  "edit_find_transaction" "Find transaction..." set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.kf.xmlgui: Shortcut for action  "view_show_transaction_detail" "Show Transaction Detail" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.kf.xmlgui: Shortcut for action  "view_hide_reconciled_transactions" "Hide reconciled transactions" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.kf.xmlgui: Shortcut for action  "view_hide_unused_categories" "Hide unused categories" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.kf.xmlgui: Shortcut for action  "view_show_all_accounts" "Show all accounts" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.kf.xmlgui: Shortcut for action  "account_reconcile" "Reconcile..." set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kbanking.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/xmlstorage.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_checkprinting.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/qifexporter.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/budgetview.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/icalendarexporter.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/forecastview.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/onlinejoboutboxview.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_forecastview.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/reportsview.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/konlinetasks_sepa.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_csvimporter.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_qif.so" Validity falseLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/ofximporter.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/reconciliationreport.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_icalendarexporter.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_reportsview.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/csvimporter.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/qifimporter.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_xmlstorage.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/csvexporter.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/gncimporter.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/sqlstorage.so" Validity trueLocated plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/checkprinting.so" Validity trueLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/budgetview.so"Plugins: budgetview loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/checkprinting.so"Plugins: checkprinting loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/csvexporter.so"Plugins: csvexporter loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/csvimporter.so"Plugins: csvimporter loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/forecastview.so"Plugins: forecastview loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/gncimporter.so"Plugins: gncimporter loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/icalendarexporter.so"Plugins: icalendarexporter loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kbanking.so""Plugins: kbanking loaded, build with (5.10.2stable-0/6.5.4.0stable), run with (5.10.2.0/6.5.4.0)"3:2025/02/12 14-44-13:(null)(22708):banking_update.c:  610: No AqBanking config folder found at [/home/jack/.aqbanking/settings6/users] (-1)3:2025/02/12 14-44-13:(null)(22708):banking_update.c:  610: No AqBanking config folder found at [/home/jack/.aqbanking/settings/users] (-1)3:2025/02/12 14-44-13:(null)(22708):banking_update.c:  411: There is no old settings folder, need initial setup7:2025-02-12 14:44:13:aqbanking startedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/ofximporter.so"Plugins: ofximporter loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/onlinejoboutboxview.so"Plugins: onlinejoboutboxview loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/qifexporter.so"Plugins: qifexporter loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/qifimporter.so"Plugins: qifimporter loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/reconciliationreport.so"Plugins: reconciliation report loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/reportsview.so"Plugins: reportsview loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/sqlstorage.so"Plugins: sqlstorage loadedLoading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/xmlstorage.so"Plugins: xmlstorage loadedFound html dir(s): ("/usr/share/kmymoney//html/")Found an 'html' folder with CSS files: "/usr/share/kmymoney//html/"

It stops at this point. When the old file is loaded, these additional outputs are received:
start parsing filestartDocumentreading securitiesendDocumentCost center model created with items 0Payees model created with items 0

I'm thinking more along the lines of a corrupted database.


    On Wednesday, February 12, 2025 at 12:41:35 PM CST, Jack <bugzilla_noreply@kde.org> wrote:  
 
 https://bugs.kde.org/show_bug.cgi?id=499908

Jack <ostroffjh@users.sourceforge.net> changed:

          What    |Removed                    |Added
----------------------------------------------------------------------------
          Platform|Other                      |Ubuntu
            Status|REPORTED                    |NEEDSINFO
        Resolution|---                        |WAITINGFORINFO
          Severity|major                      |normal

--- Comment #1 from Jack <ostroffjh@users.sourceforge.net> ---
For completeness, pleas provide the Qt and KDE versions.  Are you running Xorg
or Wayland (it shouldn't matter here, but one never knows.)
You say it worked this morning, but not now.  What changed?  Please don't say
nothing changed.  What packages got upgraded?  Did you do any maintenance on
the database (assuming you are using a database from the bug headers.)
What type of database are you using?  Can you access the database directly with
sql?
If you look at the KMM Configuration dialog, plugins page, is there an SQL
Storage plugin listed and enabled?
Can you run KMyMoney from command line and see if there is any useful message
output.
Comment 3 Jack 2025-02-13 21:35:39 UTC
Thanks for the additional info.  First thing - please do not send HTML messages to any bug system.  The system deals with plain text only, and the HTML ends up as an unnecessary attachment.  Also, when replying to a bug by email, please remove everything except your response.  Your entire message becomes the next comment in the bug, and extra copies of previous comments just make it harder to follow.

Those last lines (please check your copy/paste, as there seem to be missing line breaks, or perhaps that is because of the HTML) seem to show that KMyMoney does load the sqlstorage plugin, and then reads the data from the database with no errors, but didn't find any actual data - at least no payees and no transactions.  However, if there is a popup "Could not read your data source." then I'm not sure why the console output didn't contain any evidence of an error.  So - as far as the database system is concerned, there does not appear to be any error, but the content is clearly not a full/complete/valid KMyMoney database.

What type of database are you using?  Different databases have different methods of access. (Postgresql, MySql, Sqlite, ...)    Also, I'm curious why you chose to use a database back end instead of the usual XML storage (compressed by default, with optional encryption) especially if you have limited experience using SQL.
Comment 4 Jack 2025-02-13 21:43:29 UTC
Actually rereading the other bug you mentioned, I need to ask where you got the version of KMM you are running.  Is it the default/stock version from Ubuntu, or did you compile it yourself?  It makes a difference in terms of further troubleshooting.
Comment 5 pizzafarmer 2025-02-14 01:51:42 UTC
Created attachment 178334 [details]
attachment-3722962-0.html

Installed from the Ubuntu repositories.

Yahoo Mail: Search, Organize, Conquer 
 
  On Thu, Feb 13, 2025 at 3:43 PM, Jack<bugzilla_noreply@kde.org> wrote:   https://bugs.kde.org/show_bug.cgi?id=499908

Jack <ostroffjh@users.sourceforge.net> changed:

          What    |Removed                    |Added
----------------------------------------------------------------------------
                CC|                            |ostroffjh@users.sourceforge
                  |                            |.net

--- Comment #4 from Jack <ostroffjh@users.sourceforge.net> ---
Actually rereading the other bug you mentioned, I need to ask where you got the
version of KMM you are running.  Is it the default/stock version from Ubuntu,
or did you compile it yourself?  It makes a difference in terms of further
troubleshooting.
Comment 6 Jack 2025-02-14 03:56:27 UTC
First, as I asked previously, when you reply to a bug email, please do not send HTML messages.  Also, do NOT include what you are replying to.  If you look at this bug online, you should see what I'm talking about.
Also, please let us know which specific database you are using,
Thanks for helping us help you.
Comment 7 Thomas Baumgart 2025-02-14 09:15:04 UTC
What is the output of the following command when run on the command line:

file Personal7.kmy
Comment 8 pizzafarmer 2025-02-14 13:51:30 UTC
Sorry about the html mail. I replied to a later message before I saw your note.

Here's the response after running from the command line in plain text:

$ kmymoney Personal7.kmy
WebConnect: Try to connect to WebConnect server
WebConnect: Connect to server failed
WebConnect: Running in server mode
Found html dir(s): ("/usr/share/kmymoney//html/")
Found an 'html' folder with CSS files: "/usr/share/kmymoney//html/"
System icon theme as reported by QT:  "Yaru"
QPainter::begin: Paint device returned engine == 0, type: 2
QPainter::begin: Paint device returned engine == 0, type: 2
kf.xmlgui: Shortcut for action  "transaction_new" "New" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action  "transaction_assign_number" "Assign next number" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action  "transaction_mark_toggle" "Toggle" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action  "transaction_mark_cleared" "Cleared" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action  "transaction_mark_reconciled" "Reconciled" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action  "transaction_select_all" "Select all" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action  "edit_find_transaction" "Find transaction..." set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action  "view_show_transaction_detail" "Show Transaction Detail" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action  "view_hide_reconciled_transactions" "Hide reconciled transactions" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action  "view_hide_unused_categories" "Hide unused categories" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action  "view_show_all_accounts" "Show all accounts" set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action  "account_reconcile" "Reconcile..." set with QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s) instead.
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kbanking.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/xmlstorage.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_checkprinting.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/qifexporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/budgetview.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/icalendarexporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/forecastview.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/onlinejoboutboxview.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_forecastview.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/reportsview.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/konlinetasks_sepa.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_csvimporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_qif.so" Validity false
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/ofximporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/reconciliationreport.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_icalendarexporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_reportsview.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/csvimporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/qifimporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_xmlstorage.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/csvexporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/gncimporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/sqlstorage.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/checkprinting.so" Validity true
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/budgetview.so"
Plugins: budgetview loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/checkprinting.so"
Plugins: checkprinting loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/csvexporter.so"
Plugins: csvexporter loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/csvimporter.so"
Plugins: csvimporter loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/forecastview.so"
Plugins: forecastview loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/gncimporter.so"
Plugins: gncimporter loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/icalendarexporter.so"
Plugins: icalendarexporter loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kbanking.so"
"Plugins: kbanking loaded, build with (5.10.2stable-0/6.5.4.0stable), run with (5.10.2.0/6.5.4.0)"
3:2025/02/12 14-44-13:(null)(22708):banking_update.c:  610: No AqBanking config folder found at [/home/jack/.aqbanking/settings6/users] (-1)
3:2025/02/12 14-44-13:(null)(22708):banking_update.c:  610: No AqBanking config folder found at [/home/jack/.aqbanking/settings/users] (-1)
3:2025/02/12 14-44-13:(null)(22708):banking_update.c:  411: There is no old settings folder, need initial setup
7:2025-02-12 14:44:13:aqbanking started
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/ofximporter.so"
Plugins: ofximporter loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/onlinejoboutboxview.so"
Plugins: onlinejoboutboxview loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/qifexporter.so"
Plugins: qifexporter loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/qifimporter.so"
Plugins: qifimporter loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/reconciliationreport.so"
Plugins: reconciliation report loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/reportsview.so"
Plugins: reportsview loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/sqlstorage.so"
Plugins: sqlstorage loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/xmlstorage.so"
Plugins: xmlstorage loaded
Found html dir(s): ("/usr/share/kmymoney//html/")
Found an 'html' folder with CSS files: "/usr/share/kmymoney//html/"

It appears that I failed to attach this from the syslog:

2025-02-12T15:00:07.221906-06:00 Linux4 systemd[2758]: Started snap.firmware-updater.firmware-notifier.service - Service for snap application firmware-updater.firmware-notifier.
2025-02-12T15:00:07.372757-06:00 Linux4 kernel: audit: type=1400 audit(1739394007.371:299): apparmor="DENIED" operation="open" class="file" profile="snap.firmware-updater.firmware-notifier" name="/proc/sys/vm/max_map_count" pid=23103 comm="firmware-notifi" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
2025-02-12T15:00:26.524300-06:00 Linux4 metacity[3309]: Invalid WM_TRANSIENT_FOR window 0x7e00008 specified for 0x7e00006 (KMyMoney).
2025-02-12T15:00:27.464901-06:00 Linux4 metacity[3309]: Invalid WM_TRANSIENT_FOR window 0x7e00010 specified for 0x7e00012 (Error — KMyMoney).


Why did I decide to use SQL? You don't learn about new things unless you try them.
Comment 9 pizzafarmer 2025-02-14 13:53:30 UTC
$ file Personal7.kmy
Personal7.kmy: SQLite 3.x database, last written using SQLite version 3044002, file counter 198, database pages 67, cookie 0x19, schema 4, UTF-8, version-valid-for 198
Comment 10 Jack 2025-02-14 16:19:27 UTC
I was initially going to suggest that there might be a problem with naming an sqlite file with a .kmy extension, but I just tried it and  didn't have any problem at all.  What version of sqlcipher and sqlite are you using?  You can look for a package named sqlitebrowser which is a gui interface which should be easy enough to try.  Even if that doesn't work for you, you should be able to type "sqlite3 Personal7.kmy" (if you didn't use a password on the file, or "sqlcipher Personal7.kmy" and then ".d" will list all tables (there should be a lot of them, and "select * from kmmAccounts" which should list all the accounts in your data.  If those all work, I'm a bit stumped, but see below.  Separately, if any of them give an error, that is something we can further troubleshoot.

Separately, you are using a snap, not a native package, and we have seen problems reported which I recall were  eventually tracked down to packaging issues.  One thing you might try is installing KMyMoney from the regular package manager.
Comment 11 pizzafarmer 2025-02-14 17:12:23 UTC
I was able to open the file using sqlite3 and list all the tables. I was then able to dump the contents of kmmAccounts which appears to contain the accounts that I had built.

Also, I had already done a remove and purge and new install of KMyMoney using the package manager, no joy.

To step back a little, this problem occurred as I was switching back and forth between XML  and SQL files. Apparently, something happened that corrupted the SQL file. I can attempt to recover the file, but I'm not sure at this point if I want to continue down that path. I may just build a new database using the XML option which worked for me for many years.

These are the attributes of the two files I was using.

$ file Personal3.kmy
Personal3.kmy: gzip compressed data, was "", last modified: Mon Feb  3 16:36:47 2025, from Unix, original size modulo 2^32 24970950


$ file Personal7.kmy
Personal7.kmy: SQLite 3.x database, last written using SQLite version 3044002, file counter 198, database pages 67, cookie 0x19, schema 4, UTF-8, version-valid-for 198
Comment 12 Bug Janitor Service 2025-03-01 03:46:44 UTC
🐛🧹 ⚠️ This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information, then set the bug status to REPORTED. If there is no change for at least 30 days, it will be automatically closed as RESOLVED WORKSFORME.

For more information about our bug triaging procedures, please read https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging.

Thank you for helping us make KDE software even better for everyone!
Comment 13 Bug Janitor Service 2025-03-16 03:47:24 UTC
🐛🧹 This bug has been in NEEDSINFO status with no change for at least 30 days. Closing as RESOLVED WORKSFORME.