This Strip is Not Safe For Work!

`Peyo` I was trying to @ nooz in a strip that completed and when I did it kept changing it to aim the mention at noozz. When I went to edit I'd see the mentioned name in single quotes. No idea what was going on there but I thought I'd mention it, and if you want to check the mention it was in the comments of this strip: https://pchutney.com/strip/1252 The weirdest thing is I never typed it any way except for nooz

What bad nooz, rocks off my shooz. Seems like mentions code needs its fair dooz. Exact match, or auto complete, you must chooz. Best if only one you yuuz. I ought to lay off the booz.

It would be great if every one of those ooz words atted nooz!

I investigated the problem: the probable cause is that nooz has two users with very similar usernames* (he lost the password for the old one according to his description at least [/user/39](/user/39) ) and this confuses my mention system which goes for the oldest username it can find with a similar name (that's my theory anyhow) so far my proposed solutions are: - I change it so default mentions are generated with user id instead of name (when you click on someones name in the comments) so the mention system doesn't get confused - I help `nooz` recover his old account so he gets these mentions too - I just change the name on his old account so the mention system doesn't get confused (there is probably a better way -- fixing the mention system somehow comes to mind -- but I still have trouble thinking straight so I'm not sure how ) edit: *and by username i mean the displayed name (true usernames are not public and only for login)

`Peyo` I'm not sure what your relationship with coding is but the way I would have handled this back when I used to code was by doing a search for the exact string first (I don't imagine that would be much of a problem on here since the user base is pretty small) and then failing that have it start seeking a partial match, but also a more hardcore (but less error prone) approach would just be having anything but an exact match fail, since we can edit comments after the fact anyway. However, speaking of user numbers, that actually would have always been my approach would be to first reduce a string to a number/database reference and use that for the process.

`TeeEffDee` I guess one solution could be to add an extra check for an exact match of the name reducing string to database: we kind of do that -- it's just a bit over-engineered: there was concern about very long names and names with spaces in them -- so the system tries to auto-complete the names -- in this case: it tried to find any name like 'nooz' it's just that 'noozz' was a similar name and was found earlier in the database (as it was made earlier and has a lower id number)

ok it should now check for exact name first this is just a test don't be alarmed `noozz`

well.. back to the drawing board

`Peyo` I'm sorry to hear it's not working as you wish but figuring out how to reliably do an exact string match is something definitely worth getting down. That's gold!

hear hear .. sadly still WIP .. (SQL is hard to tame)

`Peyo` I was looking around for possible solutions and found out using back ticks like ` instead of straight up quotes like ' can cause an issue with matching. I checked and noticed when I edited the Nooz post that the edit has back ticks. Maybe using straight quotes is worth a try.

unfortunately that is just a markdown ( meant to be an indicator that the mention was succesful) ``(you can write any text between the ticks and make it look like this)`` (it was done this way so after you mention someone and edit a post you don't send a second mention -- unless you add the name with the @ symbol again)

This kind of shows my level of knowledge on the matter! It sounds like you will find a solution soon, and great work so far!

here we go again.. sorry for using you for testing `nooz`

ok seems good enough (I accidently left the % symbol that is needed for sql like command for the exact name search)

`Peyo` I went and edited the original post and it seemed to work great now! Excellent! Also I wanted to test the `Peyo` functionality so, now is as good a time as any.

`⚰` `🔳` (sorry guys just using your names for testing)

`Peyo` 👍