"Unranked" users

[michih]

Thanks, I've updated listfileinfo.csv the other day. The users are still indicated with ranks on tmstage - albeit it's indicated The most recent TM - Highways site update completed at 2024-06-28 22:21:30 US/Eastern.
I guess that you've simply not updated UserData for tmstage?

[Jim]

I'll try to reload the next .sql I generate into the test db for use on tmstage.  I'm not spending too much time automating updates of the test db since I hope to have this all live on the production database and main site before too long.

[Jim]

On tmstage, we now have /stat.php, /user, /user/region.php, and /user/system.php behaving as I intend with respect to unranked users.

Left to do: traveler counts and lists on hb/showroute.php and user/mapview.php, colors for "Color by Traveler Count" on user/mapview.php.

Also, the newest listfileinfo.csv (and newest of all other TM data) have been loaded into the test db so are on tmstage.

Again, please feel free to add entries to listfileinfo.csv for your highway list file(s), normal or "unranked".

[michih]

Looks good I just like to have any info why there is no rank for those users in the 'Traveler' tables, e.g. a tooltip.

I also wonder if you wanna output the last column of listfileinfo.csv anywhere on the site, or if we just use it to indicate in the csv itself why that user is to be unranked.
Proposal: Below the headline, i.e.
- user new line below 'Main Travel Mapping - Highways User Page for ***'
- region.php new line below 'Traveler Statistics for *** in ***'
- system.php new line below 'Traveler Statistics for *** on *** in ***'

[Jim]

On tmstage, mapview and showroute now ignore unranked users.

Thanks, @michih for the other suggestions, will look at those soon.

Have I missed any other places where unranked users should be ignored?

I plan to have this go live on the main site soon, closing the big GitHub issues regarding this new feature, then we can open new issues for bugs and feature requests to track them more easily.

[michih]

Have I missed any other places where unranked users should be ignored?

I'm not aware of any.

[Jim]

This is all live in the production database and on the main site.  Please report any problems or make any suggestions here or open new GitHub Issues.

[yakra]

9aafcf9 came about a month after the switch to MariaDB.
lab2 is still running mysql 8.0.16. It tells me:

ERROR 1064 (42000) at line 14223312: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS idx_com_region_traveler ON clinchedOverallMileageByRegion' at line 1

I'll see about updating my software. Maybe even my OS if I have to.
Might be less headache to set up MariaDB on another machine first and see how it does.
In the meantime, I think I may be able to just not create these indices on lab2 to do what I wanna do there.