Duplicate column name 'Upddeleted'

9 posts / 0 new
Last post
UA6CEY
Duplicate column name 'Upddeleted'

Hello Petr!

I compiled a new (1.9.1) version.
I used an old cqrlog.cfg file when I run it.
A message Database upgrade crashed with this error:
: Error executing query: Duplicate column name 'upddeleted'

has appeared. CQRLOG worked but I could see nothing in DXCLUSTER window
Then I downgraded to 1.8.1 (previous) version but error message still remains/ DXCLUSTER doesn't work too. Deletion of cqrlog.cfg has no effect.
Where to dig?

73! Andrey

ok2cqr
ok2cqr's picture
Re: Duplicate column name 'Upddeleted'

Hi Andrey,

please open QSO list window, go to Filtr menu and choose SQL console.
Enter there this SQL command:

select * from db_version

and click to green arrow, it's the first icon from the left. What is the value in db_version field, please?

73 Petr, OK2CQR

UA6CEY
Duplicate column name 'Upddeleted'

Hi Petr
db_version nr 8
I'm a CQRLOG user since ver. 1.5.0

ok2cqr
ok2cqr's picture
Re: Duplicate column name 'Upddeleted'

Thanks! Now open SQL console again and enter this command:

update db_version set nr = 10

click to green arrow. It looks like nothing happened but it did something. Now close CQRLOG and start it again. It will try to do another database upgrade and cluster should work.

73 Petr

UA6CEY
Re: Duplicate column name 'Upddeleted'

Now db_version is 10/
But DXCluster window has no spots, except spots to ALL
It looks like this at teminal window:::::

login:
ua6cey
Hello Andrey, this is RW3XA-8 in Obninsk
running DXSpider V1.55 build 0.146

#########################################################

R W 3 X A - 8

Obninsk DX Cluster (ODXC) since 1999
Web monitor URL: http://odxc.ru
Telnet (interactive) URL: telnet://odxc.ru:8000

DON'T USE CLUSTER IP ADDRESS AND PLEASE CHANGE NAME TO:

#### #### # # #### #### # #
# # # # # # # # # # #
# # # # ## # #### # #
# # # # # # # # # # #
#### #### # # #### ## # # ####

#########################################################

Cluster: 395 nodes, 18 local / 5083 total users Max users 7192 Uptime 7 07:14
UA6CEY de RW3XA-8 23-Feb-2016 1946Z dxspider >
DX de K1RO: 14347.0 K7MK NPOTA 1946Z
Enter critical section On Receive
Leave critical section On Receive
Found - K7MK
SELECT * FROM cqrlog_common.bands where (b_begin <=14.347 AND b_end >=14.347) ORDER BY b_begin

SELECT * FROM cqrlog_common.bands where (b_begin <=14.347 AND b_end >=14.347) ORDER BY b_begin

SELECT id_cqrlog_main FROM cqrlog001.cqrlog_main WHERE adif=291 AND band='20M' AND qsl_r='Q' AND mode='SSB' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog001.cqrlog_main WHERE adif=291 AND band='20M' AND mode='SSB' LIMIT 1

SELECT id_cqrlog_main FROM cqrlog001.cqrlog_main WHERE adif=291 AND band='20M' LIMIT 1

dx_prefix:W
dx_cont: NA
Freq: 14.347
Call: K7MK
Color: clBlack
Index_: 3
select * from call_alert where callsign = 'K7MK'

DX de R2LAC: 7021.0 EG5WAP CQ Loud 1947Z
Enter critical section On Receive
Leave critical section On Receive
DX de HI3TT: 18135.0 HI0UD USB 1947Z FK49
Enter critical section On Receive
Leave critical section On Receive
DX de WD5DJX: 18150.0 W3FF 59 SSB BICYCLE MOBILE TNX BUDD 1946Z EM34
Enter critical section On Receive
Leave critical section On Receive
DX de AC9NE: 7188.0 KB3SBC 59 Indiana 73 MN07 1947Z EM78
Enter critical section On Receive
Leave critical section On Receive
DX de WA6SCW: 21072.3 VP8LP PSK125 1947Z DM33
Enter critical section On Receive
Leave critical section On Receive
DX de N6PAT: 18110.0 TEST test please ignore 1947Z
Enter critical section On Receive
Leave critical section On Receive
DX de K9ORN: 21250.0 V51WW 1947Z
Enter critical section On Receive
Leave critical section On Receive
DX de WK2S: 7060.0 KA4RRU npota tr23 1948Z
Enter critical section On Receive
Leave critical section On Receive
DX de NA2NY: 21070.0 KG4PH easy first call 1948Z FN33
Enter critical section On Receive
Leave critical section On Receive

ok2cqr
ok2cqr's picture
Re: Duplicate column name 'Upddeleted'

Please open SQL console again and enter this command:

show tables;

It should show you all tables in cqrlog database. One of them should be call_alert. Do you see it in the list, please?

UA6CEY
Show Tables result:

Show Tables result:

Tables_in_cqrlog001
club1
club2
club3
club4
club5
cqrlog_config
cqrlog_main
db_version
dxcc_id
log_changes
long_note
notes
profiles
upload_status
version
view_cqrlog_main_by_callsign
view_cqrlog_main_by_qsodate
zipcode1
zipcode2
zipcode3

There is no call_alert table

ok2cqr
ok2cqr's picture
Re: Show Tables result:

That is the problem why CQRLOG doesn't show any spot.
Open SQL console, and enter this command:

CREATE TABLE call_alert (
id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
callsign varchar(20) NOT NULL,
band varchar(6) NULL,
mode varchar(6) NULL
) COLLATE 'utf8_bin';

and hit the green arrow.

It should create the table.

UA6CEY
Now it works

Hi Petr!
Now last version (1.9.1) works.
Thank you!

73! Andrey