HamQTH: When uploading a QSO, at least qso_date, time_on.....

5 posts / 0 new
Last post
kf7sje
HamQTH: When uploading a QSO, at least qso_date, time_on.....

Uploading to HamQTH has been working just fine last week and now I am receiving this error message. any help would be appreciated.

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

ok2cqr
ok2cqr's picture
Re: HamQTH: When uploading a QSO, at least qso_date, time_on...

Please run cqrlog in console with --debug=1 parameter and paste here details from console. Thank you!

kf7sje
Read out for debug=1 parameter

Hi Peter,
This is the readout for debug=1 parameter when running cqrlog from terminal. I am new to linux so I am learning how to use the terminal. Hope this is what you are asking for.
-Best
DougR K6MXZ (KF7SJE)

cqrlog debug=1 PARAMETER

**** DEBUG LEVEL 1 ****

Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.500000000000000000E+00
**********************************
Loaded 89360 LoTW users
Loaded 95510 eQSL users
Loaded 46102 SCP calls
/home/rehder/.config/cqrlog/database/gunner.pid
Command:
kill 4184
*
User home directory: /home/rehder/
Program home directory: /home/rehder/.config/cqrlog/
Data directory: /home/rehder/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.5
*
Trying to connect to database
160110 10:10:48 [Note] /usr/sbin/mysqld (mysqld 5.5.46-MariaDB-1ubuntu0.14.04.2) starting as process 4282 ...
Server connect failed.
Trying:1
Trying to connect to database
Server connect failed.
Trying:2
select * from tables where table_schema = 'cqrlog_common'

SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr

use cqrlog001

use cqrlog001

use cqrlog001

use cqrlog001

use cqrlog001

SELECT * FROM cqrlog_config

select * from db_version

select * from cqrlog_common.db_version

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:-m 1 -r -t 4532
RunRigCtld: FALSE
RigDevice:
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 1

rigctld started!
Connected to localhost:4532

Settings:
-----------------------------------------------------
RotCtldPath:/usr/bin/rotctld
RotCtldArgs:
RunRotCtld: FALSE
RotDevice:
RotCtldPort:4533
RotCtldHost:localhost
RotPoll: 500
RotId: 1

rotctld started!
Connected to localhost:4533
CW init
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = -1

SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = -1

select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0

LoadForm: frmMain
SELECT COUNT(*) FROM cqrlog_main

select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in (2,8,19,23,25,26,28,30,39,42,44,55,57,58,59,67,68,81,85,93,101,102,113,115,119,127,128,139,151,154,155,164,178,183,184,186,193,193,194,196,198,200,208,210,218,220,226,228,229,231,243,244,255,258,261,264,267,268,271,307,488,493))) as foo

select count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif<>0 and (dxcc_ref NOT LIKE '%*') AND (qsl_r = 'Q')) as foo

select * from upload_status where logname='HamQTH'

select * from log_changes where id > 12 order by id

SyncUpdate:
SyncMsg :HamQTH: Uploading W5EIY
select * from log_changes where id = 13

select * from cqrlog_main where id_cqrlog_main = 12

data.Text:
u=K6MXZ
p=isabella@15
prg=CQRLOG
adif=201601032104W5EIYSSB17.11821055559BillEnidNNEM16BKDM13JG10074OKOK,GarfieldNNNA
cmd=INSERT

-----------
Response :When uploading a QSO, at least qso_date, time_on, call, band and mode fields must be specified!

ResultCode:400
-----------
SyncUpdate:
SyncMsg :HamQTH: When uploading a QSO, at least qso_date, time_on, call, band and mode fields must be specified!

ok2cqr
ok2cqr's picture
Re: Read out for debug=1 parameter

Thank you! It seems you've entered wrong frequency. 17.118210555 is not correct. That will be the problem.

kf7sje
18Mhz for 17 meters

AAAHH! Thanks Peter. A complete brain cramp. 17 meters on 18Mhz.