I recently changed MySQL servers and exported (mysqldump) cqrlog_common and cqrlog001 databases. All the data came over fine. I can query the cqrlog_main table and everything is in there. Even custom views I created were imported successfully on the new server.
The issue is when I connect the cqrlog application to it, the QSO List window is blank. The data are not missing. The QSO List window shows "QSO in log" and "DXCC CFM" correctly, and all the contacts are in the Statistics window. Just no rows in the main window.
Does anyone have a solution for this? Ver. 2.5.2
TIA, 73
Kevin W2NC
Hi Kevin!
Have you tried to create a fiter, or use qso_list/file/Search(by callsign)?
Do they show up qsos?
If do, then release filter with Shift+F12. Do all qsos appear then?
You could also try to update CqrlogAlpha. https://github.com/OH1KH/CqrlogAlpha/tree/main/compiled Download and run newupdate.sh
As you seem to have your databases on external sql server do just fresh sqldump from all databases beginning cqr% before upgrading.
Upgrade will alter some tables. They should be backward compatible, but backup to be sure that you can restore old ones if returning back to 2.5.2
newupdate.sh does backups while updating, but can not dump external sql server.
--
Saku
OH1KH