INFOTABLE_V1: Exception unable to open database file[14]:

[bigessay]

So I have downloaded SQLite3 in the hope that I can debug it.

I saved my .MMB by renaming a copy as .DB and opening it in SQLite3.
Then .clone as NEWDB.DB, then renaming that as .MMB.
When I try to open it (open Existing Database) in MMEX, I get a popup message:

"MMEX upgrade
Have MMEX support provided you with a debug/patch file?"

It is trying to copy NEWDB,mmb to NEWDB.mmb_upgrade_v0_YYYY-MM-DD.bak, but needs a debug/patch file in order to do this.

Otherwise, I am stuck trying to resolve the inability to debug my MMB with years of finance data.
Your help would be gratefully received.

[bigessay]

The first part of my topic was:

Win64 11, MMEX v1.5.15 64bit

On every navigation operation, I am getting popup error messages:
NFOTABLE_V1: Exception unable to open database file[14]
with a variety of
INFOID
INFONAME
INFOVALUE
Each table takes an age to load.
Although I (apparently successfully) Import a CSV of transactions, they do not appear in the account, and are not saved when I quit MMEX.

This first started over a week ago on v1.5.14, and upgrading to v1.5.15 has not improved it.

File/ Save Database As ... does not work. Explorer comes back with an inappropriate message:
"path/filename
File not found.
Check the filename and try again."

[Renato]

Probably a problem with the access rights to the database or other files of MMEX.

[bigessay]

Probably a problem with the access rights to the database or other files of MMEX.

Thank you Renato.
I checked the properties of mmex.exe and added write permission for myself as user.
Also the database file .mmb, which had all the necessary permissions.
But I still get the same issues.

There are 112 dll files as well, which do not have write permission for me as user.
Can you advise which may need to have write permissions added?

I have also tried running mmex as administrator, but still get the same issues.

[dbolton]

Any chance you have the database open in two places?

Just to rule it out, have you restarted the computer?

[Renato]

Suggestion:
1) Download the latest version https://ci.appveyor.com/project/moneyma ... /artifacts
2) install this version with option delete old version.
3) copy .mmb database to documents folder if it is not already there.
4) start MMEX and select this .mmb database.

But see also in the personal messages.

[bigessay]

I have installed the latest v1.5.16 as you describe but still get the same INFOTABLE_V1 errors.
I have sent you a private message.

[whall3y]

Do you have the DB open in MMEX and SQLite3 at the same time?

If not, then it sounds like it is having permissions problems accessing the settings file. Have you tried the standalone version of MMEX?

[Renato]

Hello Bigessay

Your .mmb database is perfectly fine, I was able to open it without any problems.

I suspect that the permissions to access the Documents folder are not set correctly.

As a trial, I would save the .mmb to another directory (using CTRL-C and CTRL-V) and then open it in MMEX.

It could also be errors in the file system, which can be analyzed with the Windows Terminal (Administrator) (right mouse button on Windows Start) by entering chkdsk c: and fixed with chkdsk c: /f (requires a restart of Windows).

Another possibility is to delete the file mmexini.db3, it contains the settings of MMEX and is automatically recreated with default values.

[whall3y]

Another possibility is to delete the file mmexini.db3, it contains the settings of MMEX and is automatically recreated with default values.

My thoughts were the mmexini.db3 hence the reason for asking to run the standalone version.

[bigessay]

Thank you all for chipping in.
Tried checking the file system with chkdsk - no file errors.
I have tried putting the MMB in a different folder, but get the same INFOTABLE_V1 errors.
I tried deleting mmexini.db3, still get the errors.
As far as I can tell (Task Manager) I do not have sqlite3 running. I only installed it to try to check my MMB file, so the problem existed before that.
Not sure what the standalone version of MMEX is - I assumed that is what I am using.

I am going to try to uninstall MMEX completely, and then do a clean reinstall.

Thanks again.

[Renato]

On: https://moneymanagerex.org/docs/downloads/latest/ there are:
https://github.com/moneymanagerex/money ... -win64.exe
https://github.com/moneymanagerex/money ... rtable.zip
to download.
.

MMEX01.png (73.89 KiB) Viewed 1924 times

[bigessay]

I have installed the portable version (having uninstalled the 1.5.16 I had), but still get all the same issues with INFOTABLE_V1 errors.

Presumably the cause of "Exception unable to open database file[14]" must be understood by a developer?
The fact that I cannot save even a new empty MMB must be significant?
File/ Save Database As ... does not work. On "Choose database file to create" Explorer comes back with an inappropriate message as per my screen snip:
"[path/filename]
File not found.
Check the filename and try again."

I have used MoneyManager EX for years without any issues, last on 31/05/2022, then had these issues from trying on 15/06/2022.

There was a Microsoft update which I installed on 05/06/2022:
2022-05 Cumulative Update Preview for .NET Framework 3.5 and 4.8 for Windows 11 for x64 (KB5013889)
Then on 15/06/2022:
2022-06 Cumulative Update for Windows 11 for x64-based Systems (KB5014697)
Today I installed another update:
2022-06 Cumulative Update for Windows 11 for x64-based Systems (KB5014668)

I am wondering if the first of those updates introduced the issue, as I am convinced it is a Microsoft issue, not MMEX (except that it uses Microsoft components).

I am stumped, as I have now tried all your suggestions.

[Renato]

I would try to run MMEX.EXE with administrator privileges.
All the messages are puzzling for me.
Which virus scanner is used (Microsoft Defender or another), does it have entries there?
.
Maybe this will help:
a) Press the key combination [Windows] + [R] to open the Run window.
Type shutdown -g -t 0 and confirm with [Enter].
Windows restarts and after the restart also all registered applications.
b) Start Windows Terminal (Administrator)
run Dism /Online /Cleanup-Image /RestoreHealth
run sfc /scannow

[bigessay]

Renato, thank you so much.

It turns out that Defender has recently decided to not allow "suspicious" apps (as it regards MMEX) to modify certain folders, including both Documents and the folder where I have my MMB files.

Microsoft/Edge has recently been making it quite difficult to download MMEX updates, where I have to override not downloading, not opening and not installing.

I have tried telling Microsoft/Edge that MMEX should be an allowed app.

Now that I have gone into Defender and seen that these folders have been "protected", I have been able to allow changes, and MMEX now works properly.
Settings - Privacy & Security ->Windows security - App & browser control - Protection history
Click on the relevant item and allow
or Ransomware Protection, turn Controlled folder access to OFF.
[not exactly easy to navigate!]

I am sorry for all of us that it has taken so much effort to identify this issue, but hopefully other users will now benefit.

Thanks again.

[Renato]

Hello Bigessay

Congratulations, we are glad that the problem is now solved.
Thank you very much for your feedback.
It is not always easy to make a remote diagnosis, but we usually manage to solve such a problem with our combined forces.
We wish you a lot of fun with MMEX.

With greetings from Switzerland
Renato

[whall3y]

I guess we need to progress this... https://github.com/moneymanagerex/money ... ssues/2355