Author Topic: Mileage Issues  (Read 13509 times)

0 Members and 1 Guest are viewing this topic.

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3313
  • Last Login:Today at 06:29:28 am
Mileage Issues
« on: May 19, 2024, 10:33:49 pm »
How come most mileage statistics have all of a sudden ended up at 0? 

Offline neroute2

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1150
  • Last Login:Today at 02:33:49 am
Re: Mileage Issues
« Reply #1 on: May 19, 2024, 11:03:31 pm »
I ate them. 😋

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3313
  • Last Login:Today at 06:29:28 am
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


Offline oscar

  • TM Collaborator
  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1586
  • Last Login:Today at 02:08:02 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.

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4873
  • Last Login:December 09, 2024, 12:18:47 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".

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4873
  • Last Login:December 09, 2024, 12:18:47 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.

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4873
  • Last Login:December 09, 2024, 12:18:47 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.

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2859
  • Last Login:Yesterday at 10:46:53 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.

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2859
  • Last Login:Yesterday at 10:46:53 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.

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2859
  • Last Login:Yesterday at 10:46:53 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.

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3313
  • Last Login:Today at 06:29:28 am
Re: Mileage Issues
« Reply #10 on: May 20, 2024, 08:31:53 am »
Looks much better now!!

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4873
  • Last Login:December 09, 2024, 12:18:47 pm
Re: Mileage Issues
« Reply #11 on: May 25, 2024, 01:37:41 pm »
Railways do still need an update to bring mileage back…

Offline Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2859
  • Last Login:Yesterday at 10:46:53 pm
Re: Mileage Issues
« Reply #12 on: May 25, 2024, 02:44:21 pm »
Railways do still need an update to bring mileage back…

Done.

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3313
  • Last Login:Today at 06:29:28 am
Re: Mileage Issues
« Reply #13 on: May 26, 2024, 11:57:39 am »
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.

Offline bejacob

  • Full Member
  • ***
  • Posts: 234
  • Last Login:Yesterday at 08:34:44 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?