Yes, he has two accounts (under LZ2JPN). When he is logged in there’ll be big banner at the top saying “Please contact the MT to remove your second account” because a) you shouldn’t, and b) it breaks things like this. It is likely that Andy has already emailed him a couple of times to try to fix this.
1 Like
TNX I try to contact with him.
Since I started cleaning up the accounts I have deleted over 1100 duplicate accounts. Each dupe has to be checked manually to see if there are logs in both accounts and the logs merged. There are 140 left to process. I’ve also deleted 347 accounts where the holder said they were resident on Bouvet Island. There are also 105 where the account holder has no callsign set. Some of these are SWL accounts.
There are about 10-15 new accounts created each week where the account holder does not set their home association. The holders get emailed and asked to update the account or it will get deleted after a few days. About 20% of them reply or update their account and the rest are deleted.
Worst “offender” for multiple accounts had a total of 13 accounts. I think he didn’t understand the difference between registering for an account and logging into an account he had created.
4 Likes
You know, I was always led to believe that Bouvet is uninhabited - 347 hams to work there !!
Joking apart - Thanks for all the work you do and have done for a long time, behind the scenes Andy - it is appreciated even if we don’t say so that often.
73 Ed.
3 Likes
It’s nice to get thanks but the real “heavy lifting” work over the last few years has been by Andrew @VK3ARR This kind of programming work (web sites etc.) is closely related to his job whereas my programming work is Linux kernel work, USB and Ethernet drivers, embedded applications and infrastructure. It was Jon GM4ZFZ who picked the software we use for this reflector. I didn’t like it at first but I have come to really like it. But Andrew has done 99.99% of the programming you see on SOTAwatch, the database and the hidden systems underpinning everything. Nowadays I do mainly admin stuff, updating the summits once/month, maintaining peoples accounts, along with the SMS spotter and the SOTA cluster. Andrew built a rather reliable system so that when it goes wrong myself and Josh @WU7H have to scratch our heads to figure out what is broken, especially as we have some redundant systems.
Josh and Elliott @K6EL do huge amounts of community building and support work in the US which helps lighten the load. Jim @G0CQK is the reflector admin, he spends a vast amount of time ensuring people who sign up are not spammers and also keeping on top of Discourse software and theme changes so that we have a consistent reflector UI. Brian @G8ADD reads all the messages as chief moderator and ensures standards are maintained. Tom @m1eyp keeps a stream of SOTA stories appearing in the radio press. There’s Simon @G4TJC, Csaba @YO6PIB and Warren @ZL2AJ working on the summits.
And finally we have Barry @GM4TOE. Barry is treasurer and runs the awards and merchandise sales. Without Barry doing his huge amounts of work we’d have no money to pay the annual hosting costs. Those costs are running around $250-$275US per month.
I just hope I’ve not forgotten anyone.
15 Likes
Neither do I. Send me the CSV/ADIF and I’ll look.
Sorry, I lost all after a timeout of my session. I reenter all in the old database, here are the successful result in Sotl.as.
73 Chris
1 Like
My suggestion is to use something like FLE or just manual CSV creation. I have a CSV file that I edit and re-edit time and time again for log entry. Takes moments to prepare the last version for the new version then type times and calls and maybe S2S ref. I may try FLE one day but for now, tweaking a previous CSV works and is painless. (I use LibreOffice on Linux and Windows as it’s free and I’m cheap!)
Having a CSV means I’m only at the hands of my own typos, I am immune to any system issues/bugs/outages etc. as I always have MY file to retry.
Josh @wu7h suggests FLE to all people in the US he helps with issues. That doesn’t mean there isn’t a bug. Though I did see the DB engine restart today at 1329Z, we are having an intermittent scale/load issue with it. The engine is running after about 2mins but it can take 10-15mins for all the other services that were stalled when the DB engine restarted to spot it has crashed and burned yet has risen from its own ashes like a Phoenix 
Maybe you were just active at this point?
1 Like
The database tried to allocate a very large amount of memory just prior to that, and failed, and was in the process of autorestarting at the time.
2 Likes
Thanks everyone. Looking at those costs to keep thing running maybe we activators should not only be handing out chaser points and collecting MG merch. But not “buy a coffee”, “buy a tank of fuel” in the form of a Donation at the store. My average SOTA trip tank of fuel is $70 for a day trip more if I do several days burning up the liquid gold. I probably guess several folks do give donations at the store to keep these great volunteers in there tasks to keep the show running.
Regards.
Ian vk5cz …
2 Likes
Great idea, Ian. I diary twice a year to donate 100 British pounds each time. If a few dozen SOTA enthusiasts did that, we would be 90 percent there, methinks.
Elliott, K6EL
1 Like
I just donated 60 euros.
https://sota-shop.co.uk/donations.php
73 Chris
2 Likes
Thanks for the clarification Andrew. With my last three uploads everything went well and that’s why I was a bit irritated.
Thanks again for the convenient input option.
73 Chris
Hi Chris
Thanks for the S2S, i was on HB/SO-020 but… Juerg HB9BIN, he was in Germany on:
DL/AM-177. Just for your information.
Cu again…
73 de Bruno HB9CBR
1 Like
As a former high school computer science teacher, I’ve sat at a computer so much that I hate turning it on now. That’s why I do the upload after activation just before my nap using a tablet in bed. And that’s why I like to use the input option of the database.
73 Chris
1 Like
Very thoughtful of you, Bruno. Also Markus, HB9DiZ has already pointed out the error to me and even suspected that the database has therefore refused my input. 
I made a mistake when entering the line and have now corrected it.
Many thanks for the many S2S, dear Bruno. And if Jürg is reading along here, you too, of course.
Jürg, I always have a grin on my face when you come back with my call immediately after my S2S and only recognize me by my keying. Fantastic!
73 Chris
Chapeau bas Gentlemen 
73, Jarek
6 Likes
Not sure if it has been looked at or missed in the melee the bug report I mentioned in about Post 10 of this topic part 3 regarding deletion of SWL entries not working.
Just when you get a mo
Ian
G7ADF