Page 1 of 1

Statistics Fields not populated after switching to MySQL DataBase.

Posted: 03 Feb 2020, 12:44
by 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

Re: Statistics Fields not populated after switching to MySQL DataBase.

Posted: 03 Feb 2020, 14:19
by G4POP
Did you try settings/maintenance/rebuild statistics and rescan QSO references

Re: Statistics Fields not populated after switching to MySQL DataBase.

Posted: 03 Feb 2020, 15:30
by 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