Created attachment 107007 [details] Screenshot of Skrooge account page showing "Computing.." I've recently had a catastrophic hard drive crash, so I've bought a new PC, loaded the latest PCLinuxOS (KDE Plasma 5), installed Skrooge, and recovered my Skrooge files from data backup. However, when I open up a file and an account within it, the balance is not shown at the bottom of the page. This is the most significant figure on that screen for managing the account. For example, I manage the payment to weekly carers for an elderly relative and have to move funds around, make external payments on a regular basis based on the projected balance. I can't do this now for some reason. I have left the application running, and the screen open for 75 minutes with no change. I have also saved, closed and re-opened it with no change. Thanks in anticipation.
Hi, I think this issue is already corrected in the next version of Skrooge. Just to be sure, could you do that from a console (a terminal): Launch Skrooge Open the operation page You should have a trace in the console with a SQL error. If you are able to build Skrooge from the trunk, you can also do it to get the correction. Possible workaround: Add the "Balance" column on the operation table (do not forget to enable balances computation in settings). Regards.
Hi, Thanks for the prompt response. I'm getting very desperate, and I'm not very good with console, I'm afraid. I ran Skrooge from Konsole to open it, then clicked on Operation and got this: [timj@localhost ~]$ skrooge ##WARNING: getGlobalAction(tab_overwritebookmark)=nullptr ##WARNING: QWidget::insertAction: Attempt to insert null action ##WARNING: SELECT TOTAL(f_CURRENTAMOUNT), TOTAL(f_CHECKED), TOTAL(f_COMING_SOON), TOTAL(f_COMING_SOON_FROM_LINKED_ACCOUNT) from v_account_display WHERE t_name='Lloyds Bank Current' ## returns :file is encrypted or is not a database Unable to execute statement Does this confirm your thoughts? Can you say when the new version will be available from the PCLinuxOS repo? Re. your possible workaround, I've managed to work out how to add a balance column to the Operations screen, and "compute balances" is already ticked in Settings/Configure Skrooge/Operations. When I click on the Switch information icon, the Delta amount is the same as the closing balance on the last bank statement I reconciled. Does that mean the running balance shown in the added Balance column should be the figure I can use to manage the account day to day? Thanks for your help with this.
(In reply to Tim Johnson from comment #2) > Hi, > > Thanks for the prompt response. I'm getting very desperate, and I'm not > very good with console, I'm afraid. > > I ran Skrooge from Konsole to open it, then clicked on Operation and got > this: > > [timj@localhost ~]$ skrooge ##WARNING: > getGlobalAction(tab_overwritebookmark)=nullptr ##WARNING: > QWidget::insertAction: Attempt to insert null action ##WARNING: SELECT > TOTAL(f_CURRENTAMOUNT), TOTAL(f_CHECKED), TOTAL(f_COMING_SOON), > TOTAL(f_COMING_SOON_FROM_LINKED_ACCOUNT) from v_account_display WHERE > t_name='Lloyds Bank Current' ## returns :file is encrypted or is not > a database Unable to execute statement > > Does this confirm your thoughts? Yes. > Can you say when the new version will be > available from the PCLinuxOS repo? The new version of Skrooge 2.9.0 will be released soon. After that the packager of PCLinuxOS will do the packaging. The the new version will be available in PCLinuxOS repo. I don't know how many time it takes. > > Re. your possible workaround, I've managed to work out how to add a balance > column to the Operations screen, and "compute balances" is already ticked in > Settings/Configure Skrooge/Operations. Perfect, so on the last operation of the list, you should have the balance of your account. > When I click on the Switch > information icon, the Delta amount is the same as the closing balance on the > last bank statement I reconciled. Does that mean the running balance shown > in the added Balance column should be the figure I can use to manage the > account day to day? This part of the panel will still working bad. Just one more question: When you open your document, do you have a message saying that you should switch your document in SQLCypher mode? If yes, please do it. > > Thanks for your help with this.
Created attachment 107030 [details] 2 Screenshot of Save message
Created attachment 107031 [details] 3 Screenshot of Exit message
Hi Stephane, Many, many thanks for your help with this. It has helped relieve much of the stress associated with my recent PC problems. Re. your last question, I didn't get the SQLCypher message, but I am getting the messages shown in attachments 2 and 3 when I save any new input, and when I try and close the file. I am clicking on Yes in both cases as that seemed the logical thing to do, and I'll assume that is the right course of action unless you tell me otherwise. This is what appears on Konsole after making one small change to an operation and saving it: [timj@localhost ~]$ skrooge ##WARNING: getGlobalAction(tab_overwritebookmark)=nullptr ##WARNING: QWidget::insertAction: Attempt to insert null action ##WARNING: Icon [axis-vertical] not found ##WARNING: SELECT TOTAL(f_TODAYAMOUNT), TOTAL(f_CURRENTAMOUNT), TOTAL(f_CHECKED), TOTAL(f_COMING_SOON) from v_account_display ## returns :file is encrypted or is not a database Unable to execute statement ##WARNING: SELECT TOTAL(f_TODAYAMOUNT), TOTAL(f_CURRENTAMOUNT), TOTAL(f_CHECKED), TOTAL(f_COMING_SOON) from v_account_display ## returns :file is encrypted or is not a database Unable to execute statement ##WARNING: SELECT TOTAL(f_TODAYAMOUNT), TOTAL(f_CURRENTAMOUNT), TOTAL(f_CHECKED), TOTAL(f_COMING_SOON) from v_account_display ## returns :file is encrypted or is not a database Unable to execute statement [timj@localhost ~]$ I'll now carry on using the workaround until the new version is in the repo. Thanks again for your help. Kind Regards, Tim