Page 1 of 1

Error Deleting Transaction

Posted: Sat Oct 03, 2020 10:33 am
by stpharm
Hi
I was trying to delete a transaction and had this error
Any Help appreciated
Thanks !

Re: Error Deleting Transaction

Posted: Thu Dec 17, 2020 10:35 am
by bonnieshona
A fix has been provided for this issue in GitHub: https://github.com/moneymanagerex/money ... /pull/1121

This disables the Duplicate button. The duplicate option on the popup menu was disabled.

As for removing the error, this requires removal of the entry by using sql commands.

We need to determine the share account ID
select ACCOUNTNAME, ACCOUNTID from ACCOUNTLIST_V1
where ACCOUNTTYPE = "Shares";

This tells us the correct linkages
select ca.TRANSID, ca.ACCOUNTID, ca.TOACCOUNTID
from CHECKINGACCOUNT_V1 ca, SHAREINFO_V1 si
where ca.TRANSID = si.CHECKINGACCOUNTID;

With this we can determine the extra transaction that needs to be deleted
select ACCOUNTID, TRANSID, TOACCOUNTID from CHECKINGACCOUNT_V1
where ACCOUNTID = ?;

We can then create a database debug command to fix the error.