Clublog Upload

5 posts / 0 new
Last post
DK1MAX
Clublog Upload

Hi

uploading to clublog is kinda "special"... Using CQRLOG 1.9.1 (005) on a Ubuntu 14.04 LTS system I get the following:

ClubLog: Uploading EP2A ... OK
ClubLog: Deleting original EP2A ... OK
ClubLog: Uploading updated EP2A ... OK
ClubLog: Deleting original EP2A ... OK
ClubLog: Uploading updated EP2A ... OK
ClubLog: Uploading WA8BIT ... OK
ClubLog: Uploading KA8G ... OK
ClubLog: Deleting original WA8BIT ... OK
ClubLog: Uploading updated WA8BIT ... OK
ClubLog: Deleting original KA8G ... OK
ClubLog: Uploading updated KA8G ... OK
ClubLog: Deleting original WA8BIT ... OK
ClubLog: Uploading updated WA8BIT ... OK
ClubLog: Deleting original KA8G ... OK
ClubLog: Uploading updated KA8G ... OK
ClubLog: Deleting original J38XX ... OK
ClubLog: Uploading updated J38XX ... OK
ClubLog: Deleting original ZL1BDW ... OK
ClubLog: Uploading updated ZL1BDW ... OK
ClubLog: Uploading NG3Y ... OK
ClubLog: Uploading 8P6DR ... OK
ClubLog: Deleting original NG3Y ... OK
ClubLog: Uploading updated NG3Y ... OK
ClubLog: Deleting original 8P6DR ... OK
ClubLog: Uploading updated 8P6DR ... OK
ClubLog: Deleting original NG3Y ... OK
ClubLog: Uploading updated NG3Y ... OK
ClubLog: Deleting original 8P6DR ... OK
ClubLog: Uploading updated 8P6DR ... OK
ClubLog: Uploading EP2A ... OK
ClubLog: Deleting original EP2A ... OK
ClubLog: Uploading updated EP2A ... OK
ClubLog: Deleting original EP2A ... OK
ClubLog: Uploading updated EP2A ... OK
ClubLog: Deleting original S0S ... OK
ClubLog: Uploading updated S0S ... OK
ClubLog: Deleting original S0S ... OK
ClubLog: Uploading updated S0S ... OK
ClubLog: Deleting original WA8BIT ... OK
ClubLog: Uploading updated WA8BIT ... OK
ClubLog: Deleting original J38XX ... OK
ClubLog: Uploading updated J38XX ... OK
ClubLog: Uploading HC2/R7AA ... OK
ClubLog: Deleting original HC2/R7AA ... OK
ClubLog: Uploading updated HC2/R7AA ... OK
ClubLog: Deleting original HC2/R7AA ... OK
ClubLog: Uploading updated HC2/R7AA ... OK
ClubLog: Uploading VE6UX ... OK
ClubLog: Uploading KB9IFH ... OK
ClubLog: Deleting original VE6UX ... OK
ClubLog: Uploading updated VE6UX ... OK
ClubLog: Deleting original KB9IFH ... OK
ClubLog: Uploading updated KB9IFH ... OK
ClubLog: Deleting original VE6UX ... OK
ClubLog: Uploading updated VE6UX ... OK
ClubLog: Deleting original KB9IFH ... OK
ClubLog: Uploading updated KB9IFH ... OK
ClubLog: Uploading VK9L/G7VJR ... OK
ClubLog: Deleting original VK9L/G7VJR ... OK
ClubLog: Uploading updated VK9L/G7VJR ... OK
ClubLog: Deleting original KB9IFH ... OK
ClubLog: Uploading updated KB9IFH ... OK
ClubLog: Deleting original VE6UX ... OK
ClubLog: Uploading updated VE6UX ... OK
ClubLog: Deleting original VE6UX ... OK
ClubLog: Uploading updated VE6UX ... OK
ClubLog: Deleting original DK6IM
ClubLog: Could not delete original QSO data!

What am I doing wrong? The upload repeats deleting and uploading unchanged log entries all the time and when an entry can't be deleted (why?) the upload hangs. Any idea on how to fix this?
I tried marking all QSOs as uploaded.. but it obviously doesn't help.

Thanks and 73

Max - DK1MAX

ok2cqr
ok2cqr's picture
Hi Max,

Hi Max,

very interesting. Open QSO list window -> Filter menu -> SQL console. Enter there this SQL command:

select * from log_changes order by id desc limit 20;

and hit the green button. It will show last 20 items. Please click on the second icon from the right (Export) and export all QSO to a CSV file. The file could help me to find out what is wrong, put it here to the forum as an attachment. Thank you!

To fix this upload problem, in QSO list window -> Online logs -> Mark all QSO as uploaded. Export all QSO to an ADIF file and upload it to ClubLog by hand. After you save a new QSO, it will be uploaded to ClubLog.

73 Petr, OK2CQR

DK1MAX
export file

Petr, here we go. Please find the export csv as an attachment (txt file).

73... Max - DK1MAX.

File: 

ok2cqr
ok2cqr's picture
RE: export file

Thank you, Max!

I have no idea what could cause so many UPDATE items. The UPDATE, INSERT and DELETE commands in this table came from trigger assigned to the cqrlog_main table. Maybe there is a bug in one of them, I'll check it out.

DK1MAX
update

just an update...

running CQRLOG 2.0.0 (001) now on Ubuntu 16.04 LTS and the clublog upload issue is still there.

73... Max. DK1MAX.