Page 1 of 1

V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Sun Apr 18, 2021 7:59 am
by Radix
Hi all,
after downloading the new MMEX version 1.5.0 I have successfuly opened my database and after few days of working with it suddenly does not allow me to enter new transactions or even edit the old one. I have tried to open other databases, backups, but neither these are working. I even tried to open the database from version 1.5.0 in an old version of MMEX 1.3.5 and the issue remained the same. Do you have any tips of how to make it work?

Thanks a lot for your help!

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Sun Apr 18, 2021 8:20 am
by Renato
maybe it helps to delete the file .db3.

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Sun Apr 18, 2021 8:37 am
by Nikolay
1) download and extract to c:\temp\ folder
https://sourceforge.net/projects/moneym ... p/download
2) Copy your .mmb file to the same folder.
3) check .mmb file propeties. Should not be "Read only".
4) Run "C:\temp\mmex-1.5.0-win32\bin\mmex.exe"
5) open the copy of your .mmb file from c:\temp by "Open Existing Database" button of the start dialog.

Working?

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Sun Apr 18, 2021 8:51 am
by Radix
Renato, I did not find the .db3 file, hence, I could not deleted. I found the .db3 file in the solution proposed by Nikolay.

Nikolay, thank you very much! It worked! I re-checked that I really have the 64bit version of Windows, however, the portable MMEX version for win32 is working. Thank you once again :)

Thank you both, guys, for your help and effort. I really appreciate it :)

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Sun Apr 18, 2021 11:44 am
by Nikolay
The file should be here:

"C:\Users\xxx\AppData\Roaming\MoneyManagerEx\mmexini.db3"

It does not metter 64bit or 32.

I recomment to delete the mmexini.db3 from user profile it should help.

But I prefer portable mmex becouse it easy to take it to anothe PC (in case of an upgrade for exanple).

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Thu Jul 01, 2021 2:49 pm
by TimC
Hello

I am experiencing the same problem except I am using v1.5.3 on MacOS. Is there a similar solution for the MacOS version?

Many thanks!

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Thu Jul 01, 2021 3:07 pm
by Renato
This might solve the problem, mmexini.db3 contains the settings but no data.

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Thu Jul 01, 2021 3:32 pm
by whall3y
TimC wrote: Thu Jul 01, 2021 2:49 pm Hello

I am experiencing the same problem except I am using v1.5.3 on MacOS. Is there a similar solution for the MacOS version?

Many thanks!
For MacOS the .db3 file can be found be opening a terminal and typing below (change '####' to your user directory name)

Code: Select all

cd "/Users/####/Library/Application Support/MoneyManagerEx/"
ls
rm mmexini.db3

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Fri Jul 02, 2021 9:59 am
by TimC
Hello whall3y

Many thanks for your swift response to my problem! I have tried your suggested solution but unfortunately nothing has changed. There is a sound as if the transaction is being entered but nothing appears in the database. Sorry to be a pain but do you have any other suggestions?!

Many thanks!

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Fri Jul 02, 2021 4:50 pm
by Renato
Does the database file xxxx.mmb have write permissions.

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Fri Jul 02, 2021 5:23 pm
by whall3y
Yes, sounds like a DB permission issue. Just tried removing write permission from a test DB and it has the same effect as you describe.

Try giving the DB write permissions for your account.

In Finder, select you DB file then select "Get Info". Make sure the permissions are Read/Write for your account.

https://www.macinstruct.com/tutorials/h ... -mac-os-x/

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Sat Jul 03, 2021 9:22 am
by TimC
Yes I have checked the database file and it shows read/write permission for me but read only for admin and everyone. I have tried changing to read/write for admin and everyone but it seems to default back to read only for them.

I have tried reloading the software but that does not seem to make any difference.

Anything else I can try?

Many thanks!

Tim

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Sat Jul 03, 2021 5:52 pm
by MartinArmstrong
What happens if, for test purposes, you create a new database (File | New Database) and select a different location for the new .mmb file? A location that you know you definitely have read/write permissions.

Can you enter transactions is the new database?

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Sat Jul 03, 2021 6:50 pm
by whall3y
TimC wrote: Sat Jul 03, 2021 9:22 am Anything else I can try?
Where is file located, can you share the path?
Is it on a network drive, a Google/iCloud/Dropbox drive, etc?

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Sun Jul 04, 2021 8:27 am
by TimC
Many thanks for your replies.

I have tried creating a new database but I am still unable to enter a transaction in the new database. It let me create a new account after a bit of difficulty with the currency (it kept coming up with an error notice when I clicked on the currency box).

I currently store the file on One Drive because I need to access it from two different computers in different locations and have wondered whether this is an issue. However, it worked for years when I was using a Windows PC and also worked perfectly when I switched to a new iMac recently. The current location is "users/timcarden/Documents/OneDrive/Documents/Money Manager/filename".

Thanks for all your help.

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Sun Jul 04, 2021 9:27 am
by whall3y
On your iMac can you try the latest 1.5.4 beta here: https://mmex.ipx.co.uk please.

Can you also confirm that the issue still occurs when the DB is not on OneDrive.

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Sun Jul 04, 2021 10:19 am
by Renato
Is One Drive mounted as a drive ?
Otherwise you probably work with a local copy that has to be synchronized.

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Mon Jul 05, 2021 3:36 pm
by TimC
Hi Guys

I really appreciate your help but I am beginning to despair because MMEX is a fantastic tool and I have relied on it for some years now.

I have tried moving the database to the hard drive and then opening it from there, without success. I have also downloaded the 1.5.4 beta version and also had no luck. I agree with Renato that I probably work with a local copy that then synchronises with One Drive when I close the database

I am not a computer expert and I am sure I am doing something wrong, having recently changed from PC to Mac, so I am not that familiar with MacOS. However I have been using it on the Mc for about a month without a problem and cannot think of anything I have done that is unusual!

Thanks for your efforts but any further suggestions would be appreciated!

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Mon Jul 05, 2021 4:01 pm
by TimC
Hello again

What I have succeeded in doing is creating a new database in 1.5.4 (saved on the iMac) which allows me to enter transactions, so I think I am just going to have to rebuild my database from the start.

Is it possible that there is a limit to the size of the database and I have filled it up. I cannot believe that is possible with just my personal accounts but I cannot think of any other reason!

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Mon Jul 05, 2021 5:40 pm
by whall3y
TimC wrote: Mon Jul 05, 2021 4:01 pm Hello again

What I have succeeded in doing is creating a new database in 1.5.4 (saved on the iMac) which allows me to enter transactions, so I think I am just going to have to rebuild my database from the start.

Is it possible that there is a limit to the size of the database and I have filled it up. I cannot believe that is possible with just my personal accounts but I cannot think of any other reason!
You have not exceeded the DB size unless in was greater than about 281TB !!!

It really does look like there was some permission issue on the DB file.

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Tue Jul 06, 2021 10:06 am
by TimC
Sorry! Me again! One last try in case it triggers anything!

I was going well creating a new database (using 1.5.4 beta version) and I was able to create new accounts and enter transactions until.....I closed the database for a break. When I reopened the database (saved on Mac and not on One Drive) I was no longer able to enter transactions. Grrrr! I checked the permissions on the new file and it showed 'read and write' permission for me. I changed 'staff' and 'everyone' to 'read and write' just in case but was still not able to enter transactions.

As I say, one last attempt in case this triggers anything in your minds. Otherwise I will have to look for another option. Thanks again for your efforts to help me!

Tim

Re: V1.5.0 - 64bit - I cannot enter new transaction to database

Posted: Tue Jul 06, 2021 11:53 am
by Renato
In my opinion, the problem does not lie with MMEX, otherwise we would certainly have several such reports.
Would it be possible to ask the local iMac vendor for advice.