Mileage Issues

[Markkos1992]

How come most mileage statistics have all of a sudden ended up at 0? 

[neroute2]

I ate them. 😋

[Markkos1992]

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

[oscar]

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.

[michih]

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".

[michih]

I think it happened when a data processing speedup was deployed.

[michih]

It seems to be an issue with MySQL. Jim simply needs to deploy the old code and run an update again.

[Jim]

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.

[Jim]

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.

[Jim]

FYI, I had to do a hard reload on some pages to force it to re-read the DB after the site update.

[Markkos1992]

Looks much better now!!