Statistics Fields not populated after switching to MySQL DataBase.

[IU0LFQ]

Hi,

I switched from SQLite to MySQL DB following the steps below:
1. Global ADIF generation via Log4OM Export Utility
2. DB Creation and Log4OM2 Connection (all tests and permissione reported OK).
3. ADIF Import into MySQL via Log4OM Import Utility.
4. Check MySQL 'log' table (populated with the exact QSO number and data, checked direct via SQL Query)


Everything seems to be OK, except the 'Statistics' fields population after typing a new callsign in the Callsign Log4OM field. It always display 'New-One' and bands/modes indicators remain empty.
It seems like the past QSOs are not read/evaluated by the SW (even if the QSO archive is populated and dsplayed in the "Recent QSO's" table).


Platform Info:
Log4OM: 2.2.0.0
MySQL Server: 5.7 (on Ubuntu, separate BOX)
CAT: via OmniRig


Many thanks, best 73!
-A

[G4POP]

Did you try settings/maintenance/rebuild statistics and rescan QSO references

[IU0LFQ]

Hi,

thanks for your reply.

- "rescan qso reference", give me a notification about the completed process (but there is no effect in relation to the problem).
- "Rebuild Statisctics" has no effect (and no notification is generated, I waited for more then 15 minutes before writing this feedback).


Any other idea?


Many thanks! 73!
-A