MMEX Database Upgrade Error
Moderator: Renato
- Renato
- MVP User
- Posts: 750
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
MMEX Database Upgrade Error
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
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
-
- New User
- Posts: 2
- Joined: Wed Jan 25, 2023 4:01 pm
- Are you a spam bot?: No
Re: MMEX Database Upgrade Error
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.)
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
- MVP User
- Posts: 750
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: MMEX Database Upgrade Error
Thanks for the feedback.
If you mean old MMEX downloads, you can always download them again here: https://moneymanagerex.org/docs/downloads/older/(Tip: always save your downloads in a download file and keep them.)
Renato Forum Administrator
-
- New User
- Posts: 2
- Joined: Fri Mar 24, 2023 3:24 pm
- Are you a spam bot?: No
Re: MMEX Database Upgrade Error
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
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
- MVP User
- Posts: 750
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: MMEX Database Upgrade Error
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.
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
-
- New User
- Posts: 2
- Joined: Fri Mar 24, 2023 3:24 pm
- Are you a spam bot?: No
Re: MMEX Database Upgrade Error
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.
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
- MVP User
- Posts: 750
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
-
- New User
- Posts: 4
- Joined: Sun May 26, 2024 6:41 pm
- Are you a spam bot?: No
Re: MMEX Database Upgrade Error
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
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
- MVP User
- Posts: 750
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: MMEX Database Upgrade Error
It probably has duplicate entries in the subcategories
Renato Forum Administrator
-
- New User
- Posts: 4
- Joined: Sun May 26, 2024 6:41 pm
- Are you a spam bot?: No
Re: MMEX Database Upgrade Error
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
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
- MVP User
- Posts: 750
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: MMEX Database Upgrade Error
Have you made this correction to the subcategories under MMEX?
Try under MMEX Tools/Database/optimaze Database and Check Database.
Try under MMEX Tools/Database/optimaze Database and Check Database.
Renato Forum Administrator
-
- New User
- Posts: 4
- Joined: Sun May 26, 2024 6:41 pm
- Are you a spam bot?: No
Re: MMEX Database Upgrade Error
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.
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
- MVP User
- Posts: 750
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: MMEX Database Upgrade Error
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.
Of course, the confidentiality of the data is guaranteed.
Renato Forum Administrator
-
- New User
- Posts: 4
- Joined: Sun May 26, 2024 6:41 pm
- Are you a spam bot?: No
Re: MMEX Database Upgrade Error
All done. Thank you so much.
I saw that you have joined two tables into one.
Your attention and care is extraordinary.
Congratulations
I saw that you have joined two tables into one.
Your attention and care is extraordinary.
Congratulations
- Renato
- MVP User
- Posts: 750
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: MMEX Database Upgrade Error
Many thanks for the feedback
You are welcome.
You are welcome.
Renato Forum Administrator