Other SOTA sites: SOTAwatch | SOTA Home | Database | Summits | Video | Photos | Shop | Mapping | FAQs | Facebook | Contact SOTA

Multiple Database/SSO Accounts

After our problems with SOTAwatch on Friday I have been looking into doing some housekeeping.

The first thing that needs cleaning up is all the people with multiple accounts. There are 701 out 19982 database accounts where the same callsign occurs more than once. Quite a few of these are test accounts created by myself, Andrew VK3ARR, Jon GM4ZFZ but there are many people who have multiple accounts for no good reason. It’s a more manageable number when I ask how many people have more than 2 accounts where it’s only 50. That’s where I shall start the cull. Well I will actually start with G3PSB who is one of our record holders with 5 accounts, 2 of which are verified, 3 of which look like they were created when BT was doing its normal act of failing to deliver any email to its paying customers and 1, yes just one with QSOs in it.

Some of these will predate SSO accounts but there are many with multiple SSO accounts too. The grim reaper will be calling on SSO as excess DB accounts get removed.

You, the users don’t have to do anything but you may receive an email telling you the QSOs you had spread over multiple accounts have been merged into one account.


Sounds like a worthwhile cleanup. I dare say most duplications of accounts are accidents as very few people actually want multiples.

Thanks for your work on this problem. The wheels keep turning only because such maintenance is carried out.

73 Andrew VK1DA/VK2UH

1 Like

Most are people who forgot they had an account and created a new one after a period away from SOTA. Or people who never received an email and kept creating accounts, despite being told the username the just created was not available. The fact I could create an MM0FMF account and then a few minutes later get told I can’t create an MM0FMF account should always set alarm bells ringing that something has happened.

So this reaping session is simply to remove all the multiple accounts of the same callsign. There are some people who upgraded licence and have, to use UK centric examples, an FL, IL and Full callsign and 3 separate accounts. That’s a harder job to identify and merge them.

The question is, do they want them merged? :confused:

1 Like

They don’t have any choice!

There’s a distinct difference of some having upgraded their licence level and having multiple accounts for each licence type but only now using only the topmost grade licence and people having multiple licences of the same type and an account for each licence. It’s the first category only that will be merged at a later date.

1 Like

Likewise, a considerable number of people sign up more than once for the SOTA Reflector. As well the reasons this happen are almost the same as Andy lists above and similarly it doesn’t seem to occur to some people that when you are told on signing up that your call sign is not available that you clearly already have an account so need to use the Forgotten Password process to get access to it and reset your password. Of course if you have changed you email address and no longer have access to it, you need to ask someone who has an admin role to fix it for you.

I started the big multiple account cleanup today.

Over 30 multiple accounts have been created this year in the Indonesian association and in this case I think it is probably an issue with language.

I have also cleaned up all the people with 4 or more accounts. That’s 30 people times 4 accounts plus more, about 80 accounts. Now to start on the 3 or more account holders were there are 43 such users so another 86 accounts to remove.

It’s difficult because every account needs checking in case there are logs spread over the accounts and those logs need moving to the final account these 43 users will have. The big one is the list of people with just 2 accounts, 687 people. I’m going to do that cleanup job in stages.

Hi Andy, I am not sure that naming names on the reflector is possibly the best way to welcome a newcomer to SOTA.
I found " getting in" was a trial and, as you said, BT does not always help.
Perhaps a helping hand or a constructive email might be a better option to welcome a new boy to our wonderful hobby.
73 Dave G3TQQ

He lost the record to an LU station who had 8 accounts all with derivatives of his call as username and a DJ with 7 accounts.

1 Like

Well I’m down to the 22 people with 3 or more accounts with the same callsign down from 40+. I’m also working on removing or fixing the 133 accounts where people have not set a callsign. Looking further 48 of those people who haven’t set a callsign have a Home Association of Bouvet Island - 3Y. This is amazing and the scientists on that remote island have done a great job of keeping those 48 extra people well hidden all these years. Well actually 3Y is the first association in the list when registering, so these are people who never set their home association and probably are ripe for automatic removal as they will not be participating in the program!

The painful job will be working on the 682 people with only 2 accounts in the same name. :frowning:


One month later…

of the 42 people emailed who had not set a callsign and claimed to be on Bouvet 3Y, only 3 added their callsign but they didn’t update their home association. They now have XXX- No Association yet as a home.

Examining the other accounts showed many accounts were unverified or never used and so have been deleted.

A few more people decided that if one account is good then three must be excellent, the logs have been coalesced into a single account and excess accounts have been culled.

That leaves now 134 people who think they live on Bouvet Island and 732 who had 2 accounts with the same callsign.


If the first entry in the country list was Mars, i dare say the same number would claim to live there too. An artifact of the first entry being the default value.
Big job, thanks for all this.

73 Andrew VK1DA/VK2UH

1 Like