Web Team Update - December 2025

Climbing

Member-facing changes:

 

RBA support:

  • Added authentication/authorization to self-service elevation assignment tool and added a login redirect. Linked tool from main navigation.
  • Update event climbing data when changing the assigned route through self-service route assignment tool.
  • 2026 Climbing FAQ for Organizers

 

Back office support:

  • Events management - Update event climbing data when changing the route.
  • Events report - Added climbing.
  • Perm routes management - Validate that a RideWithGPS route is supplied for all active permanents. Scrape climbing and net elevation data from RideWithGPS. Add a warning when RWGPS distance differs from perm route distance.
  • Perm routes report - Added net elevation. Added sorting/filtering on Active flag.

 

Data:

  • Backfilled elevation data for calendared 2026 events based on current attached route.
  • Backfilled climbing and net elevation data for all active permanents. Flagged distance discrepancies for the perms committee to resolve manually.

 

Misc:

  • Removed all management and usages of perm route fields: reversible, free-route, and climb determination method. Applied the effective defaults across all previous usages in the code base. The climb determination method is now always RideWithGPS. All non-SR600 permanents are assumed to be free-route and reversible.

 

Remaining work:

  • Climbing display for member results pages.
  • Permanents results submission workflow updates.
  • RBA results submission workflow updates.
  • Back office results management updates.

Permanents

Streamlined the perms program registration workflow since no payment is required for 2026.

Server Maintenance

Server upgrade:

  • Debian 9 (stretch)→12.12 (bookworm)
  • Drupal 9.5→10.5.6
  • Perl 5.24→5.40
  • PHP 7→8.2.29
  • nginx 1.10.3→1.22.1
  • MariaDB 10.1→10.11.14

 

Bug fixes from server upgrade:

  • Fixed back office authentication. Users can now change their passwords again.
  • Bug 1157 - Fixed error when registering or submitting results for a permanent that had an unassigned unpaved distance.
  • Bug 1158 - Fixed error when perm search for ride registration returned no results.
  • Bug 1159 (WIP) - Drupal member details page explodes for members without any volunteer titles.

 

Server reliability:

  • Mitigated a DOS from a bot farm in Singapore.
  • Handled another SmartWaiver API outage. Redesigning the perm ride registration workflow to be more robust against future outages.

Checkpoint Opening / Closing Times Page

As part of our 2025 goals, we’ve created a new page - Checkpoint Opening / Closing Times - to be referenced by Rules for (Event) Organizers, Rules for (Event) Riders, and Rules for Permanent Riders. It is in review by the Web Team, and next will go to Rules.

Miscellaneous

  • Bugs 1088 and 1152 - Fixed unpaved distance for a handful of team events.
  • American Explorer - Exclude pre-1999 rides from calculations. Include populaire results in member report calculations.
  • Bug 1147 - Fix flèche results CSV export for team names that include quotes and commas.

 

Respectfully submitted,

- Lois, Charlie, Man-Fai, Paul, JLE, and Jeff