Statistics-> COuntries worked

[g4pzk]

So I've been using log4omv2 for a week or so now with good experiences so far. I have set up automatic logging to clublog and lotw and looking online I see that they are being auto updated in real time or at program close down. I periodically use the Utilities->QSL facility to update from LOTW.
I'm currently only using log4om2 for auto logging via JTAlert of FT8 contacts, again that all seems to function cleanly.
So my question is why when I use View->Statistics I only see contacts I have had that session before closing down the program. After closing down the program (I guess it auto uploads to LOTW) I do not see any entries whatsover. I know that the SQL data is present not least because I can see it on my SQL server.

I'm very confused, what I am possibly doing to cause this?

Cliff, G4PZK

[g4pzk]

No hints from anybody?

Does anyone know the default SQL query that is used to populate this page before filters are applied? I literally get no records returned but there are 85 records in the database. I'm simply trying to see how many countries I have worked at this point.

Cliff, G4PZK

[G4POP]

where is the logfile stored?

[g4pzk]

Database file is on a MySQL server running on Linux. Debug log is wherever the debug log file would be. It's set to 'Info'

[G4POP]

Why are you using a MySql database and why on a Linux system?

[g4pzk]

Can't see what bearing that would have on the issue but I am using a MySQL server because I have already one existing on my general file server and it runs on Ubuntu 20.04 LTS. Is Log4OM2 not SQL based?

Cliff