Author Topic: Mileage Issues  (Read 741 times)

0 Members and 1 Guest are viewing this topic.

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3158
  • Last Login:Today at 09:42: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? 

Offline neroute2

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1079
  • Last Login:Today at 08:24:29 pm
Re: Mileage Issues
« Reply #1 on: May 19, 2024, 11:03:31 pm »
I ate them. 😋

Offline Markkos1992

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 3158
  • Last Login:Today at 09:42: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


Offline oscar

  • TM Collaborator
  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 1545
  • Last Login:Today at 07:49:03 pm
    • 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: 4619
  • Last Login:Today at 03:21:06 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: 4619
  • Last Login:Today at 03:21:06 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: 4619
  • Last Login:Today at 03:21:06 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.

Online Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2774
  • Last Login:Today at 10:22:05 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.

Online Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2774
  • Last Login:Today at 10:22:05 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.

Online Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2774
  • Last Login:Today at 10:22:05 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: 3158
  • Last Login:Today at 09:42:47 pm
Re: Mileage Issues
« Reply #10 on: May 20, 2024, 08:31:53 am »
Looks much better now!!

Offline michih

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 4619
  • Last Login:Today at 03:21:06 pm
Re: Mileage Issues
« Reply #11 on: May 25, 2024, 01:37:41 pm »
Railways do still need an update to bring mileage back…

Online Jim

  • TM Collaborator
  • Hero Member
  • *****
  • Posts: 2774
  • Last Login:Today at 10:22:05 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: 3158
  • Last Login:Today at 09:42:47 pm
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.