MMEX Database Upgrade Error

[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

[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.)

[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/

[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

[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.

[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.

[Renato]

You have a mail

[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

[Renato]

It probably has duplicate entries in the subcategories

[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

[Renato]

Have you made this correction to the subcategories under MMEX?
Try under MMEX Tools/Database/optimaze Database and Check Database.

[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.

[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.

[mazurano]

All done. Thank you so much.
I saw that you have joined two tables into one.
Your attention and care is extraordinary.
Congratulations

[Renato]

Many thanks for the feedback
You are welcome.