Fails to upload saved qso

3 posts / 0 new
Last post
kd9jqr
Fails to upload saved qso

When I save a QSO I get this message even though I have deleted the W7CPA QSO.

HamQTH: Uploading W7CPA
HamQTH: When uploading a QSO, at least qso_date, time_on, call, band and mode fields must be specified!

I found these errors in the data base error log.

2018-04-30T14:22:11.574639Z 5 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2018-04-30T14:22:11.575338Z 5 [ERROR] InnoDB: Fetch of persistent statistics requested for table `cqrlog001`.`upload_status` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

Any suggestions.

Thanks.

oh1kh
Fails to upload saved qso

if you drop this whole line:

but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead

to google search there will be many hits and possible fixes. It looks like database is corrupted.
One was happened because hard disk was full. How about yours? Check this in console with command:

df -h

And one because permissions to database files were somehow went wrong. To be sure for that give console command:

sudo chown -R name.name /home/name

Where "name" is your username.
Sudo is there in case there is files owned by root in your user directory. (Never run cqrlog as root!) If you have common cqrlog setup your database files are at your /home/name/.config/cqrlog/database folder and they will be checked with that command.
If you use system mysql server at localhost(or any other adderss) at port 3306 with cqrlog then you have to check server database files different way depending your setup.

One solution would be to export all qsos to adif. Then save all settings from "file/open or create new log/Utils/configuration/export". Then move your cqrlog files to save place. Shut down cqrlog first (then from console):

mv ~/.config/cqrlog ~/.config/cqrlog_save

Then start it again and it starts like you never had used it before. Create new log. Import settings to new log from "file/open or create new log/Utils/configuration/import" and last do adif import of all qsos.

--
Saku
OH1KH

ok7an
ok7an's picture
Re: Fails to upload saved qso

Hi,

this is a bug in cqrlog that allows you to enter wrong freq outside ham bands. HamQTH doesn't accept upload with wrong frequency and returns an error. The only solution is to fix the freq manually, upload the adif file again by hand and make all qso as uploaded. It's already fixed in new version which will be released soon.

73 Petr