Database not updating

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

Moderator: Renato

Post Reply
Nickallington
New MMEX User
Posts: 9
Joined: Sat Dec 22, 2018 3:00 pm
Are you a spam bot?: No

Database not updating

Post 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?
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 not updating

Post 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 ??)
Renato Forum Administrator
Nickallington
New MMEX User
Posts: 9
Joined: Sat Dec 22, 2018 3:00 pm
Are you a spam bot?: No

Re: Database not updating

Post by Nickallington »

Thank you - Windows 10, MMEX 1.5.11, and stored locally.
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 not updating

Post 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 3644 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 3642 times

C:\Portable_apps\mmex-My_Investments\bin\mmex.exe "paypal2020.mmb"
Last edited by Nikolay on Thu Apr 14, 2022 4:09 pm, edited 1 time in total.
MartinArmstrong
MVP MMEX User
Posts: 300
Joined: Tue Mar 02, 2021 10:24 am
Are you a spam bot?: No

Re: Database not updating

Post 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 3638 times
Nickallington
New MMEX User
Posts: 9
Joined: Sat Dec 22, 2018 3:00 pm
Are you a spam bot?: No

Re: Database not updating

Post by Nickallington »

Thanks Martin, I get the popup reminding me to update, but haven't done it yet...
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 not updating

Post by Renato »

Is the Windows version also up to date.
Status 14.04.2022
Windows 10
Version : 21H2
Build : 19044.1645
Renato Forum Administrator
dbolton
Super MMEX User
Posts: 126
Joined: Fri Jan 03, 2020 3:24 pm
Are you a spam bot?: No
Contact:

Re: Database not updating

Post 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?
Nickallington
New MMEX User
Posts: 9
Joined: Sat Dec 22, 2018 3:00 pm
Are you a spam bot?: No

Re: Database not updating

Post 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.
Post Reply