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

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

Moderator: Renato

bigessay
New User
Posts: 7
Joined: Wed Jun 15, 2022 7:51 pm
Are you a spam bot?: No

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

Post by 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.
User avatar
Renato
MVP User
Posts: 750
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

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

Post by Renato »

You do not have the required permissions to view the files attached to this post.
Renato Forum Administrator
bigessay
New User
Posts: 7
Joined: Wed Jun 15, 2022 7:51 pm
Are you a spam bot?: No

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

Post by 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.
You do not have the required permissions to view the files attached to this post.
User avatar
Renato
MVP User
Posts: 750
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

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

Post by 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
Renato Forum Administrator
bigessay
New User
Posts: 7
Joined: Wed Jun 15, 2022 7:51 pm
Are you a spam bot?: No

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

Post by 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.
User avatar
Renato
MVP User
Posts: 750
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

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

Post by 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
Developer
Posts: 346
Joined: Fri Aug 21, 2020 5:44 pm
Are you a spam bot?: No

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

Post by whall3y »

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