Page 1 of 1

Error starting version 1.3.1 (DB v.7)

Posted: Mon Feb 20, 2017 8:07 pm
by spcole
19:57:55: ACCOUNTLIST_V1: Exception SQL logic error or missing database[1]: no such column: STATEMENTLOCKED

Cannot load transactions but can see budgets and assets.

Please advise how to proceed.

Thanks,

Stephen

Re: Error starting version 1.3.1 (DB v.7)

Posted: Tue Feb 21, 2017 12:14 am
by guanlisheng
here you go how to fix the db version issue
https://sourceforge.net/p/moneymanagerex/bugs/927/

Re: Error starting version 1.3.1 (DB v.7)

Posted: Tue Feb 21, 2017 8:21 pm
by spcole
I followed the instructions on the link you provided but the command Tools | Database | Database Debug will not allow to open the downloaded .mmdbg files.

Stephen

Re: Error starting version 1.3.1 (DB v.7)

Posted: Sat Mar 04, 2017 12:24 pm
by believeland
I also cannot open either of the attached files with the 'database debug' feature. Based on the number of posts I've seen, this looks like it's a common issue. But all the answers redirect to the same SourceForge page, which doesn't seem to work. It's a bit frustrating!

Re: Error starting version 1.3.1 (DB v.7)

Posted: Sun Mar 05, 2017 2:56 pm
by GabrieleV
I've never tested debug feature on Mac. Which error do you have?
Meanwhile you can fix doing the same steps on a Windows machine.

Re: Error starting version 1.3.1 (DB v.7)

Posted: Sun Apr 30, 2017 7:31 pm
by mohsin
Hi .. I am facing the same issue, thats is,  ACCOUNTLIST_V1: Exception SQL logic error or missing database[1]: no such column: STATEMENTLOCKED. The provided solution does not work as on Mac you cannot open the provided file in issue#927. 

I am not sure what do you mean by following steps provided for windows version. Are you referring to the same issue #927? 

Kindly help find as solution for this as I am not able to update my accounts for about a month now. Thanks