[kmymoney] [Bug 499908] Fail to open .kmy file. Similar to bug 400684 but the fixes there are already implemented

Wed Feb 12 21:08:25 GMT 2025

https://bugs.kde.org/show_bug.cgi?id=499908

--- Comment #2 from pizzafarmer at yahoo.com ---
 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 at kde.org> wrote:  

 https://bugs.kde.org/show_bug.cgi?id=499908

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

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

--- Comment #1 from Jack <ostroffjh at 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.