Statistics Fields not populated after switching to MySQL DataBase.
Posted: 03 Feb 2020, 12:44
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
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