Database v1.3.4.beta.2

MMEX4Desktop, incl. Windows, macOS (10.10 or newer), and Most Unix variants using the GTK+ toolkit

Moderator: Renato

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

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
Renato Forum Administrator
siowena
Super MMEX User
Posts: 109
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: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

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 ??
Renato Forum Administrator
User avatar
Renato
MVP MMEX User
Posts: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

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.
Renato Forum Administrator
siowena
Super MMEX User
Posts: 109
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: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

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
Renato Forum Administrator
User avatar
Renato
MVP MMEX User
Posts: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

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.
Renato Forum Administrator
Nikolay
MMEX 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

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 287 times
Post Reply