Jeremy Fleischman

Search/sort having trouble with special characters

7

https://www.worldcubeassociation.org/search?q=lapicki doesn't find https://www.worldcubeassociation.org/results/p.php?i=2006LAPI01. Neither does https://www.worldcubeassociation.org/results/persons.php?eventId=&regionId=&pattern=lapicki&search=Search

Port /results/admin/ scripts to Rails

6

In preparation for porting the results admins cripts to Rails, @SAuroux just walked me through the uploading process for BASC 8. We had the opportunity to talk a bunch, and...

persons_check_finished.php incorrectly detects names differing due to accents as the same name

6

See [this check for duplicates query](https://github.com/jfly/worldcubeassociation.org/blob/898142d37dd3b45b8c9c18ccc9b4ae996ada0ba6/webroot/results/admin/persons_check_finished.php#L245-L250). Unfortunately, our version of mysql (5.6) does not support accent sensitive collations (they were added in mysql 8, see [this comment](https://github.com/thewca/worldcubeassociation.org/issues/258#issuecomment-323839095) for more details)....

Right now, it only looks at competitions that ended before the competition we're looking at started. With the current regulations, there are a few cases where we cannot know whether...

Only allow one person to upload results at a time

2

Right now, people can start uploading results for a competition simultaneously, which can result in a mess. It would be cool if people first had to grab a lock before...

Results php tables names don't follow ActiveRecord conventions

10

Generally, this isn't a problem, as we can override table names with ActiveRecord's table_name attribute. Rails appears to be pretty attached to its `id` column as an INTEGER, however. See...

Schedule validations/sanity checks

4

(cc-ing @viroulep for his thoughts. This might be redundant with some of his work in https://github.com/thewca/worldcubeassociation.org/pull/3207, which I have not looked at yet) Some people have brought up some schedule...

WCA Style Guide?

3

I'm creating this issue to continue the discussion from https://github.com/thewca/worldcubeassociation.org/pull/2988#issuecomment-399254732. @AlbertoPdRF recently went through and changed all occurrences of "delegate" to "Delegate". That reminded me that we've had a number...

If I delete a file in a `1-in` directory, re-running `hledger-flow import` does not remove the corresponding files in the `2-preprocessed` and `3-journal` directories

4

First off, thanks for a wonderful tool! **Describe the bug** If I delete a file in a `1-in` directory, re-running `hledger-flow import` does not remove the corresponding files in the...

`asdf-nodejs` currently sets `NODE_BUILD_BUILD_PATH` and `NODE_BUILD_CACHE_PATH` [to the same directory](https://github.com/asdf-vm/asdf-nodejs/blob/ad4c3a7b547b730aabc74d8e98ce806137f8ad40/bin/install#L52-L53) This results in some very weird behavior which I've documented here: https://github.com/asdf-vm/asdf-nodejs/issues/289. My guess is that node-build doesn't expect or...