GNOME Bugzilla – Bug 723524
Unable to update old transaction
Last modified: 2018-06-29 23:25:58 UTC
Migrated from 2.4.15 Trying to update an amount on the year-old transaction. Assets account is in BYR. Expenses account is in BYR as well. While editing just amount, without opening 'split' user could change amount but it is impossible to save it. Even them you close account tab - clicking "Save Transaction" button in a "save changes" dialog - nothing happens. Reopening account shows old transaction amount. While editing in "split mode" application, after change amount in expense account - "Transfer Funds" dialog been shown, asking to transfer from BYR to USD(default currency) with 1 to 1 exchange rate. Its strange, since both accounts are in the same currency.
Please attach the gnucash.trace associated with that run. http://wiki.gnucash.org/wiki/Tracefile What backend? It sounds like you opened the file in read-only mode.
Created attachment 267967 [details] trace file for 723524
Back-end is SQLight While opening a datafile, message "Database may be in use by another user". Since I'm the only user I have select "Open Anyway" option. I was able to enter new transactions and and work around my problem by deleting old transaction and recreate it with correct amount. I have tried to reproduce this issue opening DB with "Open Anyway" option, but it works normally. The trace file is attached. This is not the first time I'm getting such error.I will upload new trace files as soon as I get the issue once again. Maybe there is a way to change trace level to get more details?
The same problem while trying to enter scheduled transaction. trace file attached
Created attachment 268402 [details] trace file for error while entering a scheduled transaction
The trace files show a number of low level drawing errors which I haven't encountered before yet. But even if related they don't give a clue at all as to why saving your changes won't work. You can generate more debug info by starting gnucash from a command line as follows: - open a command prompt - cd <path to where you installed gnucash>\bin - gnucash.exe --debug
Created attachment 269538 [details] Log file while creating scheduled transaction Scheduled transaction been created. But it is unable to update transaction amount since currency conversion appears, but both accounts are in the same currency
Created attachment 269539 [details] Unable to update transaction. After scheduled transaction been created but it was unable to change amount, GnuCash been restarted. After navigation to the transaction, it is unable to change amount. User could change numbers, but it is unable to save it.
Are you able to query your SQL database by hand?
If you can, please run this query: select c.namespace, c.mnemonic from transactions as t, commodities as c where c.guid = t.currency_guid and t.post_date like "20140608%"; But change the date to the one of your problem transaction.
Closing this bug report as no further information has been provided. Please feel free to reopen this bug if you can provide the information asked for. Thanks!
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=723524. Please update any external references or bookmarks.