im running Version: 1.4.0-alpha.7
when i start v1.3.4.beta.2 i get database errors
Database v1.3.4.beta.2
Moderator: Renato
- Renato
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Database v1.3.4.beta.2
Renato Forum Administrator
Re: Database v1.3.4.beta.2
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
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
- Renato
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Database v1.3.4.beta.2
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 ??
how can this problem be solved ?.
in the long run will the db of 1.3 be similar to 1.4 or ??
Renato Forum Administrator
- Renato
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Database v1.3.4.beta.2
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.
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.
Renato Forum Administrator
Re: Database v1.3.4.beta.2
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
Seems the script has been written and needs to be tested so might be part of v1.3.4-rc3
- Renato
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Database v1.3.4.beta.2
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
I've used it in SQLiteBrowser with database_version_7.txt see https://github.com/moneymanagerex/money ... ssues/2353
Renato Forum Administrator
- Renato
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Database v1.3.4.beta.2
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.
Maybe this problem could be adjusted in the script.
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: Database v1.3.4.beta.2
I've updated the script.
downgrade_db_13_7_v2.zip
But exactly for your issue the following script may be applied:
(Save it as mmdbg file. Then run using main menu Tools - Database - Database Debug)
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';
- Attachments
-
- downgrade_db_13_7_v2.zip
- (3.13 KiB) Downloaded 292 times