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 (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.