was statistic sql error

4 posts / 0 new
Last post
f8bqq
was statistic sql error

hi,

First of all ,i wish for everyone an happy new year 2010.

cqrlog 9.1

in windows statistic.
i ask for WAS confirmed+lotw
show station

TApplication.HandleException Dynamic SQL Error

SQL error code = -104

Token unknown - line 1, column 316

<>

Invalid token

Error Code: 249
Stack trace:
$084054E3
$08405394
$08406990
$083AFB88
$083AF226
$083AF042
$08150628
$082493C4
$0828A2FF
$0828A8E5
$0828AE41
$0828A19A
$0806A519
$0823FAA2
$082C55F7
$083516C0
$B7A36AEF

i only have error in WAS ,WAC works greats

73, Jorge

ok2cqr
ok2cqr's picture
Re: was statistic sql error

Hi Jorge,

please enable debug mode and paste here what CQRLOG writes down into console. Thank you.
How to enable debug mode is here:

http://www.cqrlog.com/?q=node/217#comment-542

73 Petr, OK2CQR

f8bqq
with debug=1

Starting CQRLOG ...
RootDirectory = /home/f8bqq/cqrlog/
RootDirectory = /home/f8bqq/cqrlog/
RootDirectory = /home/f8bqq/cqrlog/
ExternalFileAccess = Restrict /home/f8bqq/cqrlog/log_data
lock manager: couldn't set uid to superuser
SELECT * FROM version

SELECT * FROM cqrlog_main ORDER BY qsodate,time_on
In inicializerig
Model:1
Port:/dev/ttyS0
Baudrate:9600
Databits:8
StopBits:1
Handshake:None
Parity:None
DTR:OFF
RTS:OFF
Poll:500
Reloading rig configuration
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = 0

SFI: 80
A: 1
K: 0 (02 nT)
GF: QUIET
SSN: 18
Time: 1425 UT 01 Jan 2010
Closing Details window
SELECT * FROM cqrlog_main ORDER BY qsodate,time_on
l.Text:QSODATE
TIME_ON
TIME_OFF
CALL
RST_S
RST_R
FREQ
MODE
QSL_VIA
QSL_S
QSL_R
NAME
QTH
DXCC_REF
IOTA
PWR
ITU
WAZ
LOC
MY_LOC
COUNTY
AWARD
REMARKS
BAND
QSO_DXCC
PROFILE
ID_CQRLOG
IDCALL
STATE
LOTW_QSLSDATE
LOTW_QSLRDATE
LOTW_QSLS
LOTW_QSLR
CONT
QSLS_DATE
QSLR_DATE

SELECT COUNT (*) FROM bandcn WHERE prefix not like '%*'

select count(*) from bandcn where
((F160 = 'Q') OR
(F137 = 'Q') OR (C137 = 'Q') OR (D137 = 'Q') OR
(C160 = 'Q') OR (D160 = 'Q') OR (F80 = 'Q') OR
(C80 = 'Q') OR (D80 = 'Q') OR (F40 = 'Q') OR
(C60 = 'Q') OR (D60 = 'Q') OR (F60 = 'Q') OR
(C40 = 'Q') OR (D40 = 'Q') OR (F30 = 'Q') OR
(C30 = 'Q') OR (D30 = 'Q') OR (F20 = 'Q') OR
(C20 = 'Q') OR (D20 = 'Q') OR (F17 = 'Q') OR
(C17 = 'Q') OR (D17 = 'Q') OR (F15 = 'Q') OR
(C15 = 'Q') OR (D15 = 'Q') OR (F12 = 'Q') OR
(C12 = 'Q') OR (D12 = 'Q') OR (F10 = 'Q') OR
(C10 = 'Q') OR (D10 = 'Q') OR (F6 = 'Q') OR
(C6 = 'Q') OR (D6 = 'Q') OR (F2 = 'Q') OR
(F4 = 'Q') OR (C4 = 'Q') OR (D4 = 'Q') OR
(C2 = 'Q') OR (D2 = 'Q') OR (F70 = 'Q') OR
(C70 = 'Q') OR (D70 = 'Q') OR (F1300 = 'Q') OR
(C220 = 'Q') OR (D220 = 'Q') OR (F220 = 'Q') OR
(C1300 = 'Q') OR (D1300 = 'Q') OR (F2450 = 'Q') OR
(C2450 = 'Q') OR (D2450 = 'Q') OR (F3475 = 'Q') OR
(C3475 = 'Q') OR (D3475 = 'Q') OR (F5850 = 'Q') OR
(C5850 = 'Q') OR (D5850 = 'Q') OR (F10500 = 'Q') OR
(C10500 = 'Q') OR (D10500 = 'Q') OR (F24250 = 'Q') OR
(C24250 = 'Q') OR (D24250 = 'Q') OR (F47200 = 'Q') OR
(C47200 = 'Q') OR (D47200 = 'Q') OR (F84000 = 'Q') OR
(C84000 = 'Q') OR (D84000 = 'Q') OR
(F900 ='Q') OR (C900='Q') OR (D900='Q')
OR (F160L = 'L') OR
(F137L = 'L') OR (C137L = 'L') OR (D137L = 'L') OR
(C160L = 'L') OR (D160L = 'L') OR (F80L = 'L') OR
(C80L = 'L') OR (D80L = 'L') OR (F40L = 'L') OR
(C60L = 'L') OR (D60L = 'L') OR (F60L = 'L') OR
(C40L = 'L') OR (D40L = 'L') OR (F30L = 'L') OR
(C30L = 'L') OR (D30L = 'L') OR (F20L = 'L') OR
(C20L = 'L') OR (D20L = 'L') OR (F17L = 'L') OR
(C17L = 'L') OR (D17L = 'L') OR (F15L = 'L') OR
(C15L = 'L') OR (D15L = 'L') OR (F12L = 'L') OR
(C12L = 'L') OR (D12L = 'L') OR (F10L = 'L') OR
(C10L = 'L') OR (D10L = 'L') OR (F6L = 'L') OR
(C6L = 'L') OR (D6L = 'L') OR (F2L = 'L') OR
(F4L = 'L') OR (C4L = 'L') OR (D4L = 'L') OR
(C2L = 'L') OR (D2L = 'L') OR (F70L = 'L') OR
(C70L = 'L') OR (D70L = 'L') OR (F1300L = 'L') OR
(C220L = 'L') OR (D220L = 'L') OR (F220L = 'L') OR
(C1300L = 'L') OR (D1300L = 'L') OR (F2450L = 'L') OR
(C2450L = 'L') OR (D2450L = 'L') OR (F3475L = 'L') OR
(C3475L = 'L') OR (D3475L = 'L') OR (F5850L = 'L') OR
(C5850L = 'L') OR (D5850L = 'L') OR (F10500L = 'L') OR
(C10500L = 'L') OR (D10500L = 'L') OR (F24250L = 'L') OR
(C24250L = 'L') OR (D24250L = 'L') OR (F47200L = 'L') OR
(C47200L = 'L') OR (D47200L = 'L') OR (F84000L = 'L') OR
(C84000L = 'L') OR (D84000L = 'L') OR
(F900L ='L') OR (C900L='L') OR (D900L='L'))
and prefix not like '%*'

select distinct state,band,qsl_r from cqrlog_main where state <> '' and ((dxcc_ref='W(USA)') or (dxcc_ref='KL') or (dxcc_ref='KH6')) order by state

select distinct state,band from cqrlog_main where (state <> '') AND (lotw_qslr='L') and ((dxcc_ref='W(USA)') or (dxcc_ref='KL') or (dxcc_ref='KH6')) order by state

select distinct state,band from cqrlog_main where (state <> '') AND (qsl_r='Q') and ((dxcc_ref='W(USA)') or (dxcc_ref='KL') or (dxcc_ref='KH6')) order by state

select call,freq,mode,state from grb_cqrlog_main_state('(state <> '''') and ((dxcc_ref = ''W(USA)'') or (dxcc_ref=''KL'') or (dxcc_ref=''KH6'')) and ((qsl_r = ''Q'') or (lotw_qslr=''L''))') order by cast(freq as integer),state

TApplication.HandleException Dynamic SQL Error

SQL error code = -104

Token unknown - line 1, column 316

<>

Invalid token

Error Code: 249
Stack trace:
$084054E3
$08405394
$08406990
$083AFB88
$083AF226
$083AF042
$08150628
$082493C4
$0828A2FF
$0828A8E5
$0828AE41
$0828A19A
$0806A519
$0823FAA2
$082C55F7
$083516C0
$B7A4EAEF

have fun

ok2cqr
ok2cqr's picture
Re: with debug=1

Thank you. I'll fix it.

73 Petr, OK2CQR