MMEX Database Upgrade Error

Money Manager Ex Development related posts for both Android and Desktop

Moderator: Renato

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

MMEX Database Upgrade Error

Post by Renato »

Would like to present here a solution for the various upgrade errors:

Install (Windows) https://download.sqlitebrowser.org/DB.B ... -win64.msi
or (Mac OS) https://download.sqlitebrowser.org/DB.B ... 3.12.2.dmg

Open a copy of the last working .mmb with it
Select the view Database Structure
At the bottom there are probably entries "Views" delete all these entries (right mouse button)
save these changes CTRL+S, close the DB with CTRL+F4

Then you can open this changed DB version and the newest MMEX version.

see also: viewtopic.php?t=10777
Renato Forum Administrator
Mac
New User
Posts: 2
Joined: Wed Jan 25, 2023 4:01 pm
Are you a spam bot?: No

Re: MMEX Database Upgrade Error

Post by Mac »

I've finally got it to work on my new machine after following your fix (BTW the keyboard short cuts don't work), but only by downloading Version 1.6.0 onto my new machine.
I have yet to discover if it will work with V 1.6.2
(Tip: always save your downloads in a download file and keep them.)
User avatar
Renato
MVP User
Posts: 719
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: MMEX Database Upgrade Error

Post by Renato »

Thanks for the feedback.
(Tip: always save your downloads in a download file and keep them.)
If you mean old MMEX downloads, you can always download them again here: https://moneymanagerex.org/docs/downloads/older/
Renato Forum Administrator
corsaraver
New User
Posts: 2
Joined: Fri Mar 24, 2023 3:24 pm
Are you a spam bot?: No

Re: MMEX Database Upgrade Error

Post by corsaraver »

I am really struggling here, while noting that I am not a technical user and surely not a developer.

I recently had hard drive issues and managed to recover my MMEX database and am trying to run it again. The issue I noted that there is the version line 1.6 now, which did not allow me to open my database. I noted that my database is in the version 1.4, which I cannot find the application for.

I have tried installing version 1.5, opening the database and then running the patch file downgrade_db_13_7_v4.mmdbg. However this does not work and I was provided with the error message "Query error, please contact MMEX support! SQL logic error[1]: no such table: ACCOUNTLIST". I have also tried this approach by using version 1.3. instead of version 1.5 but still got the same error.

I would really appreciate if someone could assist me with an ´easy´ way of being able to open my database and continuing to use it.

Thanks and kind regards
User avatar
Renato
MVP User
Posts: 719
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: MMEX Database Upgrade Error

Post by Renato »

The downgrade from version 1.4 is described here:

https://moneymanagerex.org/docs/downloa ... -from-v140
https://github.com/moneymanagerex/money ... ssues/2353

If you need further help, please get in touch.
Renato Forum Administrator
corsaraver
New User
Posts: 2
Joined: Fri Mar 24, 2023 3:24 pm
Are you a spam bot?: No

Re: MMEX Database Upgrade Error

Post by corsaraver »

Hi Renato thank you for your quick turnaround.

Unfortunately, I followed that process as described here https://github.com/moneymanagerex/money ... ssues/2353 by vomikan at the top of the thread but have got the issues I reported.

Is there any way I can get my v 1.4 MMEX Database to continue to be used?

I am feeling lost without it.

Thanks again.
User avatar
Renato
MVP User
Posts: 719
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: MMEX Database Upgrade Error

Post by Renato »

You have a mail
Renato Forum Administrator
mazurano
New User
Posts: 4
Joined: Sun May 26, 2024 6:41 pm
Are you a spam bot?: No

Re: MMEX Database Upgrade Error

Post by mazurano »

Hello, first I apologize if this is not where I should put this.
I have version 1.6.1 and when updating to 1.8 the database gave me an error.
Thinking that I should update in order, I downloaded version 1.6.2 and I get the same error.
"Constraid failed[1555]: UNIQUEconstraint falied: CATEGORY_V1.CATEGID
I have searched the forum and the solutions proposed have not worked for me.
I have nothing in views. And in the table that gives me an error, I don't see anything strange either.
CSV table
CATEGID,CATEGNAME,ACTIVE
1,Facturas,1
2,Comida,1
3,Ocio,1
4,Coche viejo,1
5,Estudios,1
6,Hogar,1
7,Salud_Belleza,1
8,Seguros,1
9,Vacaciones,1
10,Impuestos,1
11,Varios,1
13,Ingresos,1
16,Transferencia_Deuda,1
17,Moto,1
18,Personal,1
19,Cumples_regalos,1
20,Asociaciones,1
21,Ahorro,1
22,inversión,1
23,Garaje,1
24,Gastos,1
25,Coche,1
26,Desconocido,1


Any suggestions on how to update?

I am a user in Spanish
User avatar
Renato
MVP User
Posts: 719
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: MMEX Database Upgrade Error

Post by Renato »

It probably has duplicate entries in the subcategories
Renato Forum Administrator
mazurano
New User
Posts: 4
Joined: Sun May 26, 2024 6:41 pm
Are you a spam bot?: No

Re: MMEX Database Upgrade Error

Post by mazurano »

Yes, it had subcategories with the same name, although of a different category.
Example:
Category: Car
Subcategory: Fuel
Category: Motorcycle
Subcategory: Fuel
Anyway, I changed their name, but unfortunately I get the same error.

Any other idea?

Thanks for your time
User avatar
Renato
MVP User
Posts: 719
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: MMEX Database Upgrade Error

Post by Renato »

Have you made this correction to the subcategories under MMEX?
Try under MMEX Tools/Database/optimaze Database and Check Database.
Renato Forum Administrator
mazurano
New User
Posts: 4
Joined: Sun May 26, 2024 6:41 pm
Are you a spam bot?: No

Re: MMEX Database Upgrade Error

Post by mazurano »

Yes, I have changed all the subcategories.
I have also optimized the database from MMEX.
There is no option to check the database in the menu.
But it still doesn't work.

I would like to insist on thanking you for your time.
User avatar
Renato
MVP User
Posts: 719
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: MMEX Database Upgrade Error

Post by Renato »

If you like, you can send the last still working .mmb to mmex-reg@bluewin.ch and I will try to solve your problem.
Of course, the confidentiality of the data is guaranteed.
Renato Forum Administrator
mazurano
New User
Posts: 4
Joined: Sun May 26, 2024 6:41 pm
Are you a spam bot?: No

Re: MMEX Database Upgrade Error

Post by mazurano »

All done. Thank you so much.
I saw that you have joined two tables into one.
Your attention and care is extraordinary.
Congratulations
User avatar
Renato
MVP User
Posts: 719
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: MMEX Database Upgrade Error

Post by Renato »

Many thanks for the feedback :D
You are welcome.
Renato Forum Administrator
Post Reply