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
mmex 1.3.5 db version.
Moderator: Renato
-
- New User
- Posts: 5
- Joined: Mon Oct 26, 2020 10:22 am
- Are you a spam bot?: No
-
- Developer
- Posts: 1535
- 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.
The solution is here:
https://github.com/moneymanagerex/money ... ssues/2353
https://github.com/moneymanagerex/money ... ssues/2353
-
- New User
- Posts: 5
- Joined: Mon Oct 26, 2020 10:22 am
- Are you a spam bot?: No
Re: mmex 1.3.5 db version.
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.
-
- MVP User
- Posts: 682
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: mmex 1.3.5 db version.
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
With the search function you can find more.
viewtopic.php?p=19486#p19486
viewtopic.php?f=10&t=9412&p=20121&hilit=script#p20121
Renato Forum Administrator
-
- New User
- Posts: 5
- Joined: Mon Oct 26, 2020 10:22 am
- Are you a spam bot?: No
Re: mmex 1.3.5 db version.
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??
-
- MVP User
- Posts: 682
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: mmex 1.3.5 db version.
maybe this will help:
You do not have the required permissions to view the files attached to this post.
Renato Forum Administrator
-
- Developer
- Posts: 1535
- 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.
@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
Close the app and press the Save button on exit.
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
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;
You do not have the required permissions to view the files attached to this post.