Page 1 of 1

Error - Exception constraint failed

Posted: Thu Dec 12, 2024 1:31 am
by Peter
Good day,

Could you please help.
Am running the new MMex ver 1.8.1 64 bit on Windows 11
When trying to import my monthly bank transactions in .csv format. I get the following error message on all the transactions

01:47:42: PAYEE_V1: Exception constraint failed[2067]: UNIQUE constraint failed: PAYEE_V1.PAYEENAME, {
"PAYEEID": -1,
"PAYEENAME": "P. Gordon-Cumming",
"CATEGID": -1,
"NUMBER": "",
"WEBSITE": "",
"NOTES": "",
"ACTIVE": 1,
"PATTERN": ""
}

Even though P. Gordon-Cumming does exist as a PAYE in the system

I found 1 entry for this error message in the Forum way back in April 2019 but it did not help me.

Thanks

Re: Error - Exception constraint failed

Posted: Thu Dec 12, 2024 1:01 pm
by Renato
Maybe the latest beta version will help (but please save .mmb first):
https://ci.appveyor.com/project/whalley ... /artifacts

Re: Error - Exception constraint failed

Posted: Sat Dec 14, 2024 11:31 am
by MlinMMEX
Not sure how to find this error on the list of current defects, fixed or still pending...
https://github.com/moneymanagerex/money ... lestone/46