Error Deleting Transaction

MMEX4Desktop, incl. Windows, macOS (10.10 or newer), and Most Unix variants using the GTK+ toolkit

Moderator: Renato

Post Reply
stpharm
New MMEX User
Posts: 19
Joined: Sat May 05, 2018 2:14 pm
Are you a spam bot?: No

Error Deleting Transaction

Post by stpharm »

Hi
I was trying to delete a transaction and had this error
Any Help appreciated
Thanks !
Attachments
Error.jpg
Error.jpg (6.02 KiB) Viewed 2081 times
bonnieshona
New MMEX User
Posts: 1
Joined: Fri Dec 11, 2020 8:05 am
Are you a spam bot?: No

Re: Error Deleting Transaction

Post 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.
Post Reply