Database v1.3.4.beta.2

Vista, 7, 8, 8.1. Unicode builds: x86, x64, ia64 versions available.

Moderator: Renato

Post Reply
User avatar
Renato
MVP MMEX User
Posts: 195
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Database v1.3.4.beta.2

Post by Renato »

im running Version: 1.4.0-alpha.7
when i start v1.3.4.beta.2 i get database errors
regards Renato use MMEX since 2009

siowena
MVP MMEX User
Posts: 112
Joined: Tue Jul 17, 2018 8:04 am
Are you a spam bot?: No

Re: Database v1.3.4.beta.2

Post 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

User avatar
Renato
MVP MMEX User
Posts: 195
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: Database v1.3.4.beta.2

Post 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 ??
regards Renato use MMEX since 2009

User avatar
Renato
MVP MMEX User
Posts: 195
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: Database v1.3.4.beta.2

Post 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.
regards Renato use MMEX since 2009

siowena
MVP MMEX User
Posts: 112
Joined: Tue Jul 17, 2018 8:04 am
Are you a spam bot?: No

Re: Database v1.3.4.beta.2

Post 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

User avatar
Renato
MVP MMEX User
Posts: 195
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: Database v1.3.4.beta.2

Post 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
regards Renato use MMEX since 2009

User avatar
Renato
MVP MMEX User
Posts: 195
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: Database v1.3.4.beta.2

Post 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.
regards Renato use MMEX since 2009

Nikolay
MMEX Developer
Posts: 1384
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

Post 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)
Attachments
downgrade_db_13_7_v2.zip
(3.13 KiB) Downloaded 96 times

Post Reply