Page 1 of 1
Database v1.3.4.beta.2
Posted: Mon Mar 30, 2020 8:48 pm
by Renato
im running Version: 1.4.0-alpha.7
when i start v1.3.4.beta.2 i get database errors
Re: Database v1.3.4.beta.2
Posted: Tue Mar 31, 2020 4:17 am
by siowena
v1.3.4 beta 2 is compatible with DB v7 used in v1.3.3 full release.
Unfortunately if you've been using v1.4.x alpha N, your DB has upgraded the DB to v12 and this is not compatible with v1.3.4
Re: Database v1.3.4.beta.2
Posted: Tue Mar 31, 2020 2:20 pm
by Renato
I noticed that myself.
how can this problem be solved ?.
in the long run will the db of 1.3 be similar to 1.4 or ??
Re: Database v1.3.4.beta.2
Posted: Fri Apr 03, 2020 12:28 pm
by Renato
after a long search I found the following:
https://github.com/moneymanagerex/money ... ssues/2353
However, I have trouble understanding the solution.
someone can explain it to me in a way that I can understand.
Re: Database v1.3.4.beta.2
Posted: Fri Apr 03, 2020 3:20 pm
by siowena
it's an effort to develop a DB downgrade script to put the DBv12 to DBv7.
Seems the script has been written and needs to be tested so might be part of v1.3.4-rc3
Re: Database v1.3.4.beta.2
Posted: Fri Apr 03, 2020 6:43 pm
by Renato
Congratulations! This script is working on Version: 1.3.4-RC.2
I've used it in SQLiteBrowser with database_version_7.txt see
https://github.com/moneymanagerex/money ... ssues/2353
Re: Database v1.3.4.beta.2
Posted: Sat Apr 04, 2020 8:19 am
by Renato
Addendum: had to change the status code for transfer bookings "RR" to "R" (reconciled) manually with SQLiteBrowser.
Maybe this problem could be adjusted in the script.
Re: Database v1.3.4.beta.2
Posted: Sat Apr 04, 2020 7:52 pm
by Nikolay
I've updated the script.
downgrade_db_13_7_v2.zip
But exactly for your issue the following script may be applied:
Code: Select all
-- MMEX Debug SQL - Update --
update CHECKINGACCOUNT_V1 set STATUS = substr(case STATUS when '' then 'N' else STATUS end, 1, 1) where TRANSCODE ='Transfer';
(Save it as mmdbg file. Then run using main menu Tools - Database - Database Debug)