Page 1 of 1

Database not updating

Posted: Wed Apr 13, 2022 12:52 pm
by Nickallington
I have noticed a problem recently where the database is not saving after being updated. As there is no 'Save' function I assume the database is treated as updated as soon as OK is pressed. However recently I have found occurrences where after shutting down, and then coming back the next day, the transactions I entered the day before are no longer present. Sometimes I can go to the .bak file, rename it, and load that, and find that the transactions made it as far as there, but I do not understand how they can not be in the live database if they are in the backup. Maybe there is a clean exit requirement, using Exit from the top menu? I admit to closing the application directly, and assuming that save has already taken place, there being no Save option. Short of doing 'Save As...' each time (which works, but is a pain), is there something I should be doing to ensure that the database saves in its updated state?

Re: Database not updating

Posted: Wed Apr 13, 2022 5:48 pm
by Renato
It would be helpful if you could tell us a little more, such as which operating system, which MMEX version and where the data is stored (local, cloud ??)

Re: Database not updating

Posted: Thu Apr 14, 2022 8:43 am
by Nickallington
Thank you - Windows 10, MMEX 1.5.11, and stored locally.

Re: Database not updating

Posted: Thu Apr 14, 2022 10:20 am
by Nikolay
I recommend to use portable version of the mmex https://github.com/moneymanagerex/money ... rtable.zip
Screenshot 2022-04-14 131517.png
Screenshot 2022-04-14 131517.png (7.36 KiB) Viewed 4214 times
Create a shortcut with the path to the DB filename.
Screenshot 2022-04-14 131730.png
Screenshot 2022-04-14 131730.png (23.55 KiB) Viewed 4212 times

C:\Portable_apps\mmex-My_Investments\bin\mmex.exe "paypal2020.mmb"

Re: Database not updating

Posted: Thu Apr 14, 2022 2:06 pm
by MartinArmstrong
Nickallington wrote: Thu Apr 14, 2022 8:43 am MMEX 1.5.11
Your version is several months old now.

It's worth keeping up with the latest stable release. It may not resolve the problem you were having but there are plenty of bug fixes in each release.

To check for updates, enable this option:

mmex_update.png
mmex_update.png (72.37 KiB) Viewed 4208 times

Re: Database not updating

Posted: Thu Apr 14, 2022 2:14 pm
by Nickallington
Thanks Martin, I get the popup reminding me to update, but haven't done it yet...

Re: Database not updating

Posted: Thu Apr 14, 2022 3:39 pm
by Renato
Is the Windows version also up to date.
Status 14.04.2022
Windows 10
Version : 21H2
Build : 19044.1645

Re: Database not updating

Posted: Mon Apr 18, 2022 9:29 pm
by dbolton
I'm trying to think why the backup would be good but not the working file. Any chance you had the database opened in two places at once? E.g. Two MoneyManagerEx windows on the same computer? Or two computers or devices that sync files?

Re: Database not updating

Posted: Thu Oct 06, 2022 9:28 am
by Nickallington
I haven't had the problem recently, but you highlight an important point. The files are stored in a bridge folder for an online backup service so that they can be accessible from other computers. I am guessing that if both computers are online and one updates the database, it is possible for corruption to occur if the other one validated the older version and then restored it. I have altered the backup settings on the second computer, and hopefully that will solve the problem.