Web Design Discussion > General Web Design Discussion

Connected Route Question

(1/5) > >>

Markkos1992:
This is something that has confused me since we made it doable to see entire Connected Routes.

The Connected Route page for DE/PA/NJ I-295  currently has 139 drivers with 129 having clinched it.

However, when you look at the specific state pages, you get this:

DE: 110 drivers, 109 clinched (noting that this is one of if not the most traveled sections of route in TM overall)
NJ:  110 drivers, 57 clinched
PA:  65 drivers, 55 clinched

So theoretically, there should be at most 55 people (including myself) that have clinched the entire route.  I wonder what is in the program causing these odd discrepancies.

Jim:
Doesn't sound right for sure.

I don't have time to check it out immediately, so I've created a GitHub Issue to make sure it does get investigated.

https://github.com/TravelMapping/Web/issues/542

yakra:

--- Quote from: siteupdate.log ---HighwayData @ 4001f70ba7d298b2a019114696a0fce72455f76b
UserData @ bafd52681fb7ac64062a1aa7e563d351f543261a
DataProcessing @ 11be967a819fcd28f05582cb1050a721494c3596
Start: 2020-09-23 21:49:20.690292

--- End quote ---


--- Quote from: Markkos1992 on September 21, 2020, 06:35:01 pm ---The Connected Route page for DE/PA/NJ I-295  currently has 139 drivers with 129 having clinched it.
However, when you look at the specific state pages, you get this:
DE: 110 drivers, 109 clinched
NJ:  110 drivers, 57 clinched
PA:  65 drivers, 55 clinched

--- End quote ---
The HB still reports this as of this writing, on both noreaster & lab2.

user logs:
ConnectedRoute has 160 drivers; 42 clinched

--- Code: ---[yakra@noreaster /home/www/tm/logs/users]$ grep 'Delaware - New Jersey - Pennsylvania' *.log | wc -l
     160
[yakra@noreaster /home/www/tm/logs/users]$ grep 'Delaware - New Jersey - Pennsylvania.*(100\.00%)$' *.log | wc -l
      42
--- End code ---

Choped routes:

--- Code: ---[yakra@noreaster /home/www/tm/logs/users]$ grep 'DE I-295:' *.log | wc -l
     144
[yakra@noreaster /home/www/tm/logs/users]$ grep 'DE I-295:.*(100\.00%)$' *.log | wc -l
     138
[yakra@noreaster /home/www/tm/logs/users]$ grep 'NJ I-295:' *.log | wc -l
     152
[yakra@noreaster /home/www/tm/logs/users]$ grep 'NJ I-295:.*(100\.00%)$' *.log | wc -l
      57
[yakra@noreaster /home/www/tm/logs/users]$ grep 'PA I-295:' *.log | wc -l
      65
[yakra@noreaster /home/www/tm/logs/users]$ grep 'PA I-295:.*(100\.00%)$' *.log | wc -l
      55
--- End code ---
Same results on lab2.

db queries on lab2:

--- Code: ---mysql> select * from clinchedConnectedRoutes where route = 'de.i295';
160 rows in set (0.01 sec)
mysql> select * from clinchedConnectedRoutes where route = 'de.i295' and clinched = '1';
42 rows in set (0.00 sec)
mysql> select * from clinchedRoutes where route = 'de.i295';
144 rows in set (0.00 sec)
mysql> select * from clinchedRoutes where route = 'de.i295' and clinched = '1';
138 rows in set (0.00 sec)
mysql> select * from clinchedRoutes where route = 'nj.i295';
152 rows in set (0.00 sec)
mysql> select * from clinchedRoutes where route = 'nj.i295' and clinched = '1';
57 rows in set (0.00 sec)
mysql> select * from clinchedRoutes where route = 'pa.i295';
65 rows in set (0.00 sec)
mysql> select * from clinchedRoutes where route = 'pa.i295' and clinched = '1';
55 rows in set (0.00 sec)
--- End code ---
...whether a C++ or Python-flavored siteupdate.

It appears something goes wrong on the Web (PHP?) side while/after getting results from the DB.

yakra:
If I had some way to conveniently copy the tooltip text for Total Drivers & Total Clinched, maybe that could provide an avenue to explore...

Jim:
Offending query seems likely to be here:

https://github.com/TravelMapping/Web/blob/02861e7723d7bc64f937fd59277359677c4e94c5/lib/getRouteStats.php#L51

Navigation

[0] Message Index

[#] Next page