I’ve just uploaded a bug fix for the database. Actually 3 bugs and an enhancement.
OH display bug. Display info for OH summits that have a bonus finishing on 29th February would cause an exception. Now fixed.
Activation count bug. The only way to fix activation logging errors is to delete the activation log and upload the corrected version. However, a bug in the activation count code meant that when a log was deleted the count was not adjusted down. So a single activation with logging error could result in the summit’s activation count being 2. This is fixed and the activation count is now derived from the number of activations logged and should always be correct. As a side effect, any summits that have an incorrect count will correct themselves when a new activation is logged. Given the time the database will heal itself but unlike Skynet should not become self-aware and destroy mankind!
Last activator bug. Related to the above. When logging an activation, the last activator and last activation date was whoever last submitted a log for this summit irrespective of the activation date. Now fixed, the last activator will now be the person with the newest activation date. Here’s the cool bit… if you delete an activation the last activator and date are found from the activations and updated. This means activations can be added and deleted in any order and the last activator and date will be correct.
Files for download like the summitslist.csv are rebuilt by the code every 24hrs. There is a possibility that someone may try to download these files when the database is recreating them resulting in short files. Now changed so the file is deleted, then a temporary file is created and finally renamed. If you hit the update time you will either get no file found or a valid file. It should not be possible to get a short file. (This is not the Firefox 9.0.1 issue some people have seen.)
Fixing the last activation details and count was a royal pain in the bum. Involved and fiddly for only a marginal benefit but it accounted for a disproportionate number of emails in my inbox!
If you find any problems that seem related to the changes, don’t post them here but email me at mm0fmf_sota AT intermoose.com and put the word DATABASE in the subject somewhere.