Database not updating
Moderator: Renato
-
- New User
- Posts: 9
- Joined: Sat Dec 22, 2018 3:00 pm
- Are you a spam bot?: No
Database not updating
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?
-
- MVP User
- Posts: 682
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Database not updating
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
-
- New User
- Posts: 9
- Joined: Sat Dec 22, 2018 3:00 pm
- Are you a spam bot?: No
Re: Database not updating
Thank you - Windows 10, MMEX 1.5.11, and stored locally.
-
- 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
I recommend to use portable version of the mmex https://github.com/moneymanagerex/money ... rtable.zip
Create a shortcut with the path to the DB filename.
C:\Portable_apps\mmex-My_Investments\bin\mmex.exe "paypal2020.mmb"
Create a shortcut with the path to the DB filename.
C:\Portable_apps\mmex-My_Investments\bin\mmex.exe "paypal2020.mmb"
You do not have the required permissions to view the files attached to this post.
Last edited by Nikolay on Thu Apr 14, 2022 4:09 pm, edited 1 time in total.
-
- MVP User
- Posts: 300
- Joined: Tue Mar 02, 2021 10:24 am
- Are you a spam bot?: No
Re: Database not updating
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:
You do not have the required permissions to view the files attached to this post.
-
- New User
- Posts: 9
- Joined: Sat Dec 22, 2018 3:00 pm
- Are you a spam bot?: No
Re: Database not updating
Thanks Martin, I get the popup reminding me to update, but haven't done it yet...
-
- MVP User
- Posts: 682
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Database not updating
Is the Windows version also up to date.
Status 14.04.2022
Windows 10
Version : 21H2
Build : 19044.1645
Status 14.04.2022
Windows 10
Version : 21H2
Build : 19044.1645
Renato Forum Administrator
-
- Super User
- Posts: 126
- Joined: Fri Jan 03, 2020 3:24 pm
- Are you a spam bot?: No
Re: Database not updating
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?
-
- New User
- Posts: 9
- Joined: Sat Dec 22, 2018 3:00 pm
- Are you a spam bot?: No
Re: Database not updating
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.