Hi everybody,
I’m seeking your help to solve the following problem.
I need to remove shares or account already locked, that cannot be reopened to enable their removal.
Under SQL, in the table “kmmKeyValuePairs”, the field “kvpKey” has the value “mm-closed” for each records I want to remove.
I succeeded to replace this value with the string “lastNumberUsed” using the sql UPDATE statement for these records.
After this operation I did not succeed to remove these records as a KMM user.
What I did is not the right way to proceed. My question is twofold:
- are there other fields elsewhere to modify, with which value?
- was it right to make the replacement I did?
Could you please indicate me the right way to proceed.
Thank you for your help.
René
First, am I correct that you mean “closed” and not “locked?” KMyMoney does not have the concept of a locked account. I am assuming that is the case.
Next, unless you really know what you are doing, changing the stored data is very rarely a good thing to do. Changing the value of a KVP (Key Value Pair) is definitely not what you needed. I cannot think of any other data items relevant to the closed/open status of an account.
With the values set back to what they were, can you not reopen that account? I cannot think of any reason you should not be able to reopen a closed account. Did you get any error message? Can you try running the program from command line? In that case, you might see a more helpful message written out to console.
It should not make any difference that your data is stored in an SQL database, but just in case, can you do a Save As to store your data in an xml or kmy file, and see if the behavior is any different.
Thank you so much for your reply.
Following your suggestion, I went back to the original format (kmy file) running KMM from an Opensuse Tumbleweed terminal.
I tried again to reopen the account and modify the elements it contains. No success. Even in the original format of the database, I neither can reopen the closed account nor modify the elements within the account.
I’ll send you the session log in a separate e-mail as it is too long to be included in this message.
Thank you for your help.
Regards.
René
You can certainly not do anything within a closed account except look. We need to figure out why it won’t let you reopen it.
What version are you running, and on what platform (x11 or wayland, if linux)? It shouldn’t matter, but this is clearly not a typical problem.
You can trim most of the beginning of the session log - I’m just hoping there is some error or warning about why the account cannot be reopened.
The next step might be to save as an anonymized file, and see if you can reopen the account there. If not, you can send one of us the anonymized file without exposing any personal data.
Many thanks for you contact.
Here is a description of my system:
- Hardware Lenovo Lenovo Legion Y530-15ICH-1060
- Memory 16,0 Gio
- Processor Intel® Core™ i7-8750H × 12
- Graphic card Intel® UHD Graphics 630 (CFL GT2)
- HD size 2,5 To
Software Information:
- OS openSUSE Tumbleweed
- OS type 64 bits
- GNOME Version 45.3
- Windowing Wayland
- Kernel Version Linux 6.7.1-2-default
KMyMoney
- KMM Version 5.1.3
- KDE Development Environment Version 5.114.0
- Qt Version 5.15.12
- Windowing xcb
Here is the beginning of the log session:
As convene and described in my message on the KDE platfom, please find
below the log of an entire KmMoney session. I hope it is usefull:
(base) rene@localhost:~> kmymoney
Warning: Ignoring XDG_SESSION_TYPE=wayland on Gnome. Use
QT_QPA_PLATFORM=wayland to run on Wayland anyway.
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: “Adwaita”
QPainter::begin: Paint device returned engine == 0, type: 2
QPainter::begin: Paint device returned engine == 0, type: 2
kf.xmlgui: Shortcut for action “account_reconcile” “Rapprocher…” set
with QAction::setShortcut()! Use
KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action “edit_find_transaction” “Trouver
l’opération…” set with QAction::setShortcut()! Use
KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action “view_hide_reconciled_transactions”
“Cacher les opérations rapprochées” set with QAction::setShortcut()!
Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action “view_show_transaction_detail”
“Afficher le détail de l’opération” set with QAction::setShortcut()!
Use KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action “view_hide_unused_categories” “Cacher
les catégories inutilisées” set with QAction::setShortcut()! Use
KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action “view_show_all_accounts” “Afficher tous
les comptes” set with QAction::setShortcut()! Use
KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action “transaction_assign_number” “Assigner
le numéro suivant” set with QAction::setShortcut()! Use
KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action “transaction_mark_toggle” “Inverser”
set with QAction::setShortcut()! Use
KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action “transaction_mark_reconciled”
“Rapprochée” set with QAction::setShortcut()! Use
KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action “transaction_mark_cleared” “Compensée”
set with QAction::setShortcut()! Use
KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action “transaction_select_all” “Tout
sélectionner” set with QAction::setShortcut()! Use
KActionCollection::setDefaultShortcut(s) instead.
kf.xmlgui: Shortcut for action “transaction_new” “Nouveau” set with
QAction::setShortcut()! Use KActionCollection::setDefaultShortcut(s)
instead.
Located plugin “/usr/lib64/qt5/plugins/kmymoney/budgetview.so” Validity
true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/checkprinting.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/csvexporter.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/csvimporter.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/forecastview.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/gncimporter.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/icalendarexporter.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/kbanking.so” Validity
true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/kcm_checkprinting.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/kcm_csvimporter.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/kcm_forecastview.so”
Validity true
Located plugin
“/usr/lib64/qt5/plugins/kmymoney/kcm_icalendarexporter.so” Validity
true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/kcm_qif.so” Validity
false
Located plugin “/usr/lib64/qt5/plugins/kmymoney/kcm_reportsview.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/kcm_xmlstorage.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/konlinetasks_sepa.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/ofximporter.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/onlinejoboutboxview.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/qifexporter.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/qifimporter.so”
Validity true
Located plugin
“/usr/lib64/qt5/plugins/kmymoney/reconciliationreport.so” Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/reportsview.so”
Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/sqlstorage.so” Validity
true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/woob.so” Validity true
Located plugin “/usr/lib64/qt5/plugins/kmymoney/xmlstorage.so” Validity
true
Loading “/usr/lib64/qt5/plugins/kmymoney/budgetview.so”
Plugins: budgetview loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/checkprinting.so”
Plugins: checkprinting loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/csvexporter.so”
Plugins: csvexporter loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/csvimporter.so”
Plugins: csvimporter loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/forecastview.so”
Plugins: forecastview loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/gncimporter.so”
Plugins: gncimporter loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/icalendarexporter.so”
Plugins: icalendarexporter loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/kbanking.so”
“Plugins: kbanking loaded, build with (5.10.1stable-0/6.5.4.0stable),
run with (5.10.1.0/6.5.4.0)”
3:2024/01/29 23-35-01:(null)(5484):banking_update.c: 610: No AqBanking
config folder found at [/home/rene/.aqbanking/settings6/users] (-1)
3:2024/01/29 23-35-01:(null)(5484):banking_update.c: 610: No AqBanking
config folder found at [/home/rene/.aqbanking/settings/users] (-1)
3:2024/01/29 23-35-01:(null)(5484):banking_update.c: 411: There is no
old settings folder, need initial setup
7:2024-01-29 23:35:01:aqbanking started
Loading “/usr/lib64/qt5/plugins/kmymoney/ofximporter.so”
Plugins: ofximporter loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/onlinejoboutboxview.so”
Plugins: onlinejoboutboxview loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/qifexporter.so”
Plugins: qifexporter loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/qifimporter.so”
Plugins: qifimporter loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/reconciliationreport.so”
Plugins: reconciliation report loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/reportsview.so”
Plugins: reportsview loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/sqlstorage.so”
Plugins: sqlstorage loaded
Loading “/usr/lib64/qt5/plugins/kmymoney/woob.so”
Python interpreter found: 3.11.7 (main, Dec 15 2023, 10:49:17) [GCC]
Saved a copy of the embedded :/plugins/woob/kmymoneywoob.py script as
“/tmp/kmymoneymxyfeo.py”
Attempt to load the “kmymoneymxyfeo” Python module from “/tmp”
The dependency ‘sys’ Python module loaded successfully
The ‘path’ Python variable loaded successfully
“kmymoneymxyfeo” Python module failed to load
Traceback (most recent call last):
File “/tmp/kmymoneymxyfeo.py”, line 9, in
from woob.core import Woob
ModuleNotFoundError: No module named ‘woob’
Plugins: woob loaded
Loading “/usr/lib64/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/”
reading file
start parsing file
startDocument
reading securities
endDocument
Cost center model created with items 0
Payees model created with items 0
Setting a QCompleter on non-editable QComboBox is not allowed.
Setting a QCompleter on non-editable QComboBox is not allowed.
Plugins: budgetview unloaded
Plugins: checkprinting unloaded
Plugins: csvexporter unloaded
Plugins: csvimporter unloaded
Plugins: forecastview unloaded
Plugins: gncimporter unloaded
Plugins: icalendarexporter unloaded
7:2024-01-29 23:41:55:aqbanking stopped
Plugins: kbanking unplugged
Plugins: kbanking unloaded
Plugins: ofximporter unloaded
Plugins: onlinejoboutboxview unloaded
Plugins: qifexporter unloaded
Plugins: qifimporter unloaded
Plugins: reconciliation report unloaded
Plugins: reportsview unloaded
Plugins: sqlstorage unloaded
Plugins: woob unloaded
Plugins: xmlstorage unloaded
[5484:5484:0129/234156.243430:ERROR:shared_image_manager.cc(143)]
SharedImageManager::ProduceGLTexture: Trying to produce a
representation from a non-existent mailbox.
69:C1:91:2F:00:79:95:49:C8:F5:16:DA:9A:BE:2C:4B
[5484:5484:0129/234156.243552:ERROR:gles2_cmd_decoder.cc(19028)]
[.DisplayCompositor]GL ERROR :GL_INVALID_OPERATION :
DoCreateAndTexStorage2DSharedImageINTERNAL: invalid mailbox name
[5484:5484:0129/234156.243575:ERROR:gles2_cmd_decoder.cc(19050)]
[.DisplayCompositor]GL ERROR :GL_INVALID_OPERATION :
DoBeginSharedImageAccessCHROMIUM: bound texture is not a shared image
[5484:5484:0129/234156.243635:ERROR:gles2_cmd_decoder.cc(10695)]
[.DisplayCompositor]RENDER WARNING: texture bound to texture unit 0 is
not renderable. It might be non-power-of-2 or have incompatible texture
filtering (maybe)?
Can you confirm that that log includes you trying to re-open a closed account? I don’t see any messages at all between it finishing reading your data file, and then closing. How are you trying to reopen the account? Can you open the account in the ledger, or else select it in the Accounts View? Then use the menu Account/Reopen Account…?
Note that if you can’t open the account in the ledger because you can’t see it in the Accounts View, you need to select the menu item View/Show all accounts.