Page 1 of 1

mmex 1.3.5 db version.

Posted: Mon Oct 26, 2020 11:15 am
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

Re: mmex 1.3.5 db version.

Posted: Mon Oct 26, 2020 11:58 am
by Nikolay

Re: mmex 1.3.5 db version.

Posted: Mon Oct 26, 2020 1:49 pm
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.

Re: mmex 1.3.5 db version.

Posted: Mon Oct 26, 2020 2:56 pm
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

Re: mmex 1.3.5 db version.

Posted: Mon Oct 26, 2020 5:02 pm
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??

Re: mmex 1.3.5 db version.

Posted: Mon Oct 26, 2020 5:12 pm
by Renato
maybe this will help:
mmex15.jpg
mmex15.jpg (66.45 KiB) Viewed 6220 times

Re: mmex 1.3.5 db version.

Posted: Mon Oct 26, 2020 6:47 pm
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.