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!"
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!"
There are currently 0 users online.
Please run cqrlog in console with --debug=1 parameter and paste here details from console. Thank you!
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
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!
Thank you! It seems you've entered wrong frequency. 17.118210555 is not correct. That will be the problem.
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
AAAHH! Thanks Peter. A complete brain cramp. 17 meters on 18Mhz.