mmex 1.3.5 db version.

Money Manager Ex Development related posts
(http://github.moneymanagerex.org/)

Moderator: Renato

Post Reply
eric
New MMEX User
Posts: 3
Joined: Mon Oct 26, 2020 10:22 am
Are you a spam bot?: No

mmex 1.3.5 db version.

Post by eric »

Good Day,
I have just updated to Ubuntu 20.04 and installed mmex_1.3.5-1.tessa_amd64.deb. . When I open mmex and check the ABOUT it says version 1.3.5 Database version 7. When I try to open my backed up .mmb from my Ubuntu 18.04 version I get the following message MMEX database version 13 does not work with this version of MMEX please upgrade to a newer version. I have tried using db Browser to change PRAGMA to 7 but when I try to open this it opens as an empty instance i.e no account data. Don't know if I have messed something up but would like some help.
Thanks
Nikolay
MMEX Developer
Posts: 1507
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: mmex 1.3.5 db version.

Post by Nikolay »

eric
New MMEX User
Posts: 3
Joined: Mon Oct 26, 2020 10:22 am
Are you a spam bot?: No

Re: mmex 1.3.5 db version.

Post by eric »

Thank you for the prompt reply. I have downloaded and extracted the following files from solution issues/2353 - database_version_7.mmdbg and database_version_7.sql. Could you please explain how I can use these files to convert my version13 to version7. Thank you.
User avatar
Renato
MVP MMEX User
Posts: 299
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: mmex 1.3.5 db version.

Post by Renato »

this topic was discussed at different places in the forum
With the search function you can find more.

viewtopic.php?p=19486#p19486
viewtopic.php?f=10&t=9412&p=20121&hilit=script#p20121
regards Renato use MMEX since 2009
eric
New MMEX User
Posts: 3
Joined: Mon Oct 26, 2020 10:22 am
Are you a spam bot?: No

Re: mmex 1.3.5 db version.

Post by eric »

Ok I have looked at the posts and understand that I have to open MMEX, choose Database Debug and then load the database_version_&.mmdbg file then run it - problem is I cannot see the mmdbg file in the folder to which it was extracted so what next??
User avatar
Renato
MVP MMEX User
Posts: 299
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: mmex 1.3.5 db version.

Post by Renato »

maybe this will help:
mmex15.jpg
mmex15.jpg (66.45 KiB) Viewed 1362 times
regards Renato use MMEX since 2009
Nikolay
MMEX Developer
Posts: 1507
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: mmex 1.3.5 db version.

Post by Nikolay »

@eric for some reasons this solution does not working on Linux.

Workaround:

run SQLite Developer http://www.sqlitedeveloper.com/
open your mmb file as DB
execute the mmdbg file context https://github.com/moneymanagerex/money ... 3_7_v3.zip
Cap.GIF
(180.04 KiB) Not downloaded yet

Code: Select all

Result: query executed successfully. Took 1ms
At line 565:
-- rename table names used in GRM definitions

-- UPDATE REPORT SET SQLCONTENT = CONCAT(SQLCONTENT,'_V1') WHERE SQLCONTENT NOT LIKE  '%_V1%' COLLATE NOCASE;
-- UPDATE REPORT SET LUACONTENT = CONCAT(LUACONTENT,'_V1') WHERE LUACONTENT NOT LIKE '%_V1%' COLLATE NOCASE;
-- UPDATE REPORT SET TEMPLATECONTENT = CONCAT(TEMPLATECONTENT, '_V1') WHERE TEMPLATECONTENT NOT LIKE '%_V1%' COLLATE NOCASE;

-- finish

PRAGMA user_version = 7;
Close the app and press the Save button on exit.
Post Reply