Error starting version 1.3.1 (DB v.7)

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

Moderator: Renato

Post Reply
spcole
New MMEX User
Posts: 5
Joined: Mon Feb 20, 2017 8:02 pm
Are you a spam bot?: No

Error starting version 1.3.1 (DB v.7)

Post 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
guanlisheng
MMEX Developer
Posts: 375
Joined: Wed Dec 21, 2011 5:58 am
Are you a spam bot?: No
Location: China
Contact:

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

Post by guanlisheng »

here you go how to fix the db version issue
https://sourceforge.net/p/moneymanagerex/bugs/927/
Lisheng Guan,
Developer of MoneyManagerEX (http://moneymanagerex.org)
spcole
New MMEX User
Posts: 5
Joined: Mon Feb 20, 2017 8:02 pm
Are you a spam bot?: No

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

Post 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
believeland
New MMEX User
Posts: 1
Joined: Sat Mar 04, 2017 12:22 pm
Are you a spam bot?: No

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

Post 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!
User avatar
GabrieleV
MMEX Developer
Posts: 158
Joined: Wed Apr 09, 2014 7:45 pm
Are you a spam bot?: No
Location: Italy

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

Post 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.
mohsin
New MMEX User
Posts: 1
Joined: Thu Dec 01, 2016 8:43 am
Are you a spam bot?: No

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

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