« previous next »
Pages: [1] 2

Author Topic: Mileage Issues  (Read 13119 times)

0 Members and 1 Guest are viewing this topic.

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3307
  • Last Login:Yesterday at 10:09:47 pm
Mileage Issues
« on: May 19, 2024, 10:33:49 pm »
How come most mileage statistics have all of a sudden ended up at 0? 
Logged

Offline neroute2

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1145
  • Last Login:Yesterday at 11:10:43 pm
Re: Mileage Issues
« Reply #1 on: May 19, 2024, 11:03:31 pm »
I ate them. 😋
Logged

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3307
  • Last Login:Yesterday at 10:09:47 pm
Re: Mileage Issues
« Reply #2 on: May 19, 2024, 11:45:40 pm »
My stats page is showing the below line: https://travelmapping.net/user/?units=miles&u=markkos1992

Warning: Division by zero in /fast/www/tm/user/index.php on line 231

Logged

Offline oscar

  • TM Collaborator
  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1585
  • Last Login:Today at 01:52:38 am
    • Hot Springs and Highways pages
Re: Mileage Issues
« Reply #3 on: May 20, 2024, 12:14:43 am »
That affects Showroute's display of my mileage on specific routes, including some in the Midwest I just clinched in the last few days, and others elsewhere I clinched earlier this year. Showroute still shows me as having clinched those routes, just screws up the percentages.
Logged

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4863
  • Last Login:Yesterday at 01:15:00 pm
Re: Mileage Issues
« Reply #4 on: May 20, 2024, 01:16:46 am »
The whole site indicates 0 miles for all users (railway too). It seems to be a general issue beyond hwy data but anything "in the code" or "in the infrastructure".
Logged

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4863
  • Last Login:Yesterday at 01:15:00 pm
Re: Mileage Issues
« Reply #5 on: May 20, 2024, 01:21:56 am »
I think it happened when a data processing speedup was deployed.
Logged

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4863
  • Last Login:Yesterday at 01:15:00 pm
Re: Mileage Issues
« Reply #6 on: May 20, 2024, 02:17:29 am »
It seems to be an issue with MySQL. Jim simply needs to deploy the old code and run an update again.
Logged

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2856
  • Last Login:Yesterday at 10:18:04 pm
Re: Mileage Issues
« Reply #7 on: May 20, 2024, 07:47:42 am »
It looks like every segment length in the .sql file generated by site update is in a format that mysql doesn't like.

I've got a busy day today but will see if I can get the code reverted and run a site update again.  Or better yet, @yakra has a quick fix and I'll run a new update with his new code plus bugfix.
Logged

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2856
  • Last Login:Yesterday at 10:18:04 pm
Re: Mileage Issues
« Reply #8 on: May 20, 2024, 08:10:07 am »
As expected, git is my friend and let me quickly check out an older version.  Recompiled, re-ran the site update, and we look to be good.
Logged

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2856
  • Last Login:Yesterday at 10:18:04 pm
Re: Mileage Issues
« Reply #9 on: May 20, 2024, 08:13:10 am »
FYI, I had to do a hard reload on some pages to force it to re-read the DB after the site update.
Logged

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3307
  • Last Login:Yesterday at 10:09:47 pm
Re: Mileage Issues
« Reply #10 on: May 20, 2024, 08:31:53 am »
Looks much better now!!
Logged

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4863
  • Last Login:Yesterday at 01:15:00 pm
Re: Mileage Issues
« Reply #11 on: May 25, 2024, 01:37:41 pm »
Railways do still need an update to bring mileage back…
Logged

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2856
  • Last Login:Yesterday at 10:18:04 pm
Re: Mileage Issues
« Reply #12 on: May 25, 2024, 02:44:21 pm »
Quote from: michih on May 25, 2024, 01:37:41 pm
Railways do still need an update to bring mileage back…

Done.
Logged

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3307
  • Last Login:Yesterday at 10:09:47 pm
Re: Mileage Issues
« Reply #13 on: May 26, 2024, 11:57:39 am »
Quote from: michih on May 25, 2024, 01:37:41 pm
Railways do still need an update to bring mileage back…

Thank you for catching that.  I actually need to update my list file there due to myself clinching some DC Metro Mileage yesterday going to/from the Nats game corco invited myself and some other northeast road enthusiasts to.
Logged

Offline bejacob

  • Full Member
  • ***
  • Posts: 233
  • Last Login:Yesterday at 07:46:49 pm
Re: Mileage Issues
« Reply #14 on: August 12, 2024, 12:54:03 pm »
On the subject of Railways, is there any plan to add the Athens (GRC) Metro and/or trams?
Logged
Pages: [1] 2
« previous next »