Travel Mapping
User Discussions => Other Discussion => Topic started by: Markkos1992 on May 19, 2024, 10:33:49 pm
-
How come most mileage statistics have all of a sudden ended up at 0?
-
I ate them. 😋
-
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
-
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.
-
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".
-
I think it happened when a data processing speedup (https://github.com/TravelMapping/DataProcessing/pull/623) was deployed.
-
It seems to be an issue with MySQL (https://github.com/TravelMapping/DataProcessing/pull/623#issuecomment-2119732971). Jim simply needs to deploy the old code and run an update again.
-
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.
-
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.
-
FYI, I had to do a hard reload on some pages to force it to re-read the DB after the site update.
-
Looks much better now!!
-
Railways do still need an update to bring mileage back…
-
Railways do still need an update to bring mileage back…
Done.
-
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.
-
On the subject of Railways, is there any plan to add the Athens (GRC) Metro and/or trams?
-
On the subject of Railways, is there any plan to add the Athens (GRC) Metro and/or trams?
Yes, but not this week unless someone that isn't me adds it (I don't care if I'm gazumped here).
That said, I added Kuala Lumpur instead of Athens (which I had planned to be the next city I drafted). But as there's demand, it would probably be a job for next Monday (after I get back from holiday).
-
No urgency. I appreciate what's already there.
I was just looking back over my travels and recalling places where I rode metros/trams and noticed it Athens wasn't represented (yet). Truly glad for how much is there and sad I haven't ridden more